So I've got some lovely reports, with headers and footers. I want to place them as subreports. Obviously, those headers and footers make a mess of my 'main' report. Thing is, I want to be able to see those headers and footers when the subreport is 'active.'

 

Is there any way to hide a subreport's headers and footers in the 'main' report view, and reveal them when I drill down to examine the subreport?

 

Thanks either way for the information; even a 'no' means I can stop chasing my own tail on this one.

 

I created a formula field called ReportLevel and set it to 1 in the subreport (just typed 1 in the formula), 0 in the main report, and made it a linked variable. Set the subreport's header and footer to hide when {ReportLevel} < 1. So far so good. I can run the report and it hides the subreport header, when I click on the subreport and make it active it reveals the header. I have confirmed that ReportLevel is defining itself properly, 0 at the report level, 1 when the subreport is 'active.'

 

Great, right? Except here's where my ignorance shows, because for reasons I don't understand it's dumping ALL the rest of my data. The subreport shows up as an empty bar, as if I had passed it date parameters for which there is no data. When I click on the subreport, the header and footer show, but there's no data and the charts are empty boxes.

 

I know that the data is there, because I've run it with the same data parameters without the ReportLevel trick in place and it populates just fine. What am I conflicting with here that makes it go all crosseyed? I've got to be doing something wrong.

 

However (ah-ha,) I'm beginning to think that this might not be working at all; I've got it to the point that it's giving my my data when I activate the subreport (by unchecking "select data in subreport based on field"), but the box in the main report is still empty. It's a refrigerator light problem; since it isn't acutally giving me a look at the report, I have no way of knowing whether or not the parameters are being passed and processed correctly.

 

I'm essentially wiggling around and seeing where it takes me at this point. I'll drop something here if anything changes.