How do I get rid of the extra blank page in SSRS?

15 Answers

1. Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI)
2. Make a note of the values for Page width, Left margin, Right margin.
3. Close and go back to the design surface.
4. In the Properties window, select Body.
5. Click the + symbol to expand the Size node.
6. Make a note of the value for Width.

How do I delete a blank page in report Builder?

Choose File > Report Designer. Select the report to open it in the design grid. 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.

How do I insert a page break in SSRS?

To add a page break to a data region

1. On the design surface, right-click the corner handle of the data region and then click Tablix Properties.
2. On the General tab, under Page break options, select one of the following options: Add a page break before. Select this option when you want to add a page break before the table.

Is there an extra blank page in SSRs?

I have a report created in SSRS 2008 that I call from and display in an asp page using the ReportViewer Control. In the ReportViewer my report has an extra/blank page at the end, but when I export it to PDF my report is perfect!. Nothing gets off the page, margins and size are all fine, under 10.0 in for a landscape report.

Is there a way to export SSRs reports to PDF?

Keep It Simple and Fast: Export of SSRS reports to PDF generates extra blank pages. Export of SSRS reports to PDF generates extra blank pages. In Reporting Server you have the option to export your reports to PDF. This works fine however sometimes extra blank pages are generated. For instance, the reports is rendered on your screen on 3 pages.

Is there maximum page width for SSRS report?

If possible, please provide your report design for our deep analysis. In Reporting Service, layout of items in the body should meet this requirement: Maximum Body Width=Page Width – (Left Margin + Right Margin). So please check these items are set correctly in your report.

How to give blank page at the end of report?

For example if you have 3 tablix in your report and if each tablix has a “BreakLocation” property set to “End”, you will have 3 blank pages. set ConsumeContainerWhitespace to True if it is 2008 R2. I had an image on the last page and when it’s size was set to 210mm, 297mm (A4) it produced a blank page at the end of the report.