Skip to Content
avatar image
Former Member

Crystal Reports -

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 31, 2017 at 07:19 AM

    Create a formula

    @open

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

    Group report on customer.

    In GRoup select formula

    Sum(@open, CustomerGroupField) = 0

    Ian

    Add comment
    10|10000 characters needed characters exceeded