Report: Sort on calculated Global Variable

shogan@mila.ie
shogan@mila.ie Member Posts: 113
edited 2007-07-03 in NAV/Navision Classic Client
Hi all,

Hope the weather is a lot better where you are! Raining buckets here...

Quick question:

In a report I have a global var that is used to calculate the difference in sales for each customer between this year and last year.

I coded this SalesDifference global var and set this as a SourceExpr on a TextBox on the Sections - Body of the report, and it works fine.

However, I would like to sort the report in ascending order based on this non-key field.

Aside from creating a virtual table and redisging the existing tables, is there any other way I can achieve this?

I thought about using arrays and creating my own QuickSort algorithm...

Does this make sense?

Regards,

The Datalore :D

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    If you are on SQL, create a new key with the decimal field in it BUT don't maintain the index on SQL.
    On Navision (and also for SQL), create a new table (no need to put it in the license!) with the key you want and use it as a temptable.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories