Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Calculating Post Reply Post New Topic
Author Message
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Topic: Calculating
    Posted: 10 Oct 2011 at 10:19pm
Dear All,
I Have A problem on creating a running total report. Let me describe my report that I want to make :

Nu       item                      order         Delivered     Outstanding    Status
1        001                        2                    2                   0                 Complete
2        003                        5                    3                   2                 not complete
3        003                        5                    2                   0                 Complete

My Problems are :
1. What should I do to make the outstanding field? it's a running down process
2. If the outstanding were come from a process could we make another formula to make the status field..

Hope anyone can help...

Thanks a lot,


Joe
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Oct 2011 at 4:32am
one way is to make two Running Totals (rt)
rt1
RT name=OrderRT
field to sumamrize=tableorders
type=sum
evaluate=on change of field  - use table.item
reset=on change of field  - use table.item
 
rt2
name=DeliveredRt
field to sumamrize=table.Delivered
type=sum
evaluate=for each record
reset=on change of field  - use table.item
 
for your 'Outstanding' make a formula as
{#OrderRT}-{#DeliveredRt}
for your status make a formula as
if {#OrderRT}-{#DeliveredRt}=0 then then 'Complete' else 'Not Complete'
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.