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
LVL 4
akhileshcoerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.