RTC - Sort Order when a Report is run

MJG

We are currently upgrading a customer to 2009R2 and they have told us that it is an issue that when running any report on the system the sort order will default to No. The customer wants to be able to change this and for the RTC to remember what the last sort order used was. I have tried multiple options such as enabling SaveValues on the request form of the report and this still didn't allow for this option. Is this possible in 2009 or 2009R2?

Thanks beforehand for any suggestions.

Mitch

navian

I don't think it is possible to get the same 'Sort...' button in the RTC as you have in the Classic client.

mohana_cse06

Did you check report 111, we can change the sorting in RTC.

This may not be the solution for

The customer wants to be able to change this and for the RTC to remember what the last sort order used was.

But you can give option to customer to select the sorting..

MJG

mohana_cse06 wrote:

Did you check report 111, we can change the sorting in RTC.

This may not be the solution for

The customer wants to be able to change this and for the RTC to remember what the last sort order used was.

But you can give option to customer to select the sorting..

Yes indeed, We know that you can change the sorting order however we want the last sort order used to default in next time when running the report.

mohana_cse06

MJG wrote:

mohana_cse06 wrote:

Did you check report 111, we can change the sorting in RTC.

This may not be the solution for

The customer wants to be able to change this and for the RTC to remember what the last sort order used was.

But you can give option to customer to select the sorting..

Yes indeed, We know that you can change the sorting order however we want the last sort order used to default in next time when running the report.

Obviously it will be sorted as per the Sorting key given in DataItemtableview property.. :-k

MJG

But this will not allow for a customer to:

Change the sorting order to Search Name.

Run the report.

Close the RTC.

Open RTC.

Run the report.

Sorting order will then default back to No. where as they are requesting that it defaults to the sorting order last used when running the report.

mohana_cse06

navian wrote:

I don't think it is possible to get the same 'Sort...' button in the RTC as you have in the Classic client.

:thumbsup:

MJG

Yes I believed this would be the problem. Thanks for the help.

navian

mohana_cse06 wrote:

navian wrote:

I don't think it is possible to get the same 'Sort...' button in the RTC as you have in the Classic client.

:thumbsup:

Ok, I get it, I totally misunderstood the question..... :oops:

Belias

1. declare an option variable in your report with the available sorting orders
2. add it to the requestpage and set the savevalues
3. use setcurrentkey instruction in the onpredataitem trigger

it's not optimal, but it's better than nothing...