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.
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!


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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

13 Experts available now in Live!

Get 1:1 Help Now