Ireport

[rinnap30]

I am using Jaspersoft iRepoort designer 5.6.0

Want to print 'Business Parnter ledger statment' where in querry i have used union  to print data business partner wise , where pagewise business partner

 

Report design as folow:

Business Parnter ledger statment

$F{bpname}

    

Documentno                Debit              Credit    

                                                                     Opening_balalnce:  $F{net} 

102345                          1000                0       

2245435                        70788            1000    

212324                          0                     100
 

data base out put of querry

 

Row no '0' indicate opening balance of both business partner
Row no '1' is for respective business partners transaction recods

i want to print net of  row no 0  business partner wise on every first page of print as Opening bal.

Please suggest.