Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • Last Modified:

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.
0
UnderSeven
Asked:
UnderSeven
  • 4
  • 3
1 Solution
 
ValentinoVBI ConsultantCommented:
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...
0
 
UnderSevenAuthor Commented:
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.
0
 
UnderSevenAuthor Commented:
It's excluding the header and footer from the subreport 1.  How do I include this?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
UnderSevenAuthor Commented:
You led me to the answer which is the header and footer was not displaying because in ssrs it never will.
0
 
ValentinoVBI ConsultantCommented:
It's excluding the header and footer from the subreport 1.  How do I include this?

That's by design: subreports will never render report header/footer.  Only the report body gets rendered.  So if you need the info from the header/footer you'll have to implement it differently: either in the main report or in the subreport but without using the report header/footer.

Official doc:

Headers and footers that are defined in the original RDL file are not rendered when the report is rendered as a subreport.
Ref Understanding Rendering Behaviors
0
 
UnderSevenAuthor Commented:
Thanks for the additional explanation.  The reference document was also helpful.
0
 
ValentinoVBI ConsultantCommented:
Glad to hear, I was typing it while you closed off the question :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now