Blank Sub Reports - A variation

[JW]

The problem of hiding / showing a sub reports on No Data is often asked, my
problem here is a little different.

My Main report has, as a page header, company details (so each company to a
new page). My detail contains four sub reports (linked as child by
CompanyID to the master) each report may be blank or may have data. If all
subreports are empty my page just has the Company detail in the header and
an otherwise blank page.

The main report is based on the table of companies, the subreports are based
on queries that check for missing data, the only common factor in all child
reports is the CompanyID.

Can anyone tell me how to only have pages where there is a related child
report?

Thank you,

Jon

[Allen Browne]

Use a query as the source for the main report.
In the query, use a subquery or joins to eliminate companies that have no
child records.

For example, include the related tables in the company query, ensuring that
you use outer joins. In the query, add a WHERE clause such as:
NOT (table1.ID Is Null AND table2.ID Is Null AND table3.ID Is Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"JW" <jon_webb@#NOSPAM#yahoo.com> wrote in message
news:bj**********@hercules.btinternet.com...

The problem of hiding / showing a sub reports on No Data is often asked, my problem here is a little different.

My Main report has, as a page header, company details (so each company to a new page). My detail contains four sub reports (linked as child by
CompanyID to the master) each report may be blank or may have data. If all subreports are empty my page just has the Company detail in the header and
an otherwise blank page.

The main report is based on the table of companies, the subreports are based on queries that check for missing data, the only common factor in all child reports is the CompanyID.

Can anyone tell me how to only have pages where there is a related child
report?

Thank you,

Jon