Displaying sub reports with no data

  • Thread starter Thread starter Brian Hancox
  • Start date Start date
B

Brian Hancox

Hi, I have a report which displays a header, a label and
a text box. Within this report the query builder filters
records. In some cases there is no data returned. When
this report is run, the header is displayed, the label is
displayed and the text box is empty. This is fine, as
there is no data. However, when this report is a sub
report within another report, nothing is displayed at
all, not even the header! Any ideas why? or how to
overcome the problem.
 
If you want to display the header labels even when there is no data in the
subreport, cut the labels and put them on the main report.

Alternatively, you could use a text box on the main report with a Control
Source like this:

=IIf([NameOfSubreportControlHere].[Report].[HasData], Null, "Some text for
when there is no data")
 
Back
Top