1,547
Hi Friend,
I have a PO report, it looks fine when generating it, but, when exporting it to PDF, somehow it creates extra page.
Report size is absolutely fit into one page. Tried so many things, it just won't help.
Any hint?
Thanks,
River
*This post is locked for comments
There many possible reasons.
European A4 (8.3 x 11.7 inches) and US Letter (8.5 x 11 inches) have different dimensions. If you design in one and print in the other format then you may well get an extra page. (See e.g. the FreeTextInvoice in Visual studio the Body size causes the blank page issue.he drop down list (or have the report itself in focus when you open Properties).
What we don’t see through Report Properties is the Interactive Size, which determines how the report is rendered in the report viewer. To access this go into the Properties tab and select “Report” from t,You can set the Interactive Height to 0 so the report to never breaks and display all data on a single page. Assuming the Page Size is set up correctly, it will still put the appropriate page breaks in when exported to PDF, and will print properly, and it saves the user having to continuously click to go through to the next page when viewing the report. However, its not so simple if your report is loading a substantial amount of data, then there could be significant performance losses by not using paging, and with lots of data, your report may fail to run altogether. Of course this property can also be set to a specified height, allowing for more data to be displayed per page, without putting any noticeable impact on load times. if you decide to render the entire report onto a single page, then I suggest to fix the first row in place so that it stays as the first visible row regardless how far down the page you are. This can be coupled with repeating this row on each new page so that it is still nicely presented for printing.
Set the property of textbox called “CanGrow” to False for not allowing the section to grow vertically:
There is a property called ‘CanGrow’ for textboxes, MSDN specifies that if set to True, then it will allow the section or control to grow vertically so that all data it contains can be printed or previewed. St to False.
Set ConsumeContainerWhiteSpace property to True.
Under Print destination settings – Properties – Check “override default settings”:
Don't use + to concatenate text - use & instead.
See whether setting "Keep Together" attribute to False makes any difference.
After reviewing obvious things like the page format for your pdf and printer properties if you still have the problem, then to trouble shoot the cause put different background colors on any object you think may bleed into another page. When you generate as a PDF you'll at least have a color on that extra page which will tell you which object is causing the trouble. put the problem object in a rectangle and the problem will likely go away
You can put multiple objects in a rectangle and ensure the "Keep Together on One Page if possible" box is checked in the rectangle's properties.
If all else fails then try this utility to remove the extra page ttps://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/#packages
River,
when you export a report into PDF what happens is that PDF has its own margins which are bigger than the on-screen report so a part of the report margin causes it to print an extra page, consider shrinking the width of the report design like 25% and then see if extra page prints if not then gradually increase the report width to a point where the PDF export stays on one page.
Make sure of the following things in Visual Studio Designer that your report contents size + margins does not exceed the total size of the report.
I usually follows a formula to avoid such issues.
(Report Content Size + Margins) - 0.5 = Page size defined
Hope this helps you
I would suggest you make all margins set to 0, remove any white spaces in between the report elements, check the width and the length of the report and all the report elements(header, body, tablix, footer).
Merge all the tablix, which are not in use, into one. Also, check the sizing options of the report elements. Try these and kindly let us know if it works.
It's a common issues into SSRS report when exporting to PDF. I suggest you to change the marge, into Visual Studio section body design click Rerport - Report properties menu, set Left and Right Margins to 0.00, Paper size A4, Width 21 cm Height 29.7 cm and in the body section set the properties Size to Width 20.cm
make sure the design is absolutely having no blank space below all rendering controls.Even blank space is considered a static space to be rendered, so the report even though finishes in a page will render this blank space you might have left out.
Check for you report width in similar fashion
Now check for report sizes including margins. if you report paper size is A4 check for A4 sizes and dont let the design to be having more than this size.
Interactive sizes should be accordingly set.
If these are taken care of , i don't see anything else causing problems
during making srs report in visual studio. insert footer on design page.
if you have data for footer put inside the footer or blank it.
make sure footer has small size
deploy and check
please if it is proper solution.let me know.
thanks
kundan
can you please re-verify the length-width of each and every section and make sure it will not exceed the total length of A4 page size.
Make sure your report size in your report properties can handle all text in report (including header and footer must be counted when you set report size).
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
