Forum Discussion
Post PatronHow 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.
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).
Appreicate your help.
pthapa
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
3 Replies
Hi pthapa ,
-
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.
-
In the Row Groups pane, right-click the group name, and then select Edit Group.
-
In the Tablix Group dialog box, select Sort.
-
For each sort expression, follow these steps:
-
Select Add.
-
Type or select an expression by which to sort the data.
-
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.
-
-
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
pthapaHello Anonymous ,
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.
After running the report, I still didn't get this sorted A-Z.
- pthapa
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
