Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Tips to print SSRS report in single page

Posted on 2009-06-29
3
1,155 Views
Last Modified: 2012-05-07
experts are there any tips to print SSRS reports into a single page as my reports have many columns.
0
Comment
Question by:Svlss
  • 2
3 Comments
 
LVL 26

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.
0
 
LVL 16

Accepted Solution

by:
Auric1983 earned 500 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.
0
 
LVL 16

Expert Comment

by:Auric1983
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.
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 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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

790 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