Click here to Skip to main content
15,943,148 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:

How do I calculate sum of a column in crystal report ?

[No]  [Name]      [value]
 1      a           2
 1      a           3
 1      a           5
 1      a           4
 2      b           1
 2      b           2
 3      c           10

I want to display like this.
[No]   [Name]        [Value]
 1       a             14
 2       b             3
 3       c             10

Thanks in advance.

You need to create grouping sections. You can then add a formula field that sums the values per group. Drag that formula field on the form in the group footer section.
Share this answer
You can simply use save the data as int data type and after getting the on the Crystal Report you can use Sum Field of the Crystal report.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900