Menu
I've built a report in Reporting Services and when we browse to the report in Internet Explorer we want to be able to export the report in PDF format. It works, but it was cutting off the columns to the right and displaying them on the next page (in PDF) because the page was too wide. I changed the orientation to landscape and it still cut off the columns on the right. Then I changed the page size to legal paper and it fits on one page, but we want the report on letter size paper. Is there a way to compress the report to fit on letter size landscape?
533
To change paper sizeRight-click outside of the report body and click Report Properties. In Page Setup, select a value from the Paper Size list. Each option populates the Width and Height properties.
You can open a report (with parameters if required) and render it directly to PDF format with something like http://myServer/ReportServer?/ReportName&rs:Format=PDF .
To delete a page break, select the column to the right of the page break and choose Insert > Remove Page break — or use one of the following methods to resize a column in the Report Designer. Click the column header letter button of the column to change to column mode, and then choose Format > Column > Width.
Here is how to get a report to fit on a letter page:
198
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
