Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Count within PO Post Reply Post New Topic
Author Message
jdonbavand
Newbie
Newbie
Avatar

Joined: 26 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 12
Quote jdonbavand Replybullet Topic: Count within PO
    Posted: 26 Nov 2019 at 7:09am
I have a report grouped by PO. Within the group there are various order lines each with a Status - C for Complete, P or W if not yet Complete. However I just want to see whether the whole PO is complete - if any of the order lines within it are P or W, I want it to say "Incomplete" at the Summary Group level, and then work out how many POs are completely complete, and how many still have some outstanding lines.
Janet
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Nov 2019 at 10:10am
GRoup on PO
Create a 'flag' formula to set your vlaue for the row to 1 or 0.
If status in p/w then 1 else 0
sum this for the group level
if your group sum=0 its complete
if your group sum>0 then it is incomplete
IP IP Logged
jdonbavand
Newbie
Newbie
Avatar

Joined: 26 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 12
Quote jdonbavand Replybullet Posted: 26 Nov 2019 at 10:24am
Thanks I will give it a try
Janet
IP IP Logged
jdonbavand
Newbie
Newbie
Avatar

Joined: 26 Jan 2009
Location: United Kingdom
Online Status: Offline
Posts: 12
Quote jdonbavand Replybullet Posted: 29 Nov 2019 at 6:38am
Thanks - have got it working
Janet
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.035 seconds.