How to sort dataset entire data using interactive sorting in SSRS

Question

question

pritik889 asked Mar 26, '15

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-2012 reporting_services sql 2012 report-viewer

8

10 |1200

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

sp_lock commented · Mar 26, 2015 at 02:25 PM

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 ·

pritik889 commented · Mar 27, 2015 at 04:11 AM

i want to refresh dataset on every click of interactive sorting.

0 ·

sp_lock commented · Mar 27, 2015 at 09:11 AM

Hi, if all you are doing is sorting why would you want to refresh the dataset?

0 ·

pritik889 commented · Mar 27, 2015 at 09:21 AM

we have a requirement to sort whole data within dataset using interactive button click.

0 ·

pritik889 commented · Mar 27, 2015 at 09:27 AM

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 ·

Show more comments

Answer 1 · 2015-03-27T12:41:56Z

Mart answered Mar 27, '15

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

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

Answer 2 · 2015-03-27T12:45:43Z

pritik889 answered Mar 27, '15

![alt text][1] [1]: /storage/temp/2289-page2.png

page1.png (38.3 KiB)

page2.png (21.1 KiB)

2

10 |1200

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

pritik889 commented · Mar 27, 2015 at 12:46 PM

Please see my screen of report

0 ·

Mart commented · Mar 27, 2015 at 02:21 PM

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 ·

Answer 3 · 2015-03-30T05:36:28Z

pritik889 answered Mar 30, '15

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

10 |1200

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

pritik889 commented · Mar 30, 2015 at 07:08 AM

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 ·

question