asked
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, if all you are doing is sorting why would you want to refresh the dataset?
we have a requirement to sort whole data within dataset using interactive button click.
currently i have done interactive sorting on
report.in that case result is look like on every page:page 1 display data: 15,15,15,15,...01 and on page 2 display data:15,15,15,01....01... But we want page 1 display record like: 15,15,15,15....15.and on page2:01,01,01,01,01...01
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
![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.
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.
I agree with your point interactive sorting does changes the entire order of data.....but interactive sorting does not reorder entire data after sorting i want reorder whole data according to sorting rule.
17 People are following this question.
