C# – SUM of the details in group header Crystal reports

ccrystal-reportscrystal-reports-2008visual studio

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?

Best Answer

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})