Empty query for subreport

N

nathaniel_welch

I have a report that combines several subreports. My problem is that
not every query that populates the subreports produces a record (some
are empty queries). What I would like to do is put a placeholder (i.e,
"No data") where the subreport would have been on the master report, if
the subreport contains no data.

Does anyone have any suggestions??

Thanks,
Nate
 
F

Frank Stepanski

Hi,

Yes, in the report detail section, put code to check if the recordset of
that subreport is null or not (IsNull). If it is, you can display a hidden
label or text that says "No Data"

Frank Stepanski
 
R

Rick Bennetts

Frank,

I've spent a couple of hours trying to do as you suggested - without
success. Could you provide an example for me to follow, or point me to where
I could find one?
 
Top