Subreport Page Break

[ben.hornshaw]

Hi all

i have a report with multiple subreports. after each subreport there is a page break as i want each location, each subreport to start printing on a new page.

when a location/subreport contains no data of course the report prints a blank page as the page break still acts, how do i stop this??
I have heard about a on no data event but dont know much about it. can i use this to hide the page break

thanks

 

[ben.hornshaw]

i have just tried putting

me.pagebreak1.visible = false

in the on no data event of the first subreport but it still displays a blank page

 

[ben.hornshaw]

ok and to make things more confusing i just added the line

msgbox("nodata1")

into the on no data event of all three subreports and not one fired! even though the subreport doesnt show any records and when i run the queries there made from then return no records!

any ideas