[NAV 2013 R2] Apply page filters to report
Bilbo007
Member Posts: 6
Hi,
Am writing a report based on items. I would like the filter applied to the items list to be applied on the report automatically. So if I apply certain filters on the list and click the report button, it opens up and has exactly the same filters applied to the report request page.
Please help.
Thanks
Am writing a report based on items. I would like the filter applied to the items list to be applied on the report automatically. So if I apply certain filters on the list and click the report button, it opens up and has exactly the same filters applied to the report request page.
Please help.
Thanks
0
Best Answer
-
Hi. For the primary key for the item table, you can use code to SETTABLEVIEW in the page action after CurrPage.SETSELECTIONFILTER before running the report. For any other data you will need to create a global in the report to receive filters sent and then assign in the report. Neil5
Answers
-
Hi. For the primary key for the item table, you can use code to SETTABLEVIEW in the page action after CurrPage.SETSELECTIONFILTER before running the report. For any other data you will need to create a global in the report to receive filters sent and then assign in the report. Neil5
-
Thanks. Problem is I don't have access to the page code section... licencing. Is there any way to do this from the report itself?0
-
[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 329 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