Using 2 date filters on 1 table on a report.
JamieBrown
Member Posts: 107
Hi,
I'm sure this is easily solved but I'm having difficulty.
I'm reporting on the Item table and need to show the "Net Change" with a date filter and also "Qty. Sold (POS) with another Date filter.
What is the best way of achieving this?
Thanks in advance.
Jamie
I'm sure this is easily solved but I'm having difficulty.
I'm reporting on the Item table and need to show the "Net Change" with a date filter and also "Qty. Sold (POS) with another Date filter.
What is the best way of achieving this?
Thanks in advance.
Jamie
0
Comments
-
You can store them in variables.
First set the datefilter for 1 flowfield and do calcfields
Var1 := Flowfield1;
Then change the datefilter and store again
Var2 := Flowfield2;0 -
Thanks Mark, worked perfectly. !0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
