Category: sql server reportingservices
srisql on Mon, 23 Jul 2012 15:06:26
I have a wider tablix report which is 29 inches wide. I have given the paper size as custom and width as 29 and height as 11 in report properties.I have deployed it and saved it as PDF document. When I print preview the report I am using the paper size as tabloid (17 by 11) and selected the orientation as Landscape. I am getting the full report without any stripping but I am getting some extra space at the top and bottom when I print the report. Can anyone help me how to get rid of this space? . I checked the margins for the report and it was 0in. Please help.
bushfoot on Mon, 23 Jul 2012 16:37:48
check the margin settings in the report properties
srisql on Mon, 23 Jul 2012 17:51:21
checked all the margin settings.Everywhere it is 0in.
Syed Qazafi Anjum on Mon, 23 Jul 2012 20:50:02
In Reporting Services (SSRS 2008), there are white spaces preserved in the report body by default. When the white space extends the body size beyond the width of the report, blank pages will be generated. To avoid the issue, you can set the “ConsumeContainerWhiteSpace” property of the report to “True”.
Please try to adjust your margins (top + side) and hopefully this problem will get resolved
Body Width <= Page Width - (Left Margin + Right Margin)
Horizontal usable area:
X = Page.Width - (Left Margin + Right Margin + Column Spacing)
Vertical usable area:
Y = Page.Height - (Top Margin + Bottom Margin + Header Height + Footer Height)
Body Width <= Page Width - (Left Margin + Right Margin) Horizontal usable area: X = Page.Width - (Left Margin + Right Margin + Column Spacing) Vertical usable area: Y = Page.Height - (Top Margin + Bottom Margin + Header Height + Footer Height)
If you have any questions please ask.
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
HelenWei on Fri, 27 Jun 2014 15:06:10
I have similar issue with the white pages on the SQL Server 2012 Report Builder 3.0. I created a multiple pages invoice report based on XML data file, which contains about 80 pages per report. The report runs good. But when try the Print Layout ,(PDF file too) some white space happened on the top of report bodies among or after page 70th of the report combines with the First letter "R" of Invoiced Company Name. Such as: "R Delivery Inc." or "Rock ..." , " Rose ..." " ,,," means names continues. (The report is sorted with Company name, and company ID). After "R". (The page # changes based on the "R" name s position), and the white space happens before "R" and jump up and down after. When the Other Letter shows up such like "S", the report text position goes normal until the end of report, the white space will be gone after "R". I tried all methods those I could find online to reset the page margins, page breaks, LTrim, RTirm Company names, setting of page breaks. So far all the method meet "R" will be no cure. (Even I set page break between each instance of a group, company names as “Rock...” and “Rose...“ are still set on same page. I am wondering, does the SQL Server 2012 Report Builder has pages limitation? Or The Letter "R" has some bugs hide behind? Please help!