How to get grand total of totals in Crystal report?

Question

0.00/5 (No votes)

See more:

Hi! I dont know how to make grand total of totals in Crystal report. Please help me to know more about it. Let me make it clear to you.

Column 1 ...... Column 2 ....... Column 3
1 ...........................1 .............................1
2 ...........................2 .............................2
3 ...........................3 .............................3
4 ...........................4 .............................4
5 ...........................5 .............................5
---------------------------------------
15........................ 15.......................... 15

So we get totals of three columns. But I want to make a grand total of those totals. Like Grand total = (Total of Column 1 + Total of Column 2 + Total of Column 3) 15 + 15 + 15 = 45.

Would you please tell me how can I do it & how can I solve this problem?

Posted 6-Oct-12 0:48am

kingcoder0110

Add a Solution

2 solutions

Solution 1

see for group by on net.by using group by u can able to get sum of particular column

Posted 6-Oct-12 0:57am

Vijay Walunj,Navi mumbai

Comments

kingcoder0110 6-Oct-12 12:13pm

Can you explain it to me please?

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)

Aarti Meswania · Accepted Answer · 2012-10-06T05:06:00

Solution 2

create formula field
from field list
drag drop summary fields of columns1,2,3 and merge using plus operator...

drag drop this field in report.
Happy Coding!
:)

Posted 6-Oct-12 5:06am

Aarti Meswania

Updated 6-Oct-12 5:10am

v2

Comments

kingcoder0110 6-Oct-12 12:13pm

Would you please explain it to me? I didnt understand your answer properly.

Aarti Meswania 6-Oct-12 12:53pm

have you use summary field for column1's total and same as both col2 & col3?

to create new formula see left hand side below report fields there is option formula field right click it -> create new formula -> name it -> click use editor button -> now you are in formula field window

looks like http://www.codeproject.com/Articles/237030/Using-Formula-in-Crystal-Report Figure no. 8
that summary field will be in selection list of report-Fields in FormulaField Editor window.

drag drop and put plus sign between them.

kingcoder0110 6-Oct-12 13:59pm

Thanks a lot. It works.

Aarti Meswania 6-Oct-12 15:32pm

welcome,
glad to help you!
:)