Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: CrystalReports
I have a row like in crystal Report> I have to sum the numbers and set them in total.How can I do this, please help me.
2008 2009 2010 2011 2012 2013 Total
15 16 20 5 34 20 = 110
Posted 11-Jun-13 2:01am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

In crystal report do the following :
1. Open field explorer
2.right click on formula field
3. create new ,give name and click on 'use editor' button
or
right click on that formula field and click edit
4.add reports fields (2008 2009 2010 2011 2012 2013) which you want to get sum with double click on fields shown in upper window. insert '+' between them. resulting as
{source.2008} + {source.2009} + {source.2010} + {source.2011} + {source.2012} + {source.2013}
 
5. save and drag formula field in report.
 
if you have confusion on thease steps then you should first google about 'formula fields in crystal report' and 'adding fields value in crystal report'.
  Permalink  
v3

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

  Print Answers RSS
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 11 Jun 2013
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