Suppressing a Subreport

  • Thread starter Thread starter gemini2
  • Start date Start date
G

gemini2

Is there any way to suppress a subreport in a report when there are n
records? I have report that is a combination of several subreports
The first page of the report is a summary of each of the detai
reports. The subreport are the detail report which each hav
different source data. The problem come when there are no records fo
a particular subreport. I end up with a blank page with just th
report title in the middle of the report. I try putting a text box i
the footer of each report so that when the record count = 0 it woul
display "No Records" else” ". This didn't work either. Is there an
way I can just suppress the page
 
gemini2 said:
Is there any way to suppress a subreport in a report when there are no
records? I have report that is a combination of several subreports.
The first page of the report is a summary of each of the detail
reports. The subreport are the detail report which each have
different source data. The problem come when there are no records for
a particular subreport. I end up with a blank page with just the
report title in the middle of the report. I try putting a text box in
the footer of each report so that when the record count = 0 it would
display "No Records" else” ". This didn't work either. Is there any
way I can just suppress the page?
Click to expand...


Make sure the subreport control and it's section have their
CanShrink property set to Yes.

Look up then Has data property in Help if you need to
display something in the main report when the subreport is
empty. E.g. you could have a text box with an expression
like:

=IIf(subreportcontrol.Report.HasData, Null, "No Records")
 
Back
Top