?
Solved

Tips to print SSRS report in single page

Posted on 2009-06-29
3
Medium Priority
?
1,165 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 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.
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

800 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