I am using SQL Server Reporting Services 2005 (SSRS 2005) to create a portrait report for A4. This report contains some textual data and a matrix placed in a list, so that the effect of a horizontal table is created (with columns representing various repeating fields). The problem I am facing is that when I export a report to PDF (or print it) between each data page, I get a blank page with only a header, footer and no data. I read that this could be due to the fact that the body + left + right margin is larger than the width of the report. However, this is not the case, and I have the following relevant settings:
InteractiveWidth (Report) - 8.5in; PageWidth (Report) - 21 cm; PageHeight (Report) - 29.7 cm; Left margin (report) - 0; Right margin (report) - 0; Upper margin (report) - 0; Lower margin (report) - 0;
Body width is 7.2 inches.
The matrix contains 2 fixed columns and is set to repeat all additional 5 columns using the following grouping expression in the list: = Ceiling (RowNumber (Nothing) / 5)
I noticed that if I change this matrix to repeat every 2 columns horizontally, the report prints correctly, without blank pages. (But 3.4 or more columns leads to a problem). And there is more than enough space for 5 columns, and it would be very strange to print just 2! So, I think something in the list / matrix is causing the problem, but I don’t know what exactly!
Any help would be greatly appreciated! Thanks Tim