SQL View based report is having issue with date filter

rahul_jnk
rahul_jnk Member Posts: 61
edited 2018-06-27 in NAV Three Tier
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?

Best Answer

  • rahul_jnk
    rahul_jnk Member Posts: 61
    Answer ✓
    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.

Answers

  • rahul_jnk
    rahul_jnk Member Posts: 61
    Answer ✓
    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.

Categories