Click here to Skip to main content
15,305,969 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.

eg:
column1   column2
  bike     20
  car      34
 --------------
 sum       54

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

Dear Friend,

Use the Sum function with (2) arguments:

Sum({NUMBERCOLUMN_FIELD},{FIELD YOU HAVE GROUPED BY}

This link will give you the solution:-

http://www.tek-tips.com/viewthread.cfm?qid=1094731[^]

http://forums.asp.net/t/995281.aspx/1[^]
   
v2
SQL
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!!!
   
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..
   
Create new Running Total Fields
Under the field Explorer
And Filed to summarize
and Type of summary will "SUM"
   
v2
Comments
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
   

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