Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Post Patron
5 years ago
Solved

Sorting Desc Tablix - Paginated Report

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

 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    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:

    related document link:

    Sort Data in a Data Region (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs

    Interactive Sort (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs


    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.

    • Ritesh_Air's avatar
      Ritesh_Air
      Post Patron
      5 years ago

      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

      • v-henryk-mstf's avatar
        v-henryk-mstf
        Community Support
        5 years ago

        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.