December 8, 2011 at 2:31 pm
I Was using SSRS 2008, I created SSRS report. After I moved to pdf, it shows me the second page is blank. From 19 pages. every time from my report the second page is blank. Just the second page, not the last page. I have more than 10 page but Just the second page??
I used page setup. Letter 11inch by 8.5 inch
When it was cusom size 11.2 by 8.5 the second page is not blank. But i need letter paper size?
Can I get feed back?
regards
December 8, 2011 at 2:42 pm
Long time ago I saved the recipe below - credits to Nathan (no last name) who was the original poster. Let me quote:
In BIDS, do the following:
1.Click on Report > Report Properties > Layout tab
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
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.
Remember: (Body Width + Left margin + Right margin) <= (Page width)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 8, 2011 at 3:41 pm
pdf format is really picky about the margins. for letter size, you must set up the paper size letter - 8.5 x 11, set the report margins to .25 all around. need to set the report interactive size also 8.5 x 11. make sure that your report elements do not exceed the 8" width (assuming portrait orientation). If you go over the margins by even a point, pdf will add a blank page.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply