question

PoovarasanVelu-0836 avatar image
0 Votes"
PoovarasanVelu-0836 asked Isabellaz-1451 commented

Interactive sorting in column group in SSRS

Hello,

I have sorting issue in SSRS.

I have table(Tablix) with column grouping enabled on the ProductCategory column in Power BI Report Builder.Please refer screenshot #1200282-ssrs.png


I want to sort the data in the column group, As there is a column grouping currently I am unable to sort the data in it. Screenshot #2.
200238-image.png


sql-server-reporting-services
ssrs.png (32.8 KiB)
image.png (125.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PoovarasanVelu-0836
we have not get a reply from you. Did any answers could help you?
If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

Best Regard,
isabella

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @PoovarasanVelu-0836 ,
SSRS report developer facing a common problem of implementing interactive sorting on column group in Matrix whenever we add an interactive sorting on column group sorting symbol will appear but did not affect when we click it. This is one of the limitations of SSRS.

You could set interactive sorting in column groups by:
SSRS – Interactive Sorting on Matrix column group
How to Enable Interactive Sorting in a SSRS Matrix
Best Regards,
Joy


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered Isabellaz-1451 edited

Hi @PoovarasanVelu-0836



I did a local test,mine can‘t sorting too, but there is a work around,you can set the row group sorting.

200491-image.png

200380-image.png
My test report:
200455-image.png

Result preview:
200389-image.png

BTW,you can also create a feild in the dataset specially for the sorting .


Best Regards,
Isabella


image.png (5.2 KiB)
image.png (9.0 KiB)
image.png (2.7 KiB)
image.png (19.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PoovarasanVelu-0836 avatar image
0 Votes"
PoovarasanVelu-0836 answered

Hello @IsabellaZhangMSFT-7746

No, It doesn't worked for me and one more thing I want to do interactive sort in the row grouping as well.


Thanks and Regards,
Poovarasan

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered Isabellaz-1451 commented

Hi @PoovarasanVelu-0836

SSRS has it's limitation , I think interactive sort is not available in matrix. I have a thought that maybe you can pivot the origin data in the dataset then use a table to get the similar result ,then use the interactive sort .

Best Regards,
Isabella

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Here is the thread about how to pivot a table in tsql :https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15

Best Regards,
Isabella

0 Votes 0 ·