CODEWITHSUNDEEP
ssrs-2008
Vic
Vic

Reputation: 5

How to Interactive Sort by Calculated Columns in SSRS 2008

I have a calculate field Total Pts which is the sum of the values of report items

=ReportItems!Textbox28.Value + ReportItems!Textbox30.Value + ReportItems!Textbox32.Value

Now I want to put a interactive sort here and I am not able to do so . Any ideas? I can't do it in a query because the reportitems that I am adding are from a two different datasets which are of diff. types eg: sql server & sharepoint

Upvotes: 0

Views: 1478

Answers (1)

TPhe
TPhe

Reputation: 1671

There should be no issue with doing this because SSRS allows you to use an expression to determine the sort order. Just right click on your header textbox for the column and go to the interactive sort tab. Here you can turn interactive sort on, then in the sort by field click the function icon next to the drop down. Use the same expression that you used for your calculated field, and it will sort according to the results of this expression. If there is some reason you can't do this that I'm missing, let me know and I'll try to help.

Upvotes: 1

Related Questions