Single recording in several groups

Question

I am relatively new to Crystal reports and have a weird problem. I work in the field of optometry, and we have situations in which a $ 44 exam can have $ 34 billed by one insurance company and $ 10 billed by another company. I need to summarize the balances due to the insurance company, so I need one entry to appear in two different groups. Group for insurance company A and for insurance company B. How to do this in Crystal Reports? Many thanks for your help!

Additional information: this is the only record containing the following fields:

Ledger.Amount ____ Insured1.Amount ____ Insured1.Name ____ ____ Insured2.Amount Insured2.Name

So Ledger.Amount = Insured1.Amount + Insured2.Amount

If both insured fields have a balance, I want the entry to be in the groups Insured1.Name and Insured2.Name.

Answer 1

You will need to create a sub-report for each value that you want to split.