Solved

ssrs subreport not viewing when running

Posted on 2014-03-11
8
570 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now