Solved

Need to export SSRS report to PDF fitting it to page

Posted on 2014-11-10
7
4,112 Views
Last Modified: 2014-11-13
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.
0
Comment
Question by:canuckconsulting
7 Comments
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 400 total points
ID: 40432615
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
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40432619
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
 

Author Comment

by:canuckconsulting
ID: 40432641
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 50 total points
ID: 40432644
>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
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 400 total points
ID: 40432648
>> 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
 
LVL 27

Assisted Solution

by:planocz
planocz earned 50 total points
ID: 40439061
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
 

Author Closing Comment

by:canuckconsulting
ID: 40439613
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now