Start report with pre-defined filters

Luc_VanDyck
Member, Moderator, Administrator Posts: 3,633
I don't think this is possible, but I ask it anyway.
Is it possible to start a report (with serveral DataItems), and fill-in some filters from the start. So the user sees the ReqFilterFields (defined when programming the report) with the corresponding values?
Is it possible to start a report (with serveral DataItems), and fill-in some filters from the start. So the user sees the ReqFilterFields (defined when programming the report) with the corresponding values?
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
0
Comments
-
If you don't mind having the code in the form you call the report from, you can declare a global, then set range on that global, and call the report with that global. The ranges set will appear as req filter fields filled in.
Eg, declare the new variable "SalesRec1"
SalesRec1.SETRANGE("No.",1234);
REPORT.RUNMODAL(206,TRUE,TRUE,SalesRec1);
Report will run with 1234 in "No." field.1 -
More detailed answer can be found in this forum post:
http://forum.mibuso.com/discussion/35317/default-filter-on-report--
Ivica0
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
- 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
- 320 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