Crystal Reports Aged Creditors

Message

   Hi

I am not sure how to show purchase invoice that has 10 instaments as 10 lines (they have different due date so must show them separatly on Age Creditors report).

Please assist:

here is an exctract of PI documents I include in Ageing report:

SELECT     CompnyName, OADM.MainCurncy, 'PI ' AS DocType, DocNum as Doc,DocNum as ID, DocDate, DocDueDate, OCRD.CardCode, OCRD.CardName, DocCur, DocTotal-PaidToDate AS Total, DocTotalFC - PaidFC AS TotalFC, Comments, 
                      JrnlMemo, PayBlock, PayBlckRef, TaxDate,Installmnt, OADM.MainCurncy, NumAtCard, OCRD.QryGroup1, OCRD.CreditLine, OCRD.DebPayAcct 
FROM         OPCH INNER JOIN OCRD ON OPCH.CardCode = OCRD.Cardcode, OADM
WHERE     (CANCELED = 'N') AND (DocStatus = 'O') 

Thank you very much