Solved

Tips to print SSRS report in single page

Posted on 2009-06-29
3
1,164 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
[X]
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
  • 2
3 Comments
 
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.
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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 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