Interactive Sorting

I know this is not available now, but is it plan in the near future:

I want to be able to set the initial sort order on the interactive sort.

for example, I have a report sorted Asc by Rank. If I click on the interactive sort button on the Rank column, it resorts ascending... totally pointless, and my customers point this out on a weekly basis...

Any plans to add this feature? If not, I will go to connect and suggest it.

Also, does anyone else find this annoying?

Thanks!

BobP

So you are saying that when you click the sort button on a report that is already sorted ascending, you want it to sort descending and vice versa?

Right click the field you want to interactively sort. Click Properties. Go to the interactive sort tab.

Is this not what you want?

By the way, how does this work? I'm trying to get one of my drilldowns to interactively sort by transaction amount. It won't seem to sort it. I think I just don't have it set up properly.

|||

It is exactly what i want, and it works great EXCEPT... If the report is sorted by default on Column A ascending, and I click on the sort button on column A, it tries to sort it asc first. I have to push it twice to sort desc.

To get it to sort, you have to select the correct grouping to sort, and the correct grouping for the sort expression.

Generally, if I have 1 group, I can sort on the table level, and leave the bottom selection default.

BobP

|||

BobP - BIM wrote:

It is exactly what i want, and it works great EXCEPT... If the report is sorted by default on Column A ascending, and I click on the sort button on column A, it tries to sort it asc first. I have to push it twice to sort desc.

To get it to sort, you have to select the correct grouping to sort, and the correct grouping for the sort expression.

Generally, if I have 1 group, I can sort on the table level, and leave the bottom selection default.

BobP

I got it to sort for me. But I see what you're talking about now. That is somewhat annoying. Especially when you go sort happy.

|||Is there any way to change the default order of the button? I need a report to display descending first, then ascending if clicked a second time. However, I am unable to find any setting in the report designer that allows me to change this.|||

That's what this thread is about. No, it does not exist now.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249537

BobP