Print Layout Problems in Report Viewer

Question

I have generated the report on form successfully(10 pages). but when I click on Print Layout then getting 20 pages.

I am using Dot Net Framework 4.0.

Please help me. thanks in advance

Answer 1

http://technet.microsoft.com/en-us/library/ee210530.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/d82d1cfc-e386-4cbc-b923-590b2a58fe8e

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

Hi Gsunilg,

The issue may be caused by that your report body size is larger than the Page Size. When previewing report on “Print Layout”, the report body is the same with paper size, so when you preview the report, it can display more data than preview on “Print Layout”. In order to print correctly, the total width of Body, Left margin and Right margin must be less than or equal to Page width. By default, the page size is 8.5 x 11 inches, so make sure that the total width of Body, Left margin and Right margin less than or equal to Page width in your report. And then added page breaks at appropriate places to see if the issue is disappear or not. For more information about Pagination in Reporting Services (Report Builder and SSRS), please see:
http://msdn.microsoft.com/en-us/library/dd255278.aspx

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support