Click here to Skip to main content
14,970,515 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Everyone,

I am using crystal report.
In that i have taken sum of some filled (@tot).

And also i want to take sum of the @tot, when i want to take sum of the @tot as like Sum({@tot}) it gives error.

Tot i used this formula
{VendarMaster.kapat}*Sum ({SankalanBufMaster.bufmilk}, {SankalanBufMaster.venno})


Here is the format of my report,

Name AVG TOt
ZYX 100 100

ABC 150 150

Total 150


But here i want the total=250

How to calculate sum of @Tot?

Thank You,
Posted
Updated 2-Feb-14 19:50pm
v2

   
Create a formula like this.and place it in group header

Shared numbervar tot;
Shared numbervar grandtot;
Shared numberVar ftot;
tot :={ VendarMaster.kapat}*Sum ({SankalanBufMaster.bufmilk}, {SankalanBufMaster.venno});
grandtot :=grandtot + tot;
ftot:=grandtot-tot;
ftot ;
   
Comments
sumit WanZa 16-Feb-14 0:35am
   
SIR GOT ERROR IN
THE FIELD NAME IS NOT KHNOW
sumit WanZa 16-Feb-14 0:36am
   
I HAVE ONLY ONE FIELD
FIELD NAME id amount
i want to total only amount filed
and my table name is 'vadhavo' and field name is 'amount'
basurajkumbhar 21-Feb-14 8:11am
   
Hi Sumit,

You have filed name id amount and you want the sum of the id amount ok..
go to your report right click on report and Insert then Summary and choose the filed which the you want the sum like "id amount"

I hope this will help you....

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