I'm running into a weird issue when exporting a report to PDF format. The report itself is in landscape orientation and all columns fit on one page just fine. I have several categories in the report where it is grouped on. For example, there are five invoice types (A, B, C, D, E, F). The report gathers the results and groups on the invoice type. I want the report to start a new page for each group. This works fine in Report Viewer. But when rendering in PDF, Reporting Services sticks in a blank page between each group. If I uncheck the option for page break on each group, everything just runs together. as one big sheet and no new page for each group. Am I missing something here? Any help would be appreciated! Thanks!A. M. Robinson

I'd check the Report|Report Properties|Layout settings. Also make sure the objects width is not greater than the page width setting minus the left/right margin settings. Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

Adjust your report layout properties to fit into one page, this won't add a blank page. Thanks Kumarkk

Actually...the report layout DOES fit on one page already...A. M. Robinson

Did you check the settings I mention or is this based on something else? My experience is that this is almost always the solution. Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

Yes, that is ALWAYS the solution. Kumarkk

The width of the tablix and all objects is 10 inches. Both left and right margins are only 1/10 of an inch. The export is still putting in an extra page between groups... <Name Language="en-US">PDF in A4 Landscape</Name> </OverrideNames> <Configuration> <DeviceInfo> <OutputFormat>PDF</OutputFormat> <PageHeight>8.27in</PageHeight> <PageWidth>11.69in</PageWidth> <MarginBottom>0.2in</MarginBottom> <MarginLeft>0.1in</MarginLeft> <MarginRight>0.1in</MarginRight> <MarginTop>0.2in</MarginTop> </DeviceInfo> </Configuration>A. M. Robinson

I think 11.69in is a problem, too wide. Two things to check. On layout tab Layout|Properties make the Size property 10in wide if that's all that is required. Then Report|Report Properties|Layout settings. Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

That actually made it worse. With those settings, all columns will not fit on one page. The body of the report is only 10.3" in width. The tablix itself is only 9.8" wide. The body is 10.3" wide. The page size is 11" wide, with zero inch margins. This should be ample space for everything to fit on one page without the need to spill over onto another page... Not sure what the deal is here...A. M. Robinson

0" margins is probably beyond the limits of the selected printer. Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

Have you tried to change ConsumeContainerWhitespace to TRUE? This is a Report level property.

Hi Robinson, Please check rparge's reply. This new property has been introduce in Reporting Services 2008, which wasn't their in Reporting Services 2005. We also came back this specific issues two months back after upgrading SSRS2005 to SSRS2008. By changing this property value everything went perfectly. Thanks Kumarkk

I'm not selecting a printer. This is strictly an issue with rendering in PDF. The capabilities of the printer wouldn't have anything to do with the export.A. M. Robinson

rParge: Gracias!!! That was it!!! Many thanks!!!A. M. Robinson