NAV 5.xx Request Form Sorting

CCTNAV

Good Afternoon,

I know that I have done this in the past but I just can't seem to remember how. What I need is a method of sorting a reports fields by ascending or descending order at runtime. The criteria for sorting will change so setcurrentkey would not be appropriate as I would have to change the key and recompile everytime an individual wanted to sort on a field not on the list. So for example:

Table1
First Name
Last Name
Full Name
Search Name

And lets say Search Name is included in the key but the data is inconsistent so users want to sort on Last Name as they know that is accurate. But they may want to sort on No. or some other random field on the table.

Normally I would use "+Last Name" but that is not it and is for Jet Reporting. But that is essentially what I want to do on the Navision Report via the Request Form Filters. Thank you for your time.

jspopp

Hi, you can set up some radio buttons on the Option tab, allowing the user to select the sorting they want. Then in the code section, run a CASE or IF statement to determine which key to use. Good luck!