create a formula in the subreport that sets a shared variable to the count, since it is just a reference count, something like this should do, in the subreport footer:
shared numbervar aCount:=count({table.field});
in the main report, in the suppression criteria for the section with the subreport something like:
shared numbervar aCount;
aCount =0
A concern is a blank subreport, which might not update the variable, and hence use the last value, which would display incorrectly.
If you are getting the data from a stored proc, you could filter out the records that have no valid values in the subreport before you even get here. You might be able to filter in the Record Selection for the report...I use stored procs, so am more familiar with them.
HTH
Edited by lockwelle - 21 Oct 2009 at 6:33am
IP Logged
