This is an experience that can drive you crazy. You have designed a report to run with the RTC. The preview looks nice and exactly how you expect it. Then you decide to print the report on paper or export it as PDF. And unexpectedly every other page is blank! Headers are printed, but there is no data on it. And the total number of pages is doubled.
The reason for this behavior is almost always caused by the body of the report being to wide for the page. The maximum width of the body should be the physical page width minus the margins.
Or to put it exactly: Body Width <= Page Width – (Left Margin + Right Margin)
To set the physical page size in Visual Studio, choose Report –> Report Properties. On the tab Layout you can set the correct values.
Based on these settings you can calculate the maximum width of the body, also called the Usable Area. In this example the maximum width of the body is 21cm – (1,5cm + 0cm) = 19,5cm. The actual size of the body can be set via the properties of the body:
It is important to keep in mind the concept of Usable Area. The body width should not exceed the usable area. If it exceeds the usable area during rendering, it will break the page onto a new page. For detailed information about pagination with Reporting Services, see the next MSDN article: http://msdn.microsoft.com/en-us/library/bb677374(v=sql.100).aspx