Solved

PDF Rendering in SSRS

Posted on 2014-09-12
7
246 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
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

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

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…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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