• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 879
  • Last Modified:

Sorting on tablix in ssrs 2008

I have a query that returns a table with following coloumn [SectorName, ClassificationName, Turnover, Rank]. This query is used as dataset. So here distinct SectorName and ClassificationName are dynamic.
I use these as my RowGroup (Pic1) and ColoumnGroup (Pic2).
Now for ColoumnGroup we have 2 coloumns per group To display Turnover for given classification and sector. Header = <ClassificationName>.
To Display Rank for given classification and sector. Header = R. Now I want to enable interactive sort such that user can select if he wants to sort rows by values in one any coloumn.
For instance user can sort by Turnover of Classification1 next he might want to sort by Rank of classification2.

question-pic1.jpg
question-pic2.jpg
0
akhileshcoer
Asked:
akhileshcoer
  • 2
  • 2
1 Solution
 
planoczCommented:
Not sure on this, but I have had to add a parameter to select the sort I wanted, pass it to a SP and have the SP sort it. then view the report.
0
 
akhileshcoerAuthor Commented:
@planocz, thanks for the comment.
But i don't want to call sp everytime user clicks on the sort button.
Is it possible using interactive sort?
0
 
planoczCommented:
The time should be short to recall a SP. We have a lot of reports that are run this way and the wait time is very fast some reports have over an easy 5000 records.
0
 
akhileshcoerAuthor Commented:
Although my I the solution but the excatly the way i was lookinng for. anyways many thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now