topic Re: Sorting Parameter in Paginated Reports in Report Server

Sorting Parameter in Paginated Reports

Anonymous — Thu, 29 Jun 2023 07:08:04 GMT

Hi, Can anyone tell me how to sorting a paramter in paginated report, display the data order by desc?

Re: Sorting Parameter in Paginated Reports

d_gosbell — Mon, 03 Jul 2023 09:45:19 GMT

You would edit the dataset for the query that is populating the parameter to add the appropriate order by clause. If this dataset was autogenerated you might need to right click on the datasets folder and choose the "Show Hidden Datasets" option.

Re: Sorting Parameter in Paginated Reports

Anonymous — Wed, 05 Jul 2023 06:10:00 GMT

Thank you, I have found the Hidden Datasets, and there is no function as "Sorting" for ParameterValue, right?

I need to add the text "order by DESC" into the Query text {EVALUATE SELECTCOLUMNS () order by 'table'[item] DESC}

Re: Sorting Parameter in Paginated Reports

d_gosbell — Wed, 05 Jul 2023 09:19:36 GMT

Anonymous wrote:

Thank you, I have found the Hidden Datasets, and there is no function as "Sorting" for ParameterValue, right?

I need to add the text "order by DESC" into the Query text {EVALUATE SELECTCOLUMNS () order by 'table'[item] DESC}

That is correct. To sort a dataset you need to add the ORDER BY clause to the query. There are no sort by options on datasets, these are only available on report groups when you are outputting data to the page. But it's still better to do the sort in the source query if you can.