Link to home
Create AccountLog in
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 ValentinoV
ValentinoV
Flag of Belgium image

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...
Avatar of UnderSeven
UnderSeven

ASKER

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?
You led me to the answer which is the header and footer was not displaying because in ssrs it never will.
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Thanks for the additional explanation.  The reference document was also helpful.
Glad to hear, I was typing it while you closed off the question :)