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

SSRS Matrix Sort query Expand / Collapse
Author
Message
Posted Monday, July 28, 2014 6:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 5:13 AM
Points: 15, Visits: 44
Good Afternoon

I have a matrix within SSRS I am trying to sort on. My matrix looks like as below:

--Months--
Month A Month B
Report A 12 32
Report B 34 54
Report C 11 2
Report D 6 45
Report E 15 12

Where the numbers represent number of views. The month titles are dynamic so they update when a parameter is amended. Please can you tell me how to sort the list of report names by the column title Month B (this is a grouped filter where the data comes from a source called MonthNumber.

Thank you in advanced.

Abbie
Post #1596812
Posted Tuesday, July 29, 2014 5:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:54 AM
Points: 243, Visits: 2,753
you should be able to go to the group properties for month then sort on the month field
Post #1597223
Posted Tuesday, July 29, 2014 6:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 5:13 AM
Points: 15, Visits: 44
Hi Scott

Thank you for your reply, unfortunately it won't sort by month as within the dataset itself month 4 and 5 are under one column (so it doesn't sort correctly) namely 'MonthNumber'
Post #1597254
Posted Tuesday, July 29, 2014 7:13 AM This worked for the OP Answer marked as solution
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 5:13 AM
Points: 15, Visits: 44
I've managed to fix it by using the following sort fx within the row group:

=Sum(IIf(MonthName = ParametersMonth, Views, 0))
Post #1597274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse