Sorting Parameter in Paginated Reports

[Emilyyying]

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

[d_gosbell · Accepted solution]

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.

[Emilyyying]

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}

[d_gosbell]

---

@Emilyyying 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.