Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to sort a matrix group with an expression? Expand / Collapse
Author
Message
Posted Wednesday, August 15, 2012 4:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 15, 2014 4:03 PM
Points: 21, Visits: 145
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
Post #1345196
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse