Sub Report

  • Thread starter Thread starter Abe Katz
  • Start date Start date
A

Abe Katz

Hello,
I want to display something on the main Report if there is no details in the
sub report.
How can I check, when the report opens if there is no detail in the sub
report.
I tried to put a sum field in the sub and check if > zero, but it doesn't
always work when there is multiple records to print.
Thanks
Abe
 
Try a text box with Control Source like this:

=IIf([Report].[HasData], Null, "Oops: nuffin 2 C.")
 
Back
Top