13,140,231 members (48,775 online)
Rate this:
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

Rate this:

## Solution 1

see for group by on net.by using group by u can able to get sum of particular column
kingcoder0110 6-Oct-12 12:13pm

Can you explain it to me please?
Rate this:

## 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!
:)
v2
kingcoder0110 6-Oct-12 12:13pm

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,
:)

Top Experts
Last 24hrsThis month
 Graeme_Grant 546 OriginalGriff 411 CPallini 170 Karthik Bangalore 150 ppolymorphe 133
 Graeme_Grant 4,936 OriginalGriff 4,897 ppolymorphe 1,744 Jochen Arndt 1,567 CPallini 1,440

Web02 | 2.8.170915.1 | Last Updated 6 Oct 2012