If no records in a subreport show a string. How to?

[Nicola M]

Hi all! Access 2003

I have a report with 3 sections (subreports). All works properly.
I'd like to fix an only unpleasant particular i.e if any record is returned
by the subreport I'd like to show an information string. Now I have the label
of the subreport followed by nothing. This things could lead to a
misunderstanding because an user could think that's an error.
I guess I have to use some "domain aggregation function" but anything works
so far.

Thank you in advance for any suggestions and tips.
Nicola M

 

[Marshall Barton]

Hi all! Access 2003

I have a report with 3 sections (subreports). All works properly.
I'd like to fix an only unpleasant particular i.e if any record is returned
by the subreport I'd like to show an information string. Now I have the label
of the subreport followed by nothing. This things could lead to a
misunderstanding because an user could think that's an error.
I guess I have to use some "domain aggregation function" but anything works
so far.

Add a transparent text box (on top of the subreport?) to the
main report and set its expression to something like:

=IIf(subreportcontrol.Report.HasData, Null, "No data ...")

 

[Nicola M]

Marshall Barton ha scritto:

Add a transparent text box (on top of the subreport?) to the
main report and set its expression to something like:

=IIf(subreportcontrol.Report.HasData, Null, "No data ...")

Thanks.
Nicola M