HOW to sum column in crystal report

Question

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 20-Feb-12 18:59pm

Nihal Hussain

Updated 3-Feb-20 17:35pm

Anuja Pawar Indore

v2

Add a Solution

5 solutions

Solution 2

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[^]

Posted 20-Feb-12 19:09pm

Varun Sareen

Updated 20-Feb-12 19:10pm

v2

Solution 5

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!!!

Posted 9-Oct-13 20:34pm

Hussain Saify

Solution 3

Create new Running Total Fields
Under the field Explorer
And Filed to summarize
and Type of summary will "SUM"

Posted 20-Feb-12 19:12pm

Sudip Saha

Updated 20-Feb-12 19:38pm

v2

Comments

tanugarg 5-May-14 6:08am

these all r not working

Solution 4

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

Posted 20-Feb-12 19:42pm

Aniket Yadav

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

dimpledevani · Accepted Answer · 2012-02-20T19:09:00

Solution 1

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..

Posted 20-Feb-12 19:09pm

dimpledevani