Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: How to do run time addition in crystal report 10 Post Reply Post New Topic
Author Message
muddasirmunir
Newbie
Newbie


Joined: 21 Oct 2007
Location: Pakistan
Online Status: Offline
Posts: 13
Quote muddasirmunir Replybullet Topic: How to do run time addition in crystal report 10
    Posted: 03 Nov 2007 at 10:43pm
i am using crystal report 10 and sql server 2000
there is a field name sale in database now
i just want to add two field in crystal report
one is sale which is stored in databse
second balace which shows the balance by adding
all the previos sale

like

sale========Balance
100========100
200========300
50=========350
10=========360
100========460
and so on

i know how to dislplay the filed even using filter
data but how to calculate balance at run time
is making problem for me
can any body help me is this reg
IP IP Logged
wattsjr
Groupie
Groupie
Avatar

Joined: 25 Jun 2007
Location: United States
Online Status: Offline
Posts: 51
Quote wattsjr Replybullet Posted: 05 Nov 2007 at 11:12am
Hi muddasirmunir,
 
You might try creating type of running total using a formula.
 
Create a formula called BalanceAmt.
 
Use the following in the formula;
 
NumberVar BalanceAmt
BalanceAmt := BalanceAmt + {TableName.sale}
 
Insert the {TableName.sale} field into your detail line and then insert the @BalanceAmt formula next to it.
 
Regards,
-jrw
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.