NAV 5.xx Request Form Sorting

CCTNAV
Member Posts: 8
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.
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.
0
Comments
-
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!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions