Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
setting a filter on a report which the user cannot change
Rule
Member Posts: 34
I want to set a filter on a report which the user cannot change.
But he must maintain the possibility to set his own filter (beside the one i've set) in the request Form. So setting a filter and not showing the request form is not an option.
But he must maintain the possibility to set his own filter (beside the one i've set) in the request Form. So setting a filter and not showing the request form is not an option.
Realisations are only limited by the borders of imagination
0
Comments
With this fct used in trigger OnPreDataItem , you can create "invisible and unmovable" filters ...
Hope that help !!
RIS Plus, LLC
MVP - Business Apps
I used the PreReport Trigger so the filter wasn't used.
With the filter set on the predataitem trigger it works just fine.
Even without setting the filtergroup. The user cannot interact to disable or change the filter on the predataitem trigger.
Thanks for the help
In your solution, the filter is replaced with whatever the user sets on that field. If you use the filtergroup, you can limit the recordset that the user sees, but the user is still able to further filter on that field. Both filters will be applied.
RIS Plus, LLC
MVP - Business Apps
This is necessary if you use the report for showing data.
I use the report only for processing. So there is no interaction except the request form. If i use the filtergroup and there is a wrong combination of filters (because of the user input) there is no data filtered. But if i replace the user filter by my filter i know the data is always filtered my way.
RIS Plus, LLC
MVP - Business Apps