Solved

SSRS 2005 Page Count is incorrect

Posted on 2011-09-12
5
322 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
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

12 Experts available now in Live!

Get 1:1 Help Now