Hide SubReport

[TinaCa]

I know this has been asked at least a dozen times but it's not working for me. I have one report on top of the other. Report A will never have NoData so I set the OnNoData property on Report B to visible = false on NoData. Problem is when Report B does have data I can see Report A behind it.

I've tried setting Report A's visible to false;
on Report B's OnNoData
on the main report on focus and current
on Report A's format

None of it seems to be working. Help

[RuralGuy]

Are you opening two reports at the same time?

[TinaCa]

Nope. Report A is static (coming from a code table its a list of other services the company code provide and cost for those services). Report B is a list of the extra services the company actually used that month. So if they used extra services they don't need to see the cost of services offered i.e. Report A.

Report B is very good about going away when it has NoData. Report A is not cooperative about disappearing when Report B does have data.

my code has been looking something like:
If ReportB.hasdata then
ReportA.visible = false
End if

Not Working on Report or Detail, load, format, activate, Paint,
I've even tried on the subreports on load, format, etc.

I was just thinking, in Crystal I could create two groups and put each report in one. I don't see a way to do that in Access....do you know of any?

[rpeare]

you could do something like this in the ON OPEN property of the report

if dcount("*", "QueryDrivingReportB") = 0 then
    reporta.visible = true
else
    reporta.visible = false
endif

Where you're counting the number of records that are in the collection report b, and if there are 0 records report a is visible otherwise it's not.

You could likely do the same thing by checking the visible property of reportb and if it's visible making reporta invisible.

[TinaCa]

I tried the visible thing but no matter where i put it - Rerport A ignored the request to disappear .

I'll try to dcount. Should I put this in on the on open of the main report or report a - I'll try both.

[TinaCa]

LOL I copied an old copy of the report back to the current database....and the dumb form is working. I hate that - I thought this was working before. Here is the code that finally made Report A disappear. It is in the format event of the detail section.


Me.rptInvoiceExtrasSub.Visible = Me.rptInvoiceExtrasSub.Report.HasData
If Me.rptInvoiceExtrasSub.Visible = True Then
Me.rptInvExtrasSub.Visible = False
Else
Me.rptInvExtrasSub.Visible = True
End If

[RuralGuy]

Excellent! Thanks for posting back with your success and solution.