Click here to Skip to main content
15,948,339 members
Please Sign up or sign in to vote.
3.00/5 (1 vote)
See more:
HI.. how do i calculate sum of a column in crystal report. I have given sum(column) in expression field. so what should be the code given in d aspx page. also i have given sum as footer.

column1   column2
  bike     20
  car      34
 sum       54

I want to display like this in crystal report
Updated 3-Feb-20 17:35pm

Dear Friend,

Use the Sum function with (2) arguments:


This link will give you the solution:-[^][^]
Share this answer
Go to Crystal Report -> Field Explorer -> Runing Total Field -> Right Click -> New -> Give The Name -> Select Field To Summarize From Left Hand Panel(Note :- If you are doing sum of any entity remember that in your database that entity should be in 'INT' Form, Otherwise in Dropdown Menu The Option of sum will not be shown) -> Then Select Type of Summary -> OK -> Again go to Field Explorer -> Expand The Runing Total Field -> u will be shown ur Entity just Drag down on your Crystal Report
wherever you want --> DONE!!!
Share this answer
there are inbuilt functions available in crystal report only to find sum,count ,etc for columns ,just rightclick on your report and goto insert field where you will find lot of available things to use..
Share this answer
Create new Running Total Fields
Under the field Explorer
And Filed to summarize
and Type of summary will "SUM"
Share this answer
tanugarg 5-May-14 6:08am    
these all r not working
In Crystal Report Toolbar, Insert Button Is Present, Clicking That You will get a dropbox where there is an option for Group Total And Sub Total.

you can use that.

Hope That will help you
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