Report - when to start a new page

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi ,

I have the following groupings
Cellid
SystemId
ResID

I want to have a new page for each new SystemId with all the information
following on the same page

How can I achieve this? I have tried lots of combinations but each one gives
either a blank page to begin with or doesn't give me a new page where I want
it

Here is what I am trying to achieve - any ideas?

Page 1
Cellid 1
SystemID 1
Resid A
detail records
Resid B
detail records

Page 2
Cellid 1
SystemID 2
Resid C
detail records

Page 3
Cellid 2
SystemID 3
Resid D
detail records etc
 
Newbie,

Include a SytemId footer in your grouping.
Drop a page break into the group footer (the footer can be
dragged to almost zero height. This will give you a blank
page at the end of your report or (if you have them) put
the cellid and report footer information onto a seperate
page. You could test for a dlast and make the page break
invisible (effectively disabling it) when you are at the
last SystemId record. This should be done in the systemid
footer section's "on format" event.


HTH,

Terry
 
Terry,
Thanks works great - I also set the the Repeat Section to Yes on the Cellid
and this gives me exactly what I want without a blank page at the end

Thanks again

Al
 
Back
Top