I have a report that i cannot make it sort on a group based on an expression.
I have another report that i am using the same expression and works fine.
The follwing is the expression that i am using.
=Switch(Fields!U_MajRegion.Value=
"New England","1",
Fields!U_MajRegion.Value=
"North","2",
Fields!U_MajRegion.Value=
"Southeast","3",
Fields!U_MajRegion.Value=
"Central","4",
Fields!U_MajRegion.Value=
"West","5",
Fields!U_MajRegion.Value=
"Canada","6",
Fields!U_MajRegion.Value=
"Latin America","7",
Fields!U_MajRegion.Value=
"Texas","8")
I've also used the iif() function and nothing happens. Any suggestions?.... i am using ssrs 2005
The sorting is on the second column.
Regards,
Manuel Roman