Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

ssrs subreport not viewing when running

Posted on 2014-03-11
8
591 Views
Last Modified: 2014-03-17
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
Comment
Question by:UnderSeven
  • 4
  • 3
8 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39922739
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
 

Author Comment

by:UnderSeven
ID: 39923426
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
 

Author Comment

by:UnderSeven
ID: 39923447
It's excluding the header and footer from the subreport 1.  How do I include this?
0
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 

Author Comment

by:UnderSeven
ID: 39923477
You led me to the answer which is the header and footer was not displaying because in ssrs it never will.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39923486
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
 

Author Closing Comment

by:UnderSeven
ID: 39932532
Thanks for the additional explanation.  The reference document was also helpful.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39933668
Glad to hear, I was typing it while you closed off the question :)
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question