akhileshcoer
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Although my I the solution but the excatly the way i was lookinng for. anyways many thanks
ASKER
But i don't want to call sp everytime user clicks on the sort button.
Is it possible using interactive sort?