SQLTeam.com | Weblogs | Forums

Ssrs export to pdf issue


#1

In an existing ssrs 2008 report that is exported as a PDF, part of the report is exported to a second page. However the report should only appear on one page.

I change the report to use a header and 1 rectangle. This works fine export that sometimes the only thing that appears on some pages is the header information. The header information contains the name of the report, run date and run time and page number .This report is setup to appear as 8.5 inches by 11 inches.

I basically do not want the page header to appear on some separate pages.

Thus can you tell me what I can do to solve this?


#2

In BIDS or SSDT-BI, do the following:

Click on Report > Report Properties > Layout tab
Make a note of the values for Page width, Left margin, Right margin
Close and go back to the design surface
In the Properties window, select Body
Click the + symbol to expand the Size node
Make a note of the value for Width
To render in PDF correctly Body Width + Left margin + Right margin must be less than or equal to Page width. When you see blank pages being rendered it is almost always because the body width plus margins is greater than the page width.