Can we apply database Fuction on ireport veriable...

[singh758]

i have on column in ireport i create one veriable i want to apply one fuction on that is it possible.....??????

 

[mgeise]

I don't know that I completely follow what you are trying to do, but variables are calculated based on Java expressions (or Ruby Groovy, whoops), so if there is something you need to do in the calculation, you would do so with a Java method.

I hope this helps.

[singh758]

thanks for reply .

in my query i already done too much calculation for getting one column.

and in i-report i creating one variable that sum of that column. and i want to apply function on that variable .

so where i write java method for calculation.

 

[mgeise]

If your variable is summing up the fields coming from your query, using a java method in the variable expression for that particular variable would apply the method to each value prior to the summation. Assuming that you actually want the method to apply to the sum, you would create another variable with a variable expression that uses the method on the result of the first variable.