Solved

SSRS 2005 Page Count is incorrect

Posted on 2011-09-12
5
333 Views
Last Modified: 2012-05-12
I have a report written using SSRS 2005 where I have changed the margins to print in landscape mode. The issue I have is that a user can send a report to the screen and it will show page 1 of 10. However, when the user prints out the report it will print about 18 pages because on paper it is counting 11 x 8 1/2 as opposed to what was on the screen which was 8 1/2 x 11. So there are fewer lines per page when it prints as opposed to the screen. I see in SSRS 2008 there is a setting for landscape. Is there any way using SSRS 2005 to get the total page count when viewed on the screen to equal the total page count when printed.?
0
Comment
Question by:rwheeler23
[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
  • 3
5 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 36524492
You mean to say even after setting the report as landscape, it prints in portrait style?
0
 

Author Comment

by:rwheeler23
ID: 36526759
I do not see anywhere in SSRS 2005 to set the report to landscape. What I mean is that it does print landscape and when viewed on the screen it will say page 1 of 10, but when you actually print it takes 18 pages. I have changed the report properties to be 11 x 8 1/2.
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 36529160
Got to Report Properties


Untitled.png
0
 

Author Comment

by:rwheeler23
ID: 36529733
Is this SQL Server 2005 or 2008? My page setup screen does not look like this. I am using VS 2005 BIDS. It must have been updated for VS 2008.
0
 

Author Closing Comment

by:rwheeler23
ID: 36547155
I had stated that the solution was needed for SQL Server 2005 and I was given a solution for 2008.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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 …
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 this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

691 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