Conditional expressions?

[elmoualh]

Hello every one. I'm new to iReport. I am trying to generate a report that has this structure :

The fields retreived from database :

• P_AMOUNT
• P_CURRENCY

and basicaly, I am asked to sum the values within a criteria, Currency. I have USD, and EUR as currencies, and the AMOUNT is in one of the two currencies I mentioned.

I created 2 variables in my Report called : USD_TOTAL and EUR_TOTAL, but I don't know how can I write an expression for those varaibles tocalculate the 2 sums. Can you please help me?

It's really urgent.

thx in advance

[nibedita]

u can use sql query for sum  in your report query.

[elmoualh]

I have tried but It didn't work, and I tried to use multiple queries but it took only the first one :S

 

[jasperforum]

 just create a variable and set the properties 

for caluculation --sum

and for variable Exp--put the if condition

let me know if it works

 

[elmoualh]

thx for your reply.

I reanalized my SQL Query and managed to simulate the formula in SQL, and I imported the calculated values into my report, and it worked.

Thank you again,

Regards