Click to expand subreport

[carmine1]

I know this should work - and annoyed with myself for not figuring it out.

Main report with two subreports - one residing in Da section and the other in Db.  Each subreport has Header, Details, and Footer section.  Header and Details are hidden, so that only the footers appear in the main report.

I want to be able to click on a subreport in the main report view and have the full subreport open, with headers, details, and footer visible.

Why can't I make this work?

[JWiseman · Accepted solution]

Hi carmine1, you can do this via a shared var.

In the main report create a new formula with syntax like:

whileprintingrecords;
shared numbervar imInTheMainReport := 1

and put this in the section of the subreport you're trying to control.

Now in the subreport, go to the sections that you want to leave suppressed when you're in the main report and put in a conditional suppression formula like the following.

whileprintingrecords;
shared numbervar imInTheMainReport = 1

Now when you open the subreport you'll see all of the sections.

[carmine1 · Accepted solution]

This is a great help.. Thanks!