Solved

Need to export SSRS report to PDF fitting it to page

Posted on 2014-11-10
7
5,205 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 15

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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

756 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