SSRS Linked Report doesn't seem to honour Page settings when printed
Posted on 2013-11-15
I have a report that is designed for A4 portrait, where the page size and interactive page size are 8.27 x 11.69. The margins are set at 0.25in all round, giving an available width for the body of 7.77 inches. Currently, the Body width property is 7.67717in, so a little room to spare.
There are 4 subreports on the main report, and I have made sure they all have a Body with of 7.677in and start at horizontal location 0 on the main report. A couple have column groups and could extend onto a 2nd page, but that isn't what's happening here. ConsumeContainerWhitespace is true on all sub-reports and the main report.
I deploy to the server into one location, and have set up other locations for other parts of the business with Linked Reports, with their own set of report parameters defaults.
If I use the report from its original location, enter my parameters, View Report and print to my default printer, I get 4 pages and all is good.
If I navigate to the other location and select the linked main report, then set all parameters to the same values - that is override the different defaults - and View Report, all looks identical. But, when I print, the left margin is quite a bit bigger and data items spill over onto a 2nd horizontal page and I get 8 in total. But, only whole columns, so I believe this to be an SSRS layout / render issue, not down at the printer.
Checking the default printer properties from the Print dialogue in Report Manager shows it is wanting Letter. In fact, using Preview from the Printer dialogue is also correct from the original deployment location, and spread over two pages for each page from the Linked Reports folder.
Final test - delete the Linked Report and upload as an original deployment, and all is OK.
Does anyone know what is going on here, have any experience of the issue, or know how to resolve it, because the concept of Linked Report is going to be very handy for us - assuming we can rely on it.
I'm off now until Monday - have a flight to catch, so won't be a quick reply to any responses I'm afraid.
Cheers, and thanks for the help in advance.