Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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: bad
good
Please Sign up or sign in to vote.

Solution 1

see for group by on net.by using group by u can able to get sum of particular column
  Permalink  
Comments
kingcoder0110 at 6-Oct-12 12:13pm
   
Can you explain it to me please?
Rate this: bad
good
Please Sign up or sign in to vote.

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!
Smile | :)
  Permalink  
v2
Comments
kingcoder0110 at 6-Oct-12 12:13pm
   
Would you please explain it to me? I didnt understand your answer properly.
aarti meswania at 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 at 6-Oct-12 13:59pm
   
Thanks a lot. It works.
aarti meswania at 6-Oct-12 15:32pm
   
welcome,
glad to help you!
:)

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 330
1 BillWoodruff 314
2 George Jonsson 274
3 CPallini 265
4 OriginalGriff 257
0 OriginalGriff 5,030
1 CPallini 4,115
2 Sergey Alexandrovich Kryukov 3,554
3 George Jonsson 2,826
4 Gihan Liyanage 2,386


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100