>>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.
>
>
>This long forgotten thread may help - message#689451

Thanks, the idea of the separate summary cursor worked well.