Force page after 20 records

T

Tia

I have the following report/subreport. They are based on a System
Information query.
Report has the following fields: Customer_Name, Customer_ID,
Customer_Address, Manager

Subreport has the following fields: Customer_ID, Customer_Address, System,
System_Info.

The reports are grouped by 1st, Customer_ID and then by Customer_Address.

This is what prints:
---
(report)
ABC Corp 125 W. 400 S.

Mr. Dan Jones

--------
(Subreport)

HWH Bldg 220
CWS Bldg 440
HWH Bldg 440
Etc. etc.

Some customer_ID and Customer_Addresses have more than 20 Systems (Records).
Since I'm printing this info on a preprinted form, I need to have a new page
when there is more than 20 records on the subreport. Ideally, the remaining
systems will print on the following page with the correct Customer_Info.
I've tried a few things, but I don't end up with my desired result. Either I
get each record on an individual page or the reports just run together and
multiple Customer_ID end up on the same page.

Any insight to how I can force the page after 20 records in my subreport and
have the remaining records on a new report with the correct customer_id,
Customer_address, would be VERY appreciated.

Thank you in advance.
 

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