asked on

Need to export SSRS report to PDF fitting it to page

We have a number of wide reports which our customers wish to have exported to PDF fitting the width down to fit on a single page. These reports exceed even a US legal page in landscape orientation. It is understood that if the report is scaled to fit to page it will be unreadably without zoom.

Is there a way to do this? I understand that ideally the report's dimensions would be set to the dimensions of the target page but given the amount of data the report presents this is not a realistic option for us.

We are using SQL Server 2012.

SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vikas Garg

Hi,

i think you have to set the page margin of the report.

The page size should be >= the size of the content of your report.

If it is tabular report check the width of the table from properties which should be smaller then the report properties page size

canuckconsulting

ASKER

Thanks guys.

Phillip Burton - you mention the first option of cramming it into one-page wide without adjusting the report. How can this be done?

SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Howard Cantrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

canuckconsulting

ASKER

Thanks...ended up resizing the report page size to custom (and ridiculous) dimensions to meet the customers requirements. I expect longer term they will agree to reformat the report to be of a more reasonably width.