Crystal reports sum first record in group

example:
fieldA fieldB
2 30 group1
2 10
5 12 group2
5 14
5 9 group3
8 1
8 9

the values of fieldA in a group are the same.
what i want is to calculate fieldA of each group only once: 2+5+8
how can i do this and display the sum at the report header?

subreport, and in the subreport you will need to use a formula to sum the field A values. I would probably make a group in the subreport so that you can place the formula there.

Crystal has to read the records first, so the only way to get something like this in the report header is to have a subreport to force Crystal to read the data. This will imply that your data will be read twice. Once for the subreport and once for the rest of the report.

If you were getting your data from a stored proc, you could modify the stored proc to only report the value once per group then you could just do a sum of the field, which Crystal will perform in the report header.

liked the "running total field" in the report header, field A values only summarized once in the sub report.

This page was generated in 0.047 seconds.