[Ireport]

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.

 

[Report]

Hi,

Im using Jaspersoft ireport designer version 5.6.0

i want tp print buisness partner ledger, where i have used column opening_bal ,business partner name  and many more..  my querries are

1) display business partner wise  sum of opening balance top of the page which should be  one opening bance for one business partner i.e sum (opening) only on first page of each business partner. i have added this field in customer group header group header 1 band

2) i have added business partner name in page header section which shoud be keep changes  business partner datewise.