Print Page | Close Window

Count within PO Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22843 Printed Date: 27 Apr 2024 at 2:09pm Topic: Count within PO Posted By: jdonbavand Subject: Count within PO Date 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 Replies: Posted By: DBlank Date 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 Posted By: jdonbavand Date Posted: 26 Nov 2019 at 10:24am Thanks I will give it a try ------------- Janet Posted By: jdonbavand Date Posted: 29 Nov 2019 at 6:38am Thanks - have got it working ------------- Janet

Print Page | Close Window