sql server reporting services - sub reports appearing over top of each other / lots of blank pages.

Question

I have 2 places in my main report where 2 sub reports are appearing on top of each other. I have checked the tablix in the main report and selected: Add a page break before. I event tried checking add a page break after, but that does not separate the pages from being on top of each other. what can I do to correct this? I also have a lot of blank pages in my report with just the date and time at the bottom of the page. How do I delete blank pages? A 14 page report should not take 26 pages to print.

These blank pages and pages on top of each other only appear in print layout.

Answer 1

I solved my problem:

1. The tablexes for the sub reports that were appearing on top of each other were in fact resting on top of each other. When I added space between them, the sub reports were no longer on top of each other.
2. The page width of the main report was wider that 8.5". Thus it was wrapping onto a second page for each page and making the page have many blank pages.

Answer 2

Hi RCDA Webmaster

Glad to hear that your issue has been resolved, if you have any more questions, you may also post it on Q&A.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.