Newbie Here.  I’m having an issue with a select expert formula that I’m wondering if you can help me on.  I’m using Crystal 11 to pull reports from a ticketing system (HEAT).  In a given ticket there can be a number of assignments which are in the Asgnmnt table.  An assignment consists of a group and then individual assignees under that group.  In a ticket there may be a total of 3 assignments, all that have different groups and obviously different assignees. 

The report I’m working on is grouped by ticket number and then assignment.  I’m trying to setup the select expert so it only gives me tickets that have at least one assignment to “USSC CCA II Review” in them, of those tickets I want it to also give me the assignments that are under a different group name called “US REG SRS”.  I’m thinking it’s some sort of If Then statement I need to use in the select expert but I’ve made several attempts at and just not having much luck.  To restate what I want my end result to be, I want the report to only give me tickets that have a “USSC CCA II Review” assignment in them, and then I want to see all of the “USSC CCA II Review” assignments, and the assignments that have the group name of “US REG SRS”.

Any thoughts on how I would do this?  I was thinking I could put an IF THEN statement in Select expert like below, and it gives me the right tickets, but doesn’t let me see the assignments that are under the groupname US REG SRS (the assignment “USSC CCA II Review” isn’t under the groupname “US REG SRS”).

If {Asgnmnt.groupname} = "US REG SRS"

  Then  {Asgnmnt.Assignee} in "USSC CCA II Review"

          Else {Asgnmnt.Assignee} = "USSC CCA II Review"

To be honest, I wouldn't be surprised if I'm going about it all wrong, and I don't even need to get this setup in the select expert like I'm trying to do.  Thanks in advance for any help you can provide me.

Thanks so much for your help...sorry I didn't do a better job explaining my setup.  I’m not sure if this is what you’re looking for, but let’s say we have three tickets down below.  I want to only pull the tickets that have a “USSC CCA II Review” assignment in them.  Also, for those tickets that have that assignment (USSC CCA II Review)if they have any assignments in them with the group name of US REG SRS, I want to be able to pull those assignments as well.  So for the below examples, I would want to pull tickets 12345 and 67890 and see assignments 1 and 2 on the first ticket, and the assignment on the second ticket as well.  I wouldn’t want the report to pull the third ticket at all. 

1.       Ticket 12345

                                                                Group Name         Assignee Name

Assignment 1:                       USSC                       USSC CCA II Review

Assignment 2:                       US REG SRS            John Doe              

                Assignment 3:                       etc                          Jane Doe               

2.       Ticket 67890

Group Name         Assignee Name

Assignment 1:                       USSC                       USSC CCA II Review

3.       Ticket 99999

Group Name         Assignee Name

Assignment 1:                       US REG SRS            John Doe              

                Assignment 2:                       etc                          Jane Doe