page breaks-need help (1 Viewer)

KSelock

New member
Local time
Yesterday, 20:56
Joined
Aug 15, 2017
Messages
4
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

..forever waiting... waiting for jellybean!
Local time
Today, 09:56
Joined
May 7, 2009
Messages
19,242
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

New member
Local time
Yesterday, 20:56
Joined
Aug 15, 2017
Messages
4
I don't seem to have a "visible" property for the page break control. Suggestions?
 

plog

Banishment Pending
Local time
Yesterday, 20:56
Joined
May 11, 2011
Messages
11,646
There's a page break element you can add to a report. Add one to the Counties footer section.
 

KSelock

New member
Local time
Yesterday, 20:56
Joined
Aug 15, 2017
Messages
4
ok, I got it to work. Thank you both for your help.
 

Users who are viewing this thread

Top Bottom