suppress print of report when subreports empty

J

jenny j

i have a main report in Access 2007 that is bound to a query and has four
subreports in it's detail section.

by design, there is a high likelihood that most, if not all of the
subreports will be empty. i would like to prevent the main report from
printing if all of the subreports are empty. i would prefer not to put the
text from the main report into the report header of the subreport because i
don't want the person's name and the report period to be repeated 4 times if
each of the subreports do contain data.

is there any way that this can be done?!

thanks!
 
Top