Thursday, December 06, 2012 6:11 AM
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 06, 2012 6:16 AM
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 LiaoMicrosoft Contingent Staff, Moderator Wednesday, December 12, 2012 10:00 AM
Friday, December 07, 2012 6:03 AMModerator
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:
If you have any questions, please feel free to ask.
TechNet Community Support