Menu
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?
498
Make a summary field: Right-click on the desired formula field in your detail section and choose "Insert Summary". Choose "sum" from the drop-down box and verify that the correct account grouping is selected, then click OK. You will then have a simple sum field in your group footer section.
Right click on the Group Header or Group Footer of the desired group. Select Change Group. On the Options tab, mark the Keep Group Together box. Click OK.
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})
70
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
