Today, I met a issue about ssrs. I set the page size to Legal(14in * 8.5in), and the body size to 14in * 8.5in. I exported an excel to print, the print preview shown that the only one page was divided into two pages. In first page, there were 2 columns lost, and they were shown in the second page.
When I setting the body size to 12.25in * 8.5. the print preview for excel can work well. Do you have any idea to explain this result?
The other setting for the report:
InteractiveSize:14in * 8.5in
This is because the Body Size and Page size are added together, and in your case are exceeding the page width.
That is why you are getting extra pages.
Have a look at this article to understand how pagination works in SSRS
- Proposed as answer by Charlie LiaoMicrosoft contingent staff, Moderator Wednesday, July 24, 2013 2:23 AM
Many thanks for your reply. I found out the report body size will grow or shrink depending on the content, but most of the reports's content are dynamic, this will result in the exported reports, such as excel, sometimes work better, sometimes span multiple pages. I think this maybe an issue, because I really expected my report's body was fixed by a specific size.
Once one page span two pages, this is very terrible for the end user.
My report without variable columns, and every columns with a fixed size. The following are the report setting:
Page size: 14in * 8.5in
Tablix size: 13.5in
Body size: 13.5in
When printing exported excel, every page span two pages. So I update the tablix size to 12.25in and body size to 12.25, which size can print better. But I feel very wondering.