I have small doubt in how can do this Jasper report sum group totals in separate group and report summary

[imransharuk]

 

What I now need is to add totals per payement_currency type as well as totals per payement_currency type overall in the summary e.g.:

 

Acutally came result is:

50 USD 
25 USD
10 USD
30 EUR
20 EUR
50 USD 
25 USD
10 USD
30 EUR
20 EUR

What I now need is to add totals per currency type as well as totals per currency type overall in the summary e.g.:3

Currency: USD 
50 USD 
25 USD
10 USD
USD Total: 85

Currency: EUR
30 EUR
20 EUR
EUR Total: 50

Date: 01/05/2004
Currency: USD 
50 USD 
25 USD
10 USD
USD Total: 85

Currency: EUR
30 EUR
20 EUR
EUR Total: 50

Report Totals:
 USD 170
 EUR 100

    what can i do this kind of report please give me any suggesion and steps in jaspersoft studio.

 

                                           Thanks......

 

 

 

 

 

 

 

 

 

[swood_1]

Group by date then currency. Have variables that sum the value for each grouping and reset at the group level, and variables that sum the grand totals.