Solved

PDF Rendering in SSRS

Posted on 2014-09-12
7
256 Views
Last Modified: 2014-09-17
I have a SSRS report with 20 columns and everything looks fine while rendering into EXCEL,CVS and MHTML formats. But while rendering into PDF all columns are getting wrapped and font size becomes very small. How do I increase the font size and how do i fix wrapping the column problem. What is the best approach while rendering into PDF format. Any help is appreciated.
0
Comment
Question by:SURESH0518
  • 3
  • 3
7 Comments
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40319136
Hi,

In BIDS, do the following:

    Click on Report > Report Properties > Layout tab
    Make a note of the values for Page width, Left margin, Right margin
    Close and go back to the design surface
    In the Properties window, select Body
    Click the + symbol to expand the Size node
    Make a note of the value for Width

Please note that (Body Width + Left margin + Right margin) <= (Page width)
0
 

Author Comment

by:SURESH0518
ID: 40319494
All columns are fitting in one page but it is difficult to view the font size very small. My question how to increase the font size.
0
 
LVL 27

Expert Comment

by:planocz
ID: 40319762
You have to change the fonts in each cell in the windows properties of the table.
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

Author Comment

by:SURESH0518
ID: 40320395
When I increase font column values get wrapped and then I have to increase the width of cell. It looks very awkward when view online. Any suggestions are appreciated.
0
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 40320427
Ok, To start with in Pdf you will need to make sure each cell  has the cell set to NOT grow in the window properties. Also to will need to Trim all incoming data to the cell. Pdf is bad about having hide spaces in it.
Which can cause it row to wrap and goto a second page before it is needed.
Let me know if that helps.
0
 

Author Comment

by:SURESH0518
ID: 40323439
Thank you for the help. We have 30 columns to display in PDF and what will be best approach to render into PDF.
0
 
LVL 27

Expert Comment

by:planocz
ID: 40323657
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

828 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