page breaks-need help

[KSelock]

I have a report that prints details grouped by state and the groups by county and then sorts the county details. I need to have a page break after each counties group of details.
How do I do this?
Thank you

 

[arnelgp]

just suggesting, my approach is in using VBA.

put an unbound textbox (txtHidden) to the detail section of report.
make the textbox's visible property to false.
put a pagebreak control (brkPage) on the detail section of the report.
make its visible property to false.

on your reports load event, assign country code (or whatever unique key) to txtHidden.
on your page header event test if txtHidden = [country code] control.
if txthidden = [country code], set pagebreak control's (brkPage) Visible property to False
on your Detail section Format event, test if txtHidden = [country code].
if not the same, set the Visible property of your pagebreak control (brkPage) to True.
set txtHidden = [country code] control again.

 

[KSelock]

I don't seem to have a "visible" property for the page break control. Suggestions?

 

[plog]

There's a page break element you can add to a report. Add one to the Counties footer section.

 

[KSelock]

ok, I got it to work. Thank you both for your help.