Report: Sort on calculated Global Variable

shogan@mila.ie

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

kriki

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.