Menu
I am getting a blank page, at the end of my report in SSRS 2005.
I have a header logo and footer date values, and I have set the both to PrintOnLastPage = False, but I am still getting a blank last page.
Any ideas how to eliminate it? Thanks!
654
To avoid blank pages, set each "BreakLocation" property of each tablix to "None". Sometimes it defaults to "End" and the number of blank pages depend on the number of tablix in your report.
A common reason why blank pages are output, is the report body width exceeds the available page space. You can only view and set the report body width using the Properties pane.
To delete a page break, select the column to the right of the page break and choose Insert > Remove Page break — or use one of the following methods to resize a column in the Report Designer. Click the column header letter button of the column to change to column mode, and then choose Format > Column > Width.
SSRS does NOT handle page breaks in sub reports well! You may be able to control the numbering by putting everything in one report. You could also explore using rectangles to control the page break locations.
Besides, if we add duplicated page break, for example, select both “Add a page break before” and “Add a page break after” options when we design a report, blank page could appears between pages. So please check if your page break options setting is set correctly.
Any report developer who has worked with SQL Server Reporting Services for any time will definitely say that coordinating and navigating page breaks and page numbering can be quite a challenge. It seems that Newton's Third Law, "For every action, there is an equal and opposite reaction", applies to setting page sizes and page breaks in SSRS.
SSRS Soft Page Breaks. The soft page-break renderers include outputs that are generally displayed on a screen and includes the SSRS preview, HTML and MHTML formats. This format utilizes the scroll bar instead of inserting a vertical page break which of course is appropriate for display or screen based.
This solution applies for SSRS 2008 R2. I am not sure about earlier versions. On Report Properties page, under category Other, set ConsumeContainerWhitespace to True.
Other suggestions still apply: Make sure your Paper Size can contain Report Width and Margins. Remove any white space you may have on your Report.
Good luck.
109
Shorten the width of the report, dragging the right vertical side to the left.
4
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
