Report development issue

here is the output of the report, the payment is used to settle 4 invoices, but the record is also 4 times, however the other invoice is used to settle one invoice hence it is getting printed once, how to avoid this?

in fetch method i have written the following code

public boolean fetch()

{

    boolean         ret;

    QueryRun        qrun;

    vendtrans       vendtrans_2, vendtrans_3;

    int64           payment_recid, invoice_recid;

    VendSettlement  vendsettlement_2;

    ;

    ret = true;

    qrun = new QueryRun(element);

    If(!qrun.prompt())

    {

        return false;

    }

    while(qrun.next())

    {

        vendtrans_2 = qrun.get(tablenum(vendtrans));

        if(!vendtrans_2)

        {

            return false;

        }

        if(vendtrans_2)

        {

            element.send(vendtrans_2);

            while select * from vendsettlement_2 where vendsettlement_2.TransRecId == vendtrans_2.RecId

            {

                select * from vendtrans_3 where vendtrans_3.RecId == vendsettlement_2.OffsetRecid;

                element.send(vendtrans_3);

            }

        }

    }

    return ret;

}