Skip to Content
0

Crystal Reports -

Mar 30, 2017 at 03:15 PM

65

avatar image

I am self taught (3 months in). I will try to explain this as best as I can. I have customers that could have multiple open and closed records for their requests. (So one customer may have 2 open requests and 3 closed requests). I need to return results ONLY if all requests are closed.

Right now I can only get it to return results for one or the other (or return both open and closed results). I need crystal to look at the customers records.. and see that even though they may have 3 closed requests, they still have 2 open ones.. and NOT include that customer name in my results.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Mar 31, 2017 at 07:19 AM
0

Create a formula

@open

If {StatusField} = 'OPEN' then 1 else 0

Group report on customer.

In GRoup select formula

Sum(@open, CustomerGroupField) = 0

Ian

Share
10 |10000 characters needed characters left characters exceeded