question

pritik889 avatar image
pritik889 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.
ssrs-2012reporting_servicessql 2012report-viewer
8 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
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
0 Likes 0 ·
pritik889 avatar image pritik889 commented ·
i want to refresh dataset on every click of interactive sorting.
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
Hi, if all you are doing is sorting why would you want to refresh the dataset?
0 Likes 0 ·
pritik889 avatar image pritik889 commented ·
we have a requirement to sort whole data within dataset using interactive button click.
0 Likes 0 ·
pritik889 avatar image pritik889 commented ·
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
0 Likes 0 ·
Show more comments
Mart avatar image
Mart answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pritik889 avatar image
pritik889 answered
![alt text][1] [1]: /storage/temp/2289-page2.png

page1.png (38.3 KiB)
page2.png (21.1 KiB)
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pritik889 avatar image pritik889 commented ·
Please see my screen of report
0 Likes 0 ·
Mart avatar image Mart commented ·
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.
0 Likes 0 ·
pritik889 avatar image
pritik889 answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pritik889 avatar image pritik889 commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.