Exclude order if it has a particular status 1

[FireGeek21]

I would like to exclude a whole order (group & detail) if a particular status shows up in the detail. So in the list of orders below, ORDER951 (group header and detail) should be the only one kept because it does not have STATUSX in the list of statuses. There is an additional 2 group levels above ORDER - CUSTOMER and CATEGORY. Thoughts on how to do this???

ORDER123
STATUSA
STATUSB
STATUSX
STATUSC

ORDER456
STATUSA
STATUSX

ORDER789
STATUSX

ORDER951
STATUSA
STATUSB
STATUSC


FireGeek
(currently using Crystal Reports XI with Lawson 9.01)

 

[SmpTraining]

Create a formula such as:

if {statuscode} = 'STATUSX' then 1 else 0

...and put this in the details section (you can suppress it of course)

Then sum this by your Group field. This will show as a zero for groups you want to keep and crystal lets you select based on subtotals. Therefore simply click the subtotal and go to the select expert to select where your subtotal = 0.

Your group tree will continue to show the groups that aren't displayed as crystal is essentially just not displaying the groups. For the same reason, Grand totals will also still show the full total figures.

Steve Phillips, Crystal Reports Trainer & Consultant

http://www.smptraining.co.uk

 

[FireGeek21]

Works perfectly!!! Thank you!!!

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)