Printing an SSRS report to fit page
Posted on 2014-10-20
I have an SSRS 2008 R2 report with InteractiveSize set to 16.666in x 7.792in, which at 96dpi, corresponds to a page that is 1600 x 748 pixels. This is to fit a screen with resolution 1600 x 900 - the extra 152 pixels in height are to account for the browser header, SSRS header, and Windows task bar.
For hard printing (PDF and paper print), I've tried various settings in terms of printing to 8.5 x 11" landscape, and cannot get the "fit to page" effect correctly. I've tried setting PageSize to 16.666 x 7.792", as well as 11 x 8.5". It seems in all cases it wants to print at full-scale, and that translates to the content spilling over horizontally to a second page.
Any suggestions how to get it to print on one page?
I've even tried changing printer preferences to "fit-to-page", but it still spills over to a second page horizontally.