Variable from subrep not including last row in sum

[les_mills]

Hey all,

 

Originally posted this in the iReport forum but really could be here as well. Writing it in iReport though.

 

My main report contains a sub-report. This will run for each group and is housed in the detail band.

 

Returning from the sub-report is a variable. It has a home in the parent report and its calculation type is set to 'system' and its reset type is 'report'

 

I display this variable in the detail band. I set its evaluation time to 'band' and everything looks good.

 

I then create a new variable which is the sum of the afore mentioned variable. Its calculation type is 'sum' and its reset type is 'report'.

 

Its sums them up perfectly, except the value from the last detail band.

 

It would seem that it is not available until after band has run. If I add it manually to the total when displaying, its fine. But thats cheating

 

Also, how do I get the sub-report to return a zero value if the sub-report runs with no pages.

 

Thanks

P.S. We have been getting some great reports using Ireport and Jasper Server. Fantastic stuff.

[lucianc]

les_mills wrote:

Its sums them up perfectly, except the value from the last detail band.

 

See here.

 

Also, how do I get the sub-report to return a zero value if the sub-report runs with no pages.

 

Set the subreport's variable initialValueExpression to new Integer(0) (or similar).

 

HTH,

Lucian