Addressing subreport groups from a main report

D

Darrell

I have created two subreports on a main report to address the issue of
different groupings in two different sections of a report. Now I have a
followup issue.

How do I now refer to controls on subreports? To be more specific: I give
the user the option to view summary or detail. If they indicate "summary", I
make all the "interior" groupings invisible, and vice versa. And, I also
collect parameters (begin and end date) which the main record source and a
whole group of "totals" queries employ in presenting the final report.

With two subreports on a main report, how do I now address the groupings in
the subreports and universally apply the collected parameter?

Regarding the groupings on the subreport: on the Open Event of the main
report I want to hide or show groupings on the subreports.

I have tried:
Reports!subreportcontainername!groupheadername.visible = true|false
Reports!subreportcontainername!subreportname!groupheadername.visible =
true|false
Reports!subreportname!groupheadername.visible = true|false
Me!subreportcontainername!groupheadername.visible = true|false
Me.subreportcontainername!groupheadername.visible = true|false
Me.Controls("subreportcontainername").visible = true|false
...and several other variations

and none of them work. How do I talk to the subreport!?

I have not gotten as far as universally applying the collected parameter,
since I haven't yet solved the above issue.

Thanks in advance for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top