SUM of the details in group header Crystal reports

Question

I am generating the crystal report in the ASP.NET/C# Website. I require the groupwise sum in the header of the group, When I add the SUM field (Running Total Field) shows the first entry of the records is there any way to show the total of all records in details in the header of the same group?

Solution

Running Totals won't work in a Group Header section because of the way they are evaluated. Instead, you could just use a regular summary function and place it in the Group Header. You can do this by either right-clicking the field to summarize, selecting "Insert", and then "Summary" or by creating a formula:

sum({table.field_to_summarize},{table.field_you_are_grouping_on})

Comments

[Rohit Chaudhari]

could you suggest any link for the example, I have not tried the subreport yet....

[Haresh Kumar]

Worked for me. Thanks