How to sort a matrix group with an expression?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » How to sort a matrix group with an...

How to sort a matrix group with an expression?

Rate Topic

Display Mode

Topic Options

Author

Message

manuelroman98

Posted Wednesday, August 15, 2012 4:21 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:26 PM
Points: 21, Visits: 131

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 »

Permissions