Half page report, continue on next page

[dr00bie]

How can I build a report that shows 10 records on the first page, then the rest of the records on the second page?

I have a form that I need to convert over to a report, and it has 10 records, then has some calculations, if there are more than 10 records in the database, then they are continued on the second page.

Thanks,
Drew

 

[Crowley16]

have you tried to put a counter on your report, and then in the onFormat event, testing the counter, and putting in a page break if it's 10?

--------------------
Procrastinate Now!

 

[dr00bie]

That doesn't sound like it would work... The problem is that the bottom half of the report has to be seperate, which includes calculations and room for people to sign off on it.

Hopefully the following will show up,

Page 1

---------------
| |
| |
| 10 records |
| listed |
| up here |
|--------------|
| |
|calculations |
|signature |
|lines |
----------------

Page 2

---------------
| |
| |
| rest of |
| records |
| |
| |
| |
| |
| |
| |
----------------

Thanks,
Drew

 

[dr00bie]

I scrapped this idea.

Thanks,
Drew