RTC - Sort Order when a Report is run

MJG
MJG Member Posts: 7
edited 2011-02-07 in NAV Three Tier
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

Comments

  • navian
    navian Member Posts: 39
    I don't think it is possible to get the same 'Sort...' button in the RTC as you have in the Classic client.
    Navian

    RTC Printouts Made Easy
    NaviNordic Document Configurator for Dynamics NAV
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    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..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • MJG
    MJG Member Posts: 7
    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
    mohana_cse06 Member Posts: 5,506
    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

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • MJG
    MJG Member Posts: 7
    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
    mohana_cse06 Member Posts: 5,506
    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:

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • MJG
    MJG Member Posts: 7
    Yes I believed this would be the problem. Thanks for the help.
  • navian
    navian Member Posts: 39
    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:
    Navian

    RTC Printouts Made Easy
    NaviNordic Document Configurator for Dynamics NAV
  • Belias
    Belias Member Posts: 2,998
    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...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog

Categories