Subreport Page Break

ben.hornshaw

Registered User.
Local time
Today, 05:36
Joined
May 30, 2009
Messages
21
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
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom