Problem With GETFILTER

Markandey_Pandey
Member Posts: 178
Hi all,
i have created a report using Dimension Value and Sales Invoice Line Data Items.
Here i want to print the date selected on request form to the header section of the Dimension Value data item. for this i have written the code under OnPreSection trigger of Dimension value's header section, the code is:
DateFilter :-- Text (30)
DateFilter:="Sales Invoice Line".GETFILTER("Sales Invoice Line"."Posting Date");
and i have assogned this DateFilter variable to a textbox under hedaer section of Dimension value dataitem,
but its not working, its showing nothing.
can anybody help me.
i have created a report using Dimension Value and Sales Invoice Line Data Items.
Here i want to print the date selected on request form to the header section of the Dimension Value data item. for this i have written the code under OnPreSection trigger of Dimension value's header section, the code is:
DateFilter :-- Text (30)
DateFilter:="Sales Invoice Line".GETFILTER("Sales Invoice Line"."Posting Date");
and i have assogned this DateFilter variable to a textbox under hedaer section of Dimension value dataitem,
but its not working, its showing nothing.
can anybody help me.
Markandey Pandey
0
Comments
-
If you will find the correct thread on this forum (but it will be hard...), you will find that the filters set for each dataitems are available only in two cases:
the OnPreDataItem of the dataitem was already called and you are "within" the dataitem (on same or nested level) - it means you are inside the scope of the dataitem
or
you are in OnPreReport trigger. In this trigger, all filters of all dataitems are available (but cannot be changed, because they will be reset in OnPreDataItem trigger).0 -
Thanx,
i got ur point.Markandey Pandey0
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