Print to BullZip PDF problem

G8tor
Member Posts: 29
Hello
I have report that im going to output to Bullzip PDF printer. I used the ara3n webblog to guide me through this. http://mibuso.com/blogs/ara3n/2008/08/01/save-nav-reports-to-pdf/.
But I notice when I used the same method that he described in the webblog I only can use one dataitem filter to print to the PDF. My report hast two dataitem tab on the request form and both with inserted filter on it. So when I print to PDF file from Bullzip I only get the header of the report that is filtered by Employee."No." and nothing probably because the filter from second dataitem tab LedgerInfo."Posting Date" is not sent to the PDF Codeunit. My report works fine in the "Print preview". How can I print out report in Bullzip PDF that has filters on two dataitems? How will the codeunit look like?
Dataitems
Employee -> Request form filter is "No."
Ledgerinfo -> Request form filter is "Posting date"
I have report that im going to output to Bullzip PDF printer. I used the ara3n webblog to guide me through this. http://mibuso.com/blogs/ara3n/2008/08/01/save-nav-reports-to-pdf/.
But I notice when I used the same method that he described in the webblog I only can use one dataitem filter to print to the PDF. My report hast two dataitem tab on the request form and both with inserted filter on it. So when I print to PDF file from Bullzip I only get the header of the report that is filtered by Employee."No." and nothing probably because the filter from second dataitem tab LedgerInfo."Posting Date" is not sent to the PDF Codeunit. My report works fine in the "Print preview". How can I print out report in Bullzip PDF that has filters on two dataitems? How will the codeunit look like?
Dataitems
Employee -> Request form filter is "No."
Ledgerinfo -> Request form filter is "Posting date"
0
Comments
-
You need to create a variable for your report and pass the two dataitem data filters.
Like this.MyEmployee.setrange("No.",'Blah'); Myreport.SETTABLEVIEW(MyEmployee); Ledgerinfo.setrange("posting date",TODAY); Myreport.SETTABLEVIEW(Ledgerinfo); Myreport.USEREQUESTFORM(false); Myreport.RUNMODAL;
0 -
Thanks ara3n. This is exactly what I was looking for.0
-
You are welcome.0
-
Can I have follow up question?
This report that Im doing very complex.
1. The request form have controls that controls what appears in the report. If I have checkbox that I click on the request form that is connected varible that controls the flow of the report. How can I make this variable affect the report in the CU when I call it?
2. If I have two dataitems that points to the same table. When I set the Myreport.SETTABLEVIEW(LederInfo) to add the filter for the first dataitem, will the second dataitem with the same record table override the SETTABLEVIEW(Ledgerinfo). Myreport.SETTABLEVIEW(MyEmployee);
DataItems
Employee
->LedgerInfo
->Journal Calculation
->LedgerInfo : Dataitem pointed to the same table as the above Lederinfo.
-> Entry
How do you print out complex report with multiple filters on dataitems in Bullzip PDF?0 -
1. Create a function in your report to set the value of the checkbox. Then cal the function from your CU before calling CU.
2. Change the report to copy the filters from first LedgerInfo to the second one on OnPreReport, or follow the steps above and create a function and pass the filters .0
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