If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Force page after 20 records
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. |
Thread Tools | |
Display Modes | |
|
|