SSRS 2005 Page Count is incorrect

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.?
rwheeler23Asked:
Who is Participating?
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Got to Report Properties


Untitled.png
0
 
TempDBACommented:
You mean to say even after setting the report as landscape, it prints in portrait style?
0
 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
I had stated that the solution was needed for SQL Server 2005 and I was given a solution for 2008.
0
All Courses

From novice to tech pro — start learning today.