Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: running total Post Reply Post New Topic
Author Message
tatanka
Newbie
Newbie


Joined: 10 Feb 2010
Location: Greece
Online Status: Offline
Posts: 7
Quote tatanka Replybullet Topic: running total
    Posted: 09 Nov 2010 at 6:53am
Hi everyone. Smile
Can you help me please because i have a problem with my project.

I have fields like date and sales quantity

date                           quantity
06/10/2010               100
10/10/2010               200
15/10/2010               250 
16/10/2010               300

I want to make a formula to calculate the running total for a specific date. For etc. when i give a parameter to bring me the sales quantity from 10/10 to 16/10 my running total  i want to show me the quantity from previus date like 06/10.
Previus Sales is 100 (from 06/10) and the current sales is 750(from 10/10 to 16/10.


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Nov 2010 at 8:04am
depends on your param
but basically just create RTs that uses an evaluate formula.
for the previous sales
table.Date<{?BeginDate}
for current sales
table.date in ?begindate to ?enddate
 
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.