Customer ALFKI details (Band 1) Sales Representative who made sale to this customer details1 (Band 2) Sales Representative who made sale to this customer details2 (Band 2) Sales Representative who made sale to this customer details3 (Band 2) Order details of this customer1 (Band 3) Order details of this customer2 (Band 3) Order details of this customer3 (Band 3) Order details of this customer4 (Band 3) Customer ANATR details (Band 1) Sales Representative who made sale to this customer details1 (Band 2) Sales Representative who made sale to this customer details2 (Band 2) Order details of this customer1 (Band 3) Order details of this customer2 (Band 3) ...Then you could create a cursor that'd have as many records to print it and control what's printed using 'print when' per record. ie:
Use customer In 0 Order Tag cust_id Use employee In 0 Order Tag emp_id Use orders In 0 Order Tag order_id Select 1 As BandNo, cust_id, ; Space(6) As emp_id, Space(6) As order_id ; from customer ; union ; Select 2 As BandNo, cust_id, ; emp_id, Space(6) As order_id ; from orders ; union ; Select 3 As BandNo, cust_id, ; Space(6) As emp_id, order_id ; from orders ; order By 2, 1 ; into Cursor crsRep ; nofilter Set Relation To ; cust_id Into customer, ; emp_id Into employee, ; order_id Into ordersYour report might have all the info in the same detail band where Customer fields have a print when as 'BandNo=1', employee 'BandNo=2' and so on.