How To hide a subreport?

[DanielM]

How To hide a subreport?
I found how to know if the subreport has no data
(Me.subreportname.Report.HasData)
what I didn't find is how to make the sub report unvisibile if it has no data.
I tried:
If Not Me.subreportname.Report.HasData then
Me.subreportname.Report.Visible = False
End If
but it gave me an error

[lee123]

hi there you could use this

if subreportname then
   subreportname.visible = true
else
  subreportname.visible = false
end if

lee123

[MMcCarthy]

The first time you refer to the subreport you are referring to the report itself so you need the .Report

However, the second time you are referring to the subreport object so you don't use .Report

You also have to allow for the true event.

If  Me.subreportname.Report.HasData then
    Me.subreportname.Visible = True
Else
    Me.subreportname.Visible = False
End If
 

[DanielM]

Thanks for your attention, the code was OK,
but still I have a problem, since my target was to save the space that the balnk subreport takes' and although the sub report was unvisible' still the page was with large blank space, in the palce that the subreports was supposed to sit.
Do you have any idea how to save the blank space?
Thanks.

[FishVal]

Thanks for your attention, the code was OK,
but still I have a problem, since my target was to save the space that the balnk subreport takes' and although the sub report was unvisible' still the page was with large blank space, in the palce that the subreports was supposed to sit.
Do you have any idea how to save the blank space?
Thanks.

Hi, Daniel.

Try the following.

• Set subreport control .CanGrow = Yes
• Reduce subreport control height to possible minimum
• Handle subreport.Report "On No Data" event
  

  Private Sub Report_NoData(Cancel As Integer)
      Cancel = True
  End Sub
   

[DanielM]

Thanks a lot, but didn't work.
As much as I understood from searching google, the
"ON NO DATA" event, does not fire in the subreport.

[FishVal]

Thanks a lot, but didn't work.
As much as I understood from searching google, the
"ON NO DATA" event, does not fire in the subreport.

LOL. It is really so.

But it works without handling event.
At least in my test:
Several bound textboxes
Unbound label
Unbound checkbox

Did you shrink an empty report area having reduced subreport control height?

[DanielM]

Hi,
what did you mean "But it works without handling event." ?

[FishVal]

Hi,
what did you mean "But it works without handling event." ?

Screenshot in attachment.

[barry07]

Daniel is correct that you don't need an event to hide the subreport. Just make the height of the subreport zero in design view and set CanGrow=Yes and CanShrink=Yes in the properties of the sub report.

However, you must also set CanGrow=Yes and CanShrink=Yes for the Report section which contains the subreport (|Detail, Report Footer or whatever)

[DanielM]

Thanks you all for your attention and time, It worked.

[FishVal]

You are welcome.

Kind regards,

Fish