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
- 310 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Employee Portal: How to run a Report with Filters?
wakestar
Member Posts: 207
Hi All
I created a webpart - page for time recording and everything works fine, except that I cannot run a Navision - Report with filters.
the definition of the webpart:
Header: Resource
Header-Fields: No., Name, 'Date Filter Web' and 'Project Filter Web'
'Date Filter Web' and 'Project Filter Web' are editable.
Table-Action:Show Report/Current/SHOWREPORT/167/85025
The 'Head'-Table of Report 85025 is 167 (Job)
The Connection between WP-Requests (Table 156 --> Table 167)
85901 Project Filter Web
> 1 No.
85900 Date Filter Web
> 51 Date Filter
Then I added my Report to the Codeunit 6828 (EP Report Mgt.) and added the function 'JobTableBased'
When I run the report the following Error occurs:
Field ID '85901': Fields marked as direct or indirect editable are not allowed in filter expressions. (10019)
:shock:
I have no idea where this error comes from. I searched for it but I couldn't find it. Debugger doesn't stop either. :roll:
Anybody got an idea what to do?
ps.
- running the report without filters works... but thats not the goal.
- restarting nas, iis , or whatever... did it many times already. :roll:
- working with navision 4.01 native DB
I created a webpart - page for time recording and everything works fine, except that I cannot run a Navision - Report with filters.
the definition of the webpart:
Header: Resource
Header-Fields: No., Name, 'Date Filter Web' and 'Project Filter Web'
'Date Filter Web' and 'Project Filter Web' are editable.
Table-Action:Show Report/Current/SHOWREPORT/167/85025
The 'Head'-Table of Report 85025 is 167 (Job)
The Connection between WP-Requests (Table 156 --> Table 167)
85901 Project Filter Web
> 1 No.
85900 Date Filter Web
> 51 Date Filter
Then I added my Report to the Codeunit 6828 (EP Report Mgt.) and added the function 'JobTableBased'
When I run the report the following Error occurs:
Field ID '85901': Fields marked as direct or indirect editable are not allowed in filter expressions. (10019)
:shock:
I have no idea where this error comes from. I searched for it but I couldn't find it. Debugger doesn't stop either. :roll:
Anybody got an idea what to do?
ps.
- running the report without filters works... but thats not the goal.
- restarting nas, iis , or whatever... did it many times already. :roll:
- working with navision 4.01 native DB
0
Comments
it is not possible to set filters from field values that are editable.
Because with this you may override the filters of the request and so on.
HTH,
Rainer