Reporting Services report

Question

I created a report in reporting services 2005 with a report page size of 14in x 8.5in. The report looks fine in the reports manager and also in the report viewer. The issue is when I export the report to PDF, the page size in Adobe states 14 x 8.5 in but when you hit the print button, it selects Letter size (8.5 x 11) instead of choosing Legal size (8.5 x 14). If you then click on 'Choose Paper Source by PDF page size' or change the paper source to legal, the report prints out exactly the way I wanted it.

Does anyone have a solution to this? Thanks in advance

Answer 1

I've had this problem too, and I've never found a satisfactory solution. SSRS doesn't offer much control over print settings in export formats (like fit-to-one-page-across in Excel).

One work-around would be to roll your own interface, intercept the PDF file, and update the print settings before serving it up to the user. Could be a lot of work, and how would you know the intended page size? You could always parse the RDL file for the page size settings, and that would be a correct solution, but damn if that's not a lot of extra work.

EDIT: check the page size under page setup, as pv2008 suggested.

Answer 2

I remeber we had a similar problem a few months ago with Reporting Services 2008 (not 2005).

I think the solution was to "force" the values of Width and Heigth for the desired amount, regardless of the selected item in "Paper size" dropdown box (in Report Properties -> Page Setup)

In our case, we wanted to print in A4, so we set width = 21.59cm and height = 27,94cm, even if selected paper size remains as "Letter".

Answer 3

All the suggestions haven't worked. I am assuming that this is some sort of bug?