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

Problems with interactive sorting with Row groups in a table Expand / Collapse
Author
Message
Posted Wednesday, September 4, 2013 3:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:12 AM
Points: 30, Visits: 76
Hi I am developing report in SSRS using Table Item. I develop the report in which some fields are group fields and some are detail fields. I implement the interactive sort on group fields but when i click on the sorting buttons in runtime I am able to sort only using the first Group(in my case it is Region) and I can't sort by using state and othe detail fields.
For Eg lets consider I have


Region State Column 1 Column 2 Column 3

east state1 blah 1 blah 2 blah 3

state 2 blah 1 blah 2 blah 3



West state 1 blah 1 blah 2 blah 3




Can any one please help in this scenerio?
Post #1491196
Posted Wednesday, September 4, 2013 6:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:47 PM
Points: 1,170, Visits: 1,211
Can you change what you're sorting by from a single field to an expression? Perhaps concatenate the region, state, ... and then sort by that expression.

Just a thought,
Rob
Post #1491246
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse