Sum from inner group footer variable

[rob.mccarthy]

My report is arranged into two groups, item and location, with location being the inner most group.

Item Header

Location 1

Location 2

Location 3

Item Footer.

In the location footers I display a total which is calculated on the record details, but is not just a running sum. In the item footer I need to display a sum of  that variable from each location footer. I tried creating a SUM on the variable needed, with reset on Item and when I place this variable in the Item footer I have the evaluation time set to location. It doesn't give me the right sum. How can I tell the report to sum just the final value in each location footer. I have tried other evaluation times for the variable, giving different results, but none correct.

Any help would be appreciated. It seems like it should be so simple but I've been scratching my head over this one for a while.

Thanks,

Rob

 

[rob.mccarthy]

I figured out a solution. Using iReport i set the item foooter sum variable INCREMENT  type to group, and the group to item.

[srkr]

Thanks Rob.. that helped me ..thats really great you posted the answer when it worked for you.