SSRS 2008 - Interactive Sorting of Matrix column not working
I'm using SSRS 2008 and have created a Matrix report which has the following fields: Name, Address, City, State, Zip, and [Month] (a matrix column group field).
I have successfully added interactive sorting to the Name, Address, City and State fields. However, I cannot get interactive sorting to work on the [Month] matrix field. The value for the matrix data field equals
[Sum(#Count)].
I want to be able to have interactive sorting on each month's count. So if I click on a month (i.e. 1/2010) I should have
the highest/lowest count values sorted. No matter what I do the interactive sorting doesn't do anything when I click on it for any of the months.
Name Address City
State Zipcode 1/2010 2/2010 3/2010
Adams, Sam 1 Bedrock Way RENTON WA 98055 48
44 47
Smith, James 100 Broadway AUBURN WA 98001 0
2 8
Whitcome, Bob 209 Park Ave N AUBURN WA 98001 2
0 3
Zumes, Will 3900 Talbot Rd SEATTLE WA 98122 0
0 0
How do I get interactive sorting to work on the matrix field?
February 17th, 2011 7:48pm
John, you may have more success posting your question in a SQL Server Reporting Services Forum.
Moderators can move your thread to the correct forum but unfortunately I cannot.
At a guess, the following documentation may prove useful: How to: Add Interactive Sort to a Table or Matrix (Reporting Services)John Sansom |
SQL Server DBA Blog | Twitter
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 3:58am