use variable end report value in rec.detail

[pmaslov]

I am running an SQL query in Jasper report and I need to evaluate an expression

 

Foo(field, sum(field))

 

for each record. Problem is that I cannot use SQL to get SUM , I need my Jasper report to calculate it.

 

I made a variable that calculates the SUM. I am able to display the SUM in a Text Filed with Report Evaluation Time.

Now - how do I use SUM in expression evaluated for each record like Foo( field,sum(field)) ?

If it is not possible, then what would be a possible workaround?

 

Thanks!!!!!!

 

Pavel

[lucianc]

By sum(field) do you mean the the sum of the field values for all rows?

 

What is Foo (Java class method, ..)?

 

Regards,

Lucian

[pmaslov]

Yes, sum(field) is a sum of all field values in all rows. My SQL is a stored procedure call, so it seems I cannot just do sum in SQL.

And yes, Foo() is a java method in my Scriptlet.

 

Thank you!

Pavel

[lucianc]

If you want to evaluate Foo(field, sum(field)) to display the result in a text field, you can use the "Auto" evaluation type (available since JR 1.2.0). This is the only feature that allows you to evaluate a expression at several points in time (the field should be evaluated immediately, but the sum needs to be evaluated at the end of the report fill).

 

Otherwise, you'd need to somehow (e.g. separate query) compute the sum before iterating the report rows.

 

HTH,

Lucian

[pmaslov]

"Auto" evaluation time is excactly what I was looking for. You are the best!

 

Thanks again!

 

P.S. here is another post about the "Auto" evaluation:

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=10637&catid=8&limit=6&limitstart=0