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.
canuckconsultingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Are there any adjustments you can make to the report? For instance, instead of reporting in $s, can you report in 1,000s of $s? Are there things which are next to each other which can be underneath each other.

Unless you adjust the report, it seems you have two options:

1. Cramming everything into one page wide - but you say that's unreadable.
2. Printing more than one page wide - but you say that's not what you want.

Therefore, either print on A3 (Tabloid size), or adjust the report so it is readable.

I can't see what else you can do.
0
Vikas GargBusiness Intelligence DeveloperCommented:
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
0
canuckconsultingAuthor Commented:
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?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Is there a way to do this?
No.  SSRS does not have a 'Fit on 1 page height by 1 page width' like Excel does, and as the above experts state the only means you have to ensure that the report fits on one page is to eyeball the report dimensions and margins and make sure they fit the page.

That, and if your report has any matrix/tablix objects, make sure the data/data set is such that the number of columns/columns and rows fit on one page.
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
>> you mention the first option of cramming it into one-page wide without adjusting the report.  How can this be done?

I thought you had already done that. Basically, printing a report to a PDF using a big enough page size! You can then print it out on paper to whatever size you want. But if it's unreadable, I don't see how that would help you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
planoczCommented:
I have  done a lot PDF reports with SSRS.
The best thing to do is re-structure your SQL querys to use less data.
You will have to make more than just one report (per your old querys) to see all the data you want.
The customer (user) will like this better for readablity and easier to write corrections on the report.
You can also going to a smaller font; I use 9pi.
0
canuckconsultingAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.