user selection of specific sub-reports to include on REPORT

[BBC via AccessMonster.com]

I have a one-off report the user can run to print all the data on the
specific client they are viewing. This currently includes data from 8 child
tables and uses 8 sub-reports below the main (Parent data) report. Each of
these produces its headings (upt to 3 lines) and then any detail records. I
would like to be able to do 2 things with this.

1) stop the headings of any sub report where no detail data is present and
just go and try next sub-report ?

2) allow the user to use checkboxs to select which of the 8 subreports they
would actually like to include if they don't happen to want all. How do I
take the checkbox results from a "selection form" and control the actions of
the sub-reports ?

There is potentially much wasted paper currently, potentially requires about
2 pages even if there is only Parent data.

Thanks
Brian

 

[Duane Hookom]

If a subreport doesn't return any records, it wil not display. You could have
check boxes on your form and use code in the on format event of the section
of the main report containing the subreport like:

Me.sbrptOne.Visible = Forms!frmSelection!chkShowSubOne

 

[BBC via AccessMonster.com]

Looks straight forward, will give it a try.

Much thanks

If a subreport doesn't return any records, it wil not display. You could have
check boxes on your form and use code in the on format event of the section
of the main report containing the subreport like:

Me.sbrptOne.Visible = Forms!frmSelection!chkShowSubOne

I have a one-off report the user can run to print all the data on the
specific client they are viewing. This currently includes data from 8 child

[quoted text clipped - 15 lines]

Thanks
Brian