March 4, 2009 at 1:42 pm
First off, I'm using SSRS 2005 SP3. Secondly I know how to add interactive sorting for most things but I keep running into a wall with this one situation...
I have a Matrix that groups orders by region, please excuse the ASCII ARt...
| TotalOrders
----------------------------------
Region | count(orderNum)
The users was to be able to sort both by region alphabetically and by totalOrders ASC and Desc.
The region is no problem and already done, I just can't seem to get the totalorders sorting taken care of.
In the interactive sorting tab for the TotalORders textbox I've tried the following...
sort expression =Count(Fields!OrderNum) and every variation og the grouping/scoping options I can think of and still can't get this to sort the way I want.
Anyone have any experience sorting aggregates in matrices?
Thanks in advance.
-Luke.
March 5, 2009 at 7:22 am
Finally found my own answer...
According to this MSDN Forum, it's not available in SSRS 2005.
-Luke.
March 9, 2009 at 4:52 pm
I run into the same problem. That's not the answer I was hoping for...
March 10, 2009 at 6:32 am
Luckily for me it was a simple total that I Was doing in the matrix with the details in a table below it. I just wanted to use the same dataset for both. I rewrote the matrix as a table, did all of the cross tabs in the query and am now able to sort it. I suppose the other answer is upgrade to 2008?
-Luke.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply