Click here to Skip to main content
15,889,266 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
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

1 solution

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'.
 
Share this answer
 
v3

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900