If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hiding sub-report
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 |
#2
|
|||
|
|||
Hiding sub-report
Ross wrote:
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. 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") -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Hiding sub-report
Marshall,
This is absolutely awesome. You can't believe who much work eliminate. Thank you so much. "Marshall Barton" wrote: Ross wrote: 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. 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") -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |