Hiding sub-report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub report that is placed in the detail section of the main report.
How can I get the sub report to display on some pages of the report and not
on other pages of the report?

For Example:

If ForG = "Financing" Then
rptTax_SBO.Visible = False
Else
rptTax_SBO.Visible = True
End If

Some "deals" in the report are "Financing" deals and some are not. I want
to display both in the same report.

Thank you

Ross
 
Ross said:
I have a sub report that is placed in the detail section of the main report.
How can I get the sub report to display on some pages of the report and not
on other pages of the report?

For Example:

If ForG = "Financing" Then
rptTax_SBO.Visible = False
Else
rptTax_SBO.Visible = True
End If

Some "deals" in the report are "Financing" deals and some are not. I want
to display both in the same report.
Click to expand...


Make sure the detail section's and the subreport control's
CanShrink property are both set to Yes.

Place the code in the detail section's Format event:

Me.rptTax_SBO.Visible = (Me.ForG <> "Financing")
 
Marshall,

This is absolutely awesome. You can't believe who much work eliminate.
Thank you so much.
 
Back
Top