Howdy, Stranger!
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
- 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
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
SQL View based report is having issue with date filter
rahul_jnk
Member Posts: 61
We have a report based on SQL View ie. virtual table in NAV. The issue is with Posting date filter in the report request page, when date is entered or the date drop down is selected then it is taking ages to list. There seems to be no issue with other filters which are showing correctly in drop down.
Anyone knows how to fix this issue?
Anyone knows how to fix this issue?
0
Best Answer
-
rahul_jnk
Member Posts: 61
Okay, I created FromDate and ToDate variables in request page and filtered the table using CAL. This solution is ok for the time being. Still If anyone knows about a fix please let me know.0
Answers