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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics