Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to summarize Post Reply Post New Topic
Author Message
adekie
Newbie
Newbie
Avatar

Joined: 06 Jul 2009
Location: Indonesia
Online Status: Offline
Posts: 6
Quote adekie Replybullet Topic: how to summarize
    Posted: 06 Jul 2009 at 9:46pm
hi there

i try to a transaction report and i don't know how to create the beginning balance, the data example was like this

date     sales     payment     balance     note
1/1                                       10000        Beginning Balance
2/1       1000                         11000     
3/1       1500                        12500      
5/1        500                          13000       <--beg balance at 10/1 date
10/1                   500             12500
15/1                   500             12000
20/1      2000                        14000

when i select the date from 10/1 the beginning balance will be 13000

how to do that in crystal report???ConfusedConfusedConfused
Confused
thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 07 Jul 2009 at 6:38am

if sales <> 0 and payments<> 0 then look at the previous records balance to get the 'beginning balance'

If you selected the data via a stored proc, you could calculate it and give yourself a field.
 
Crystal has a function for Previous.  I don't use it too often, so check Help and see if it makes sense...I think that it will.
 
HTH
IP IP Logged
adekie
Newbie
Newbie
Avatar

Joined: 06 Jul 2009
Location: Indonesia
Online Status: Offline
Posts: 6
Quote adekie Replybullet Posted: 09 Jul 2009 at 3:49am
i'll try it, thanks
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.