SUM of the details in group header Crystal reports

Description:

In this example we explain that how to display total in group header in crystal report running. Or how to display sum of the details in group header in crystal report in asp.net. or display running total in group header of crystal report in asp.net. or how to sum of the details in group header in crystal report. Display group footer value in group header in crystal report. Or running total in group header in crystal report.

As per the report running total won’t work in group header section because of the way they are evaluated.so to display detail of the sum or the summary in group header use the below formula.

Create a new formula field in your report and put the below line in it and put this formula filed in your group header of the crystal report in which you want to display the detail sum or running total in group header.

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

here “table.field_to_summarize” indicate that in which field you want the total like for e.g.: Orders.Value

and “table.field_you_are_grouping_on” indicate that in which you want to group by like for e.g.: Orders.OrderNumber

Code:

sum({Orders.Value},{Orders.OrderNumber})