Sort Report on Flow Field?

jvancleve

We are using NAV 5.0. I need to sort report 119 "Customer - Sales List", by Sales (LCY). I cannot add that field as a key on the Customer table because it is a flowfield:

"A FlowField cannot be part of a key.

Field: Sales (LCY)
Table: Customer
Key fields: Sales (LCY)"

Are there any other options for sorting this report?

Thanks!
Jamison VanCleve

Savatage

if you have report 10062 - TOP__CUSTOMER LIST - you will see on the options tab a box to sort by sales.

you can either use that report -or see how that report was done to help you.

Alex_Chow

Flowfields are not really fields, so they cannot be part of the key.

garak

follow Savatage's tip.
A FlowField is a "Field" that is calculated be formula at runtime.
It stores not the datas ....

jvancleve

Thanks for the help!