Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Dynamic Filtering
sabzam
Member Posts: 1,149
Dear ALl,
I've got a query in the following scenario
I am running a report which during the workings will be running a filter onto the Entry No. field therefore, integer. The issue is that the no. of filters to be applied is dynamic. Therefore we may have two numbers, but we may aslo have ten.
I have tried to insert the numbers in a text variable but when applying the setfilter it is not accepting it.
SInce I am using the '|' I cannot use the number variable.
Manually this can be done but I cannot manage through code.
What's the way forward?
Regards,
Steve
I've got a query in the following scenario
I am running a report which during the workings will be running a filter onto the Entry No. field therefore, integer. The issue is that the no. of filters to be applied is dynamic. Therefore we may have two numbers, but we may aslo have ten.
I have tried to insert the numbers in a text variable but when applying the setfilter it is not accepting it.
SInce I am using the '|' I cannot use the number variable.
Manually this can be done but I cannot manage through code.
What's the way forward?
Regards,
Steve
0
Comments
lrecGLEntry.SETFILTER("Entry No.",'1|2|3|4');http://www.epimatic.com