Tips to print SSRS report in single page

Posted on 2009-06-29
Medium Priority
Last Modified: 2012-05-07
experts are there any tips to print SSRS reports into a single page as my reports have many columns.
Question by:Svlss
  • 2
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24742477
Page orientation to Landacape, Print to larger paper size (Legal), use smaller fonts.  We have to print very small fonts on wide paper for some clients that insist on everything on one page.  That is all you can really do other than make it so it can export to Excel or somewhere that they can force it to print to 1 page wide, but it just does the same thing, makes the fonts very, very, small.
LVL 16

Accepted Solution

Auric1983 earned 1500 total points
ID: 24747734
Other thing you could do for columns that hold small amounts of data but have large titles, use multiple lines for the column headers.

I typically will group all my dates together and have two headers the first would say "Date Information" or something to that effect and have the dates below in short form.

on a very rare occasion i will use a shortform for a column name and explain it in the page footer.  some of our datasets have a "probability" field which is just a number between 1-9, rather than use all the space for "probability" i call the column *P and indicate on the footer that *P means Probability, most users understand.
LVL 16

Expert Comment

ID: 24747744
I also find your choice of font really makes a difference,  Times New Roman at 8pt looks a lot different on paper than Arial 8pt, etc.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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. …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

624 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