subreport in report footer has no data, showing blank page at the end of the report

[FA]

Hi,
I have a subreport in my reportfooter. if the subreport do not have any
data, it shows me the blank page at the end of the main report. do i
need any vba code in my report footer not show the report footer if the
subreport has no data, if so can i get some example please.

any help would be greatly appreciated.

thanks
moe

 

[Marshall Barton]

I have a subreport in my reportfooter. if the subreport do not have any
data, it shows me the blank page at the end of the main report. do i
need any vba code in my report footer not show the report footer if the
subreport has no data, if so can i get some example please.

You should be able to get t what you want by just setting
both the subreport control's and the report footer's Can
Shring property to Yes.