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
Capturing a date filter
Bokk
Member Posts: 138
I have created a report with 3 dataitems, indented as follows ->
Customer
Job
Job Ledger Entries
The user can/should select a date range on the request form based on the "Date Filter" field in the Job table (Ledger DataitemLink:Job No.=FIELD(No.),Posting Date=FIELD(Date Filter). PrintOnlyIfDetail:YES in Job Dataitem. I have Job header info in 2 sections so it will print for each job and at the top of the next page if job details spans more than one page. The PrintOnlyIf Details property does not seem to stop the header printing when there are no ledger details. For each job I tried to check the ledger entries in code, but cannot seem to capture the Date Filter off the request form to set the SHOWOUTPUT accordingly. How would I reference this correctly?
OnPreSection() - Header section
JobLedger.SETCURRENTKEY("Job No.","Posting Date");
JobLedger.SETRANGE("Job No.",Job."No.");
JobLedger.SETFILTER("Posting Date",'="Date Filter"');
Thanks
Customer
Job
Job Ledger Entries
The user can/should select a date range on the request form based on the "Date Filter" field in the Job table (Ledger DataitemLink:Job No.=FIELD(No.),Posting Date=FIELD(Date Filter). PrintOnlyIfDetail:YES in Job Dataitem. I have Job header info in 2 sections so it will print for each job and at the top of the next page if job details spans more than one page. The PrintOnlyIf Details property does not seem to stop the header printing when there are no ledger details. For each job I tried to check the ledger entries in code, but cannot seem to capture the Date Filter off the request form to set the SHOWOUTPUT accordingly. How would I reference this correctly?
OnPreSection() - Header section
JobLedger.SETCURRENTKEY("Job No.","Posting Date");
JobLedger.SETRANGE("Job No.",Job."No.");
JobLedger.SETFILTER("Posting Date",'="Date Filter"');
Thanks
SGM
0
Comments
JobLedger.SETCURRENTKEY("Job No.","Posting Date");
JobLedger.SETRANGE("Job No.",Job."No.");
JobLedger.SETFILTER("Posting Date",'="Date Filter"');
Should be something like this instead...
JobLedger.SETFILTER("Posting Date",'>=%1&<=%2',"Starting Date","Ending Date");
"Starting Date" and "Ending Date" are Date variables in request form...
Maybe you should consider moving your code to OnPreDataItem trigger...
In .NET we believe
Actually you dont even have to use request form.
You can use GETFILTER to get the filter specified by user.
FilterString := GETFILTER("Date Filter");
(FilterString is a Text variable)
then you can use it to apply filter
RecVariable.SETFILTER("Date Field", FilterString );
Regards
Jyotsna