You should be able to do this on the underlying query of the report
select state, iif(state="NY",1,2) as sort_order from xyz sort by iif(state="NY",1,2),state
OR
select state, 1 as sort_order from xyz where state="NY"
UNION
select state, 2 as sort_order from xyz where state<>"NY"
order by sort_order
The other option is to set two sub-reports, filter one for NY only and the next one for anything other than.
Ricardo A. Parodi
eSolar, Inc.
