Hi everybody,

I have a complex report. This report has tot_ext and tot_pay fields in the Group Header expression and it has init_price and Quantity in the Detail band.

I want to add a Grand Total for the report. However, when I place tot_ext and tot_pay fields in the Summary band and set them to calculate sum for the report, my results are incorrect. I need to somehow only calculate the values once for each group to come up with the correct sum values.

Do you have a suggestion of how to achieve the correct result?

Thanks in advance.