topic Re: Sorting Desc Tablix - Paginated Report in Report Server

Sorting Desc Tablix - Paginated Report

Ritesh_Air — Fri, 06 Aug 2021 01:30:42 GMT

Hello Experts,

I am trying to sort my paginated report which has tablix in it on descending order on 1 measure (ID_total_Catalyst_Points_). I tried different ways but none seems to be working.

1. Tried it at Tablix level.

2. Tablix is grouped at the Grower_Group level. Tried sorting it there too.

3) At the dataset level in the query:

Sorting comes out randomly in my report. I am not sure where else I need to change it?

Thanks in advance,

-RK

Re: Sorting Desc Tablix - Paginated Report

v-henryk-mstf — Mon, 09 Aug 2021 06:53:11 GMT

Hi Ritesh_Air ,

Based on your description, to change the sort order of data in a data region when a report first runs, you must set the sort expression on the data region or group.
In a tablix data region, set the sort expression for the data region or for each group, including the details group. If you have only one details group in a tablix data region, you can define a sort expression in the query, on the data region, or on the details group and they all have the same effect.

Must follow the ordering steps as follows:

For a tablix data region, also can add interactive sort buttons:

Re: Sorting Desc Tablix - Paginated Report

Ritesh_Air — Tue, 10 Aug 2021 16:45:43 GMT

Thanks for your help.

Here I put the paginated report for you to review.

On Tablix data region : sorted it by points descending.

On main dataset query (dsMain): sorted it by points descending.

On another dataset query which I am using for parameter (GrowerGroup): sorted it by points descending.

In each and every Row Group: sorted it by points descending.

Still doesn't sort it, the way I want it.

https://drive.google.com/file/d/1rZ3bMVevf-AqusDCGk9A0rocY7c0fDmS/view?usp=sharing

Thanks,

-RK

Re: Sorting Desc Tablix - Paginated Report

v-henryk-mstf — Wed, 11 Aug 2021 09:58:02 GMT

Hi Ritesh_Air ,

Due to the inability to obtain your data source, it is impossible to test with the file you provided. For the above sorting problem, its basic principle is the same as sort in powerbi desktop. You need to put specific fields in the corresponding visual to sort according to the field. Otherwise it is invalid. You can make a try.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.