Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pthapa
Helper V
Helper V

How to sort SSRS report in column group?

Hello all,

I came across one issue with one of my SSRS report. I need to sort the fileds on column groups based on a 'Sort' column values but I am not able to do so.

Can someone please help me.

 

pthapa_0-1717173771388.png

On this screen shot below, these are fields in column group (single column), and I need to sort based on values present in 'sort' column (AAA,BBB,.....HHH).

pthapa_2-1717174018236.png

Appreicate your help.

pthapa

1 ACCEPTED SOLUTION

Finally, I figured out how to sort the column group in the report.

Right click on the column group > Group Properties > Sort > Add the 'Sorting Column' > Select the sorting order A-Z,
This finally worked for me.
If anyone need help, do post a comment.
Thanks,

pthapa

View solution in original post

3 REPLIES 3
pthapa
Helper V
Helper V

Hello @v-rongtiep-msft ,
I have added the sort filed as you have mentioned but still the report is not sorting.

Here is the snippet of the sort field.

pthapa_0-1717510721607.png

After running the report, I still didn't get this sorted A-Z.

pthapa_1-1717510840626.png

 

 

Finally, I figured out how to sort the column group in the report.

Right click on the column group > Group Properties > Sort > Add the 'Sorting Column' > Select the sorting order A-Z,
This finally worked for me.
If anyone need help, do post a comment.
Thanks,

pthapa

v-rongtiep-msft
Community Support
Community Support

Hi @pthapa ,

  1. On the design surface, select in the tablix data region to select it. The Grouping pane displays the row groups and column groups for the Tablix data region.

  2. In the Row Groups pane, right-click the group name, and then select Edit Group.

  3. In the Tablix Group dialog box, select Sort.

  4. For each sort expression, follow these steps:

    1. Select Add.

    2. Type or select an expression by which to sort the data.

    3. From the Order column drop-down list, choose the sort direction for each expression. A-Z sorts the expression in ascending order. Z-A sorts the expression in descending order.

  5. Select OK.

More details: Sort data in a data region in a Power BI paginated report - Power BI | Microsoft Learn

 

Best Regards
Community Support Team _ Rongtie

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.