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

  • Thread starter Thread starter Nicola M
  • Start date Start date
N

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
 
Nicola said:
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.
Click to expand...


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 ...")
 
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 ...")
Click to expand...

Thanks.
Nicola M
 
Back
Top