Hello Crystal Experts -

 

I have a report where I want it to show tickets. The tickets have an analyst, which is the owner of the ticket. But some analysts of the tickets also have an assigment on the ticket, which may be Active or Closed. Tickets can have more than one assignment, which can be Active or Closed. 

 

I only want tickets to show on the report where the analyst has an assignment that is Active, not Closed.

 

thanks for your help in advance.

 

G