Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: How to find sum Post Reply Post New Topic
Author Message
RoniDxb
Newbie
Newbie
Avatar

Joined: 02 Sep 2008
Location: United Arab Emirates
Online Status: Offline
Posts: 6
Quote RoniDxb Replybullet Topic: How to find sum
    Posted: 02 Sep 2008 at 12:33pm
AccountNo   Date Amount
1 1/25/2008 500
1 1/26/2008 500
1 1/27/2008 500
1 1/27/2008 500
1 1/28/2008 500
I have a table named Table1 that has following structure.
I take three parameters from users as Starting Date , Ending Date and Account No
for example if user give the follwing parameters
Account No =  1
Starting Date  = 1/27/2008
Ending Date    = 1/28/2008
 
result of Report
AccountNo  Date Amount
1 1/27/2008 500
1 1/27/2008 500
1 1/28/2008 500
 
Total Amount =  1500
 
Now the problem is i want to show the last previous Sum of this account too
for example in this case previous Balance will be
 
Previous Balance =  1000
 
plz guide me how can i take out prevous balance
 
 


Edited by RoniDxb - 02 Sep 2008 at 12:43pm
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 15 Oct 2008 at 11:57am
Store the previous total as a variable in a formula and display it.  After the display, then update it to the current total.  Can probably use the SUM function to determine the current value.
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.047 seconds.