How to calculate sum of columns and rows values

Question

0.00/5 (No votes)

See more:

Hi...

can u help me.
how to calculate sum of columns and rows value in crystal reports using asp.net.

means like blow:
id name marks
01 xxx 65
02 yyy 85
total: 150

pls give me solution to it.
thank u.

Posted 13-May-13 21:50pm

Murali0195

Updated 14-May-13 19:18pm

v3

Add a Solution

Comments

[no name] 14-May-13 4:44am

I have tried like.. insert > summary > calculate this summary only have min,max,count...etc.
not having sum or avg.
how can i get it.

3 solutions

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)

kumar2413 · Accepted Answer · 2013-05-13T21:53:00

Solution 1

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-summary-field.htm[^]

have a look in this site will help you

Posted 13-May-13 21:53pm

kumar2413

Vani Kulkarni · Accepted Answer · 2013-05-13T21:58:00

Solution 2

Did you try Google[^]?
It returned around 362,000 results (0.23 seconds) for your query, top links being:
HOW to sum column in crystal report[^]
formula-to-sum-amount-column-in-crystal-report[^]
Sum of columns in crystal report[^]
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-summary-field.htm[^]

Posted 13-May-13 21:58pm

Vani Kulkarni

Comments

[no name] 14-May-13 5:26am

thank u very much.

[no name] 14-May-13 5:53am

If u dnot mine can u tel me. in row wise also pls

Murali0195 · Accepted Answer · 2013-05-14T21:39:00

Hi...

My table is having like this.

Orderid Productname Productcost Quantity Totalprice
01 xxx 499 2 998
02 yyy 749 3 2247
03 zzz 999 1 999

Sub total: 4244

in this, 1st find totalprice mean (productcost*quantity) from formula fields > new > formulaname > productcost*quantity. this formulaname used in section3(detailes) instead of price(for columns wise).
then for subtotal, insert > summary > select ur formulaname, set calculate summary as sum > ok(for row wise)

in this way am find the solution to it.
thank u.