Crystal Reports Creating hierarchical groups at same level

Message

   Hi

Run a union query on Creditors and Debtors table 

select InvoiceId,C_Person from 

dbo.Creditor

union
select InvoiceId,D_Person from

dbo.Debtor

order by 2

Invoice ID  C_Person
A111         CP111
B222         CP222
C333         CP333
A111         DP111
B222         DP222
C333         DP333

This will give you output as required you need to display just the second column as invoice id will be used to link the subreport as per your post.

hope that helps

Cheers
Rahul