Report - when to start a new page

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
 
T

Terry

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
 
N

Newbie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top