Blank Page with subreport

[Shaft]

HI All,

I've designed a report, which is basically a main report Which there is always data for then a page break then a subreport, so each subreport is on a new page. Which works fine when there's data for the subreport, but when there is no data it prints a blank page.

How can I fix this problem?

 

[Hayley Baxter]

You can create a macro to force a page break if a condition is met or alternatively you can do this using VBA. You'll need to firstly select the page break control on the toolbox and position this where you would like the page break to appear.

If using a macro you'll need 2 macros, one that sets the page break's visible property to false and another that sets this to true if a condition is met.

If using VBA set it to false:

me.pagebrkname.visible = false

then set it to true if condition met:

if me! [condition] then
me![pagebrkname].visible = true
End if

Hay