Answered by:
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
Thursday, December 6, 2012 6:11 AM
Answers
-
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.aspxIf you have any questions, please feel free to ask.
Regards,
Charlie LiaoCharlie Liao
TechNet Community Support- Proposed as answer by Shahfaisal Muhammed Friday, December 7, 2012 2:31 PM
- Marked as answer by Charlie Liao Wednesday, December 12, 2012 10:00 AM
Friday, December 7, 2012 6:03 AM -
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
- Marked as answer by Charlie Liao Wednesday, December 12, 2012 10:00 AM
Thursday, December 6, 2012 6:16 AM
All replies
-
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
- Marked as answer by Charlie Liao Wednesday, December 12, 2012 10:00 AM
Thursday, December 6, 2012 6:16 AM -
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.aspxIf you have any questions, please feel free to ask.
Regards,
Charlie LiaoCharlie Liao
TechNet Community Support- Proposed as answer by Shahfaisal Muhammed Friday, December 7, 2012 2:31 PM
- Marked as answer by Charlie Liao Wednesday, December 12, 2012 10:00 AM
Friday, December 7, 2012 6:03 AM -
Thanks, It's working.Wednesday, March 29, 2017 10:07 AM