I have detail lines that all return the same currency value field but other fields on the lines are different therefor I must print up the detail lines.   I want 1 incidence of the value and so I have moved that value field off the detail line and I have pulled into into the group header - this gives me the display I need where I see my currency value field once per group.   I now need a total of those group headers in the grand total of the report.

 

I have tried a sub-report amongst other things but I always end up with a grand total of all the detail lines instead of just the 1 incidence of the amount held in the group header.

 

Can this be done please?   Can someone offer me any suggestions please?

That would be greatly appreciated.