Avatar of UnderSeven
UnderSeven asked on

ssrs subreport not viewing when running

I have a report with nested sub reports with nested sub reports.

When I view it, the inbetween report is skipped.

so Main > sub > sub2 only shows
main > sub2

No errors, I have no idea what is causing it.  Help would be appreciated.

Avatar of undefined
Last Comment

8/22/2022 - Mon

I don't see how this is possible?  If you can see sub2, I would think you're seeing sub as well because sub2 is only contained in sub?  Perhaps you can use different background colors in each report to "debug" this?  If each report has a different background color you can easily see what part is coming from what report...

A second look indicates that in fact sub 1 is showing, but just a small portion of it.  It's excluding everything above the nested subreports and everything below, but containing everything that happens in sub one around nested sub 2.

It's excluding the header and footer from the subreport 1.  How do I include this?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes

You led me to the answer which is the header and footer was not displaying because in ssrs it never will.

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Thanks for the additional explanation.  The reference document was also helpful.

Glad to hear, I was typing it while you closed off the question :)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.