Hi,
May be I have provided an unclear sample result. The result expected could be like this depend on data

DoctorCode DoctorName AllowCode AllowanceRate TreatCode PhyRate ClinicRate
A001       JOHN JONES A01       15.00         Srv01     20      80
A001       JOHN JONES A02       10.00 
A002       JOHN SMITH A01       15.00         Srv02     50      50

I think the report designed is not pratical. I will review it again. Thank you