Solved

Tips to print SSRS report in single page

Posted on 2009-06-29
3
1,149 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

11 Experts available now in Live!

Get 1:1 Help Now