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
- 300 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Report RDLC Variable paper size
DefinitelyNotBete
Member Posts: 4
Hello
I have a ticket-report.
It will be printed to PDF and send to a ticketprinter over the webclient.
The RDLC has a fixed width of 8cm, but needs to have a variable height.
The ticket should contain exactly the content and no extra white space at the bottom of the PDF.
When the height in the paper size of the RDLC is set to a value, the PDF will be split in pages with a height of that value.
Example: height = 15cm
Report contents has a length of 16cm.
The result will be 2 pages: one page with full contents and another page with 1cm of contents and 14cm of white space.
This means 2 tickets will be printed.
Q: Is it possible to set the page height variable?
From testing: it can't.
Pagesize is defined at designtime, and it has no clue about the amount of data that will be used in the report at runtime (henceforth it can't know the exact page heigth).
Setting the page height to blank, makes the report default to A4 height of 29.7cm (no clue where this comes from).
Setting the page height to 0, gives the following error:
Error while validating RDL content:
The value of the PageHeight property for the report section ‘ReportSection0’ is “0”, which is not a valid size. Valid sizes may not exceed 455 inches (1155.7 centimeters).
Setting the pageheight to 1cm, creates many small tickets, but reduces the white space at the end.
This has also as effect that white space is introduced inbetween the content (in order to fit the content of each row/area on a page of 1cm).
Setting the pageheight to something very large (100cm), creates 1 long ticket, where most of the ticket is whitespace.
So any ideas how to solve this (if it's possible)?
Using NAV2017CU2.1 & Visual Studio Premium 2012
Thanks!
I have a ticket-report.
It will be printed to PDF and send to a ticketprinter over the webclient.
The RDLC has a fixed width of 8cm, but needs to have a variable height.
The ticket should contain exactly the content and no extra white space at the bottom of the PDF.
When the height in the paper size of the RDLC is set to a value, the PDF will be split in pages with a height of that value.
Example: height = 15cm
Report contents has a length of 16cm.
The result will be 2 pages: one page with full contents and another page with 1cm of contents and 14cm of white space.
This means 2 tickets will be printed.
Q: Is it possible to set the page height variable?
From testing: it can't.
Pagesize is defined at designtime, and it has no clue about the amount of data that will be used in the report at runtime (henceforth it can't know the exact page heigth).
Setting the page height to blank, makes the report default to A4 height of 29.7cm (no clue where this comes from).
Setting the page height to 0, gives the following error:
Error while validating RDL content:
The value of the PageHeight property for the report section ‘ReportSection0’ is “0”, which is not a valid size. Valid sizes may not exceed 455 inches (1155.7 centimeters).
Setting the pageheight to 1cm, creates many small tickets, but reduces the white space at the end.
This has also as effect that white space is introduced inbetween the content (in order to fit the content of each row/area on a page of 1cm).
Setting the pageheight to something very large (100cm), creates 1 long ticket, where most of the ticket is whitespace.
So any ideas how to solve this (if it's possible)?
Using NAV2017CU2.1 & Visual Studio Premium 2012
Thanks!
0
Answers
So all you have to do is to modify the PageHeight tag at runtime, when the report layout is exported to print the report. This could be done in the function GetCustomRdlc in Codeunit 9650 for either built-in layouts or custom layouts. Note, that GetCustomRdlc is called from Codeunit 1.