September 16, 2014 at 2:05 pm
In an SSRS 2008 r2 report, I want to be able to allow the user to sort parameter values based upon the values of lastname, firstname,student number, and school name. The default value of the sort is set to value = 1.
However, I want to be able to change the order of which item is sorted first, second, third, and fourth. The code I have on the tablix sort is the following:
=IIF(Parameters!Sort.Value = 1, Fields!studentNumber.Value, IIF(Parameters!Sort.Value = 2, Fields!grade.Value, IIF(Parameters!Sort.Value = 4, Fields!homeroomteacher.Value, IIF(Parameters!Sort.Value = 5, Fields!ELL_Status.Value, "3"))))
I want the following sort to be used that is listed in the picture below, but the iif statement is not working, Thus can you show me what to change and/or if the previous link is the best I can accomplish?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply