March 29, 2016 at 3:27 pm
In an existing ssrs 2008 report, I have added a few new columns to the existing report as requested by the user. In addition, the user wants to be able to sort the data on any column on the report by using a sort parameter value.
The data does not contain any summary values. The columns in the report include:
a. student number,
b. student name,
c. birth date,
d. age,
e. current grade level,
d. attendance code value.
The default value is to sort by student name alphabetically. Whatever field is to be sorted first, the student name will be the second.
I have tried to sort the data at the tablix level and the row group level and the logic has not worked yet. There is no row group setup right now.
Thus could you show me how to setup the sort by using the parameter value? Would you show how the ssrs report needs to look for me to accomplish this goal and/or point me to link(s) that will show me how to accomplish this goal?
March 29, 2016 at 3:53 pm
Can't you just use Interactive Sorting? (I am pretty sure it's in SSRS 2008, but I haven't used 2008 in a long time, esp. R1)
Right-click on column header row (with the label in it), go to Interactive Sorting, and then specify what clicking on that header column will do.
March 29, 2016 at 10:30 pm
The user does not want to use the interactive sort. Due to that fact, would you show me other examples?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply