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.
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.