Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to print a report with subreports on multiple pages?

Status
Not open for further replies.

ZPlay

Technical User
Jan 10, 2002
24
US
I am trying to create a form report that will print the each record from the PROP table on each page. Also on each page there is a subreport of records from the CUST table for each property. I can only print 3 customers to a page. If a property has more than 3 customers how can i continue to print them on another page in the same exact format?
Here is an example of how the data might be seperated on the report:

Page One
Property 1
P1 Customer 1
P1 Customer 2
P1 Customer 3
Page Two
Property 1
P1 Customer 4
P1 Customer 5
Page Three
Property 2
P2 Customer 1
P2 Customer 2
P2 Customer 3
ect .....

I hope my problem defination is clear enough to be understood. Thanks. Dan

 
Never mind I figured it out using VB.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top