How to sort dataset entire data using interactive sorting in SSRS
we have a requirement to sort entire data of dataset in ssrs using interactive
sorting.In short we need to re-render report on click of interactive up down button of each
column.is this possible in SSRS.If not possible then suggest me other alternative way of sorting.
If I understand your question and you are not looking to refresh the dataset, then yes it is.
https://msdn.microsoft.com/en-us/library/dd283102.aspx
Hi Pritik889 It sounds like you may have the wrong field select for your interactive sort, or you are sorting within a group which naturally has a sort in it already. Interactive sorting will sort the entire dataset in the tablix on the field specified. You can check by looking at the properties of the textbox and checking Interactive Sorting or by opening the report in code view and searching for usersort, you'll see something like: true =Fields!mydata.Value
I have already tried parameter(SortOrder) solution but I need to do same thing using interactive sorting.yes I have create one group in that report for page breaking after 10 records.
![alt text][1] [1]: /storage/temp/2289-page2.png
I mentioned checking the field that the interactive sort is applied to, have you double checked that? Are there any groupings that could affect it? Have you tried the other solution I mentioned? Interactive sorting does change the entire order of the data, not just on the first page - that would be pointless.
