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.
SSRS

Avatar of undefined
Last Comment
ValentinoV
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.
Avatar of UnderSeven
UnderSeven

ASKER

It's excluding the header and footer from the subreport 1.  How do I include this?
Avatar of UnderSeven
UnderSeven

ASKER

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

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of UnderSeven
UnderSeven

ASKER

Thanks for the additional explanation.  The reference document was also helpful.
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Glad to hear, I was typing it while you closed off the question :)
SSRS
SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

10K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo