Crystal Reports - subtotal for group header

Question

I need help with subtotals.

What I have:

A report with 3 groups, the report shows receipts per month. It is showing fine with all relevant details and shows which receipts were done on which dates. The report is showing this:

These fields are in the Receipt# group header and showing what I need however when I add a subtotal it will show for every receipt, basically I want the report to subtotal like this:

I have tried moving these fields to the receipt date group which does not work as it then gives me a subtotal for each date and I don't see all receipts for that date.

It might be something small I am missing but I am stumped.

I hope I am making sense here, if not please let me know and I will try my best to clarify.

Thanks.

Answer 1

Remove the Receipt# group and add date group inplace of receipt.. and place the Receipt# under details group.