Multiplying fields in ireport

[surf3rb0y]

how do i multiply two fields in ireport.

 

basicly i have fields $F{rate} and $F{hours} and i need to multiply them so i can get a total.

 

Thanks

 

Surf3rb0y

[jsolis]

Try something like this:

 

new Double( $F{rate}.doubleValue() * $F{hours}.doubleValue() )

 

but watch out for nulls.

[surf3rb0y]

Do i have to use a variable or can i just enter it into the field?

[jsolis]

Just enter the expression in the Properties of the Text Field "Textfield Expression" (where you'd normally enter a Field name).

[rohithshetty]

jsolis wrote:

i want to know how to get the field values from xml file to ireport.i need the reply as soon as possible,plz help me

Post edited by: rohithshetty, at: 2007/01/19 06:47

[rafa]

Also you can:

 

1) Create a new field (in the SQL expression) called "total" for example. To make that you must write: SELECT SUM(tablename1.rate} * tablename2.hours) as "total"

 

2) Or you can create a new double variable (SUM calculation type) and in the "variable expression" write $F{rate}.doubleValue() * $F{hours}.doubleValue()

 

See you

 

Rafa