Remove the sub-report page if it has no data on a report

S

Sheikh Adeel

I have created a report having two sub-reports in it, to view sub-reports in
seperate page I use page break after sub-report, and in the sub-report's NO
DATA property I code it Me.Report.Visible = False., but when I view this
sub-report in report it shows blank page where the report has no data, I want
to know how to remove the page from the report if the sub report has no data.
 
T

Tom Wickerath

To suppress a subreport that has no data, set the Can Shrink property to Yes.
You might also want to set the Border Style property to transparent. These
are properties of the control on the main report that holds the subreport
(not the subreport itself). You should not need to use VBA code to achieve
this (ie. Me.Report.Visible = False in the NoData event procedure).

Tom
________________________________________


:

I have created a report having two sub-reports in it, to view sub-reports in
seperate page I use page break after sub-report, and in the sub-report's NO
DATA property I code it Me.Report.Visible = False., but when I view this
sub-report in report it shows blank page where the report has no data, I want
to know how to remove the page from the report if the sub report has no data.
 
Top