Subreport Data Missing Inside Main Report

[Jody]

Hi,

I have a subreport that has an underlying data source that occasionally
contains no records. I don't have master/child link properties since the
data source is a crosstab query, but the desired recordset appears when there
is one.

I created a VBA function that I use in each field in the subreport, so that
if the control source comes up missing, it returns a zero to show as the
result for the field.

This works when testing the subreport only - all fields show up with zeros,
even though the recordset is empty.

However, when I run the main (parent) report, the subreport comes up empty.

Is there an option/property that I can apply at the main report or subreport
level to force the subreport fields to show in the main report as they do
when running the subreport only?

Appreciate any ideas.

Thanks,
Jody