Conditional Page Breaks

[Kerry Purdy]

Hi

I have a report which works as a letter to an individual inviting them to
training. I have a page break at the end of the standard text. Our company
name and contact details sit in a text box in the page footer and a map to
our training location in the report footer.

There is a Report Activate event with a condition that shows the map in the
report footer if the training location is our address, otherwise do not show
the image.

The problem I have is that if the image is not shown I still see a blank
page as the page break is still kicking in. Where do I put the page break
and how do I add it to the condition to use it or not?

Many thanks

Kerry

 

[fredg]

Hi

I have a report which works as a letter to an individual inviting them to
training. I have a page break at the end of the standard text. Our company
name and contact details sit in a text box in the page footer and a map to
our training location in the report footer.

There is a Report Activate event with a condition that shows the map in the
report footer if the training location is our address, otherwise do not show
the image.

The problem I have is that if the image is not shown I still see a blank
page as the page break is still kicking in. Where do I put the page break
and how do I add it to the condition to use it or not?

Many thanks

Kerry

1) The Report Activate event ONLY fires when the report is previewed.
When printed, any code in the Activate event will not be run.

2) Depending upon what the actual criteria is, you can code the Format
event of the relevant section:
Me!PageBreakName.Visible = [SomeControl] = Condition

or

Me!PageBreakName.Visible = Not [SomeControl] = Condition