SSRS Subscription columns will not sort

(0) Share

Report

Posted on by Napolo

756

Hello,

We recently upgraded GP/SQL to version 2018r2. Setting up the 200 subscriptions for a specific report, we noticed we no longer can sort by description, last run date, result and so forth.

Is there something we can do to fix this?

*This post is locked for comments

All responses (2)

Answers (0)

Napolo 756 on at

Like (0)

Report

RE: SSRS Subscription columns will not sort

Hello,

Thank you for your reply!

Where I am trying to sort columns, is in the Manage Subscriptions view. To have the ability to sort any of the subscription columns for a quick search.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SSRS Subscription columns will not sort

After trying many things I found one solution which worked for this problem.

Click on Tablix, then row with many eclipses

It will show if there are groups on that tablix, look bottom of screen it will show the row groups and columns groups.

In Row groups, you will see many columns, right click on first column in Row groups section.

Select tellthebell Group properties..., then on dialog, select sorting, by default it will be showing the first column name, change to the desired column and sorting order by [A-Z] or [Z-A] button.