PDF Rendering in SSRS

Posted on 2014-09-12
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.
Question by:SURESH0518
  • 3
  • 3
LVL 14

Expert Comment

by:Vikas Garg
ID: 40319136

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)

Author Comment

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.
LVL 27

Expert Comment

ID: 40319762
You have to change the fonts in each cell in the windows properties of the table.
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.


Author Comment

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.
LVL 27

Accepted Solution

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.

Author Comment

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.
LVL 27

Expert Comment

ID: 40323657

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Suppress row when blank from 2nd dataset 2 41
SSRS  integration 5 90
SSRS expression Issue finding a string 10 66
SSRS Pie Chart Data Points Inside AND Outside 4 63
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: (…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

896 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

11 Experts available now in Live!

Get 1:1 Help Now