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.
If it's not broken, fix it until it is.
My Blog