Help... I am trying to updated on of our reports to add some additional logic to exclude certain groups of individuals. I do not have any Crystal codeing experience but I do have SQL experience.
Below is a portion of the code I am trying modify. The problem I am having is with the Not In statement.. I keep getting prompted that I am missing a parenthesis but I don't know where it needs to go. I have tried adding it to several places in this statement.
Rather than spending too much time on this I was hoping someone could provide some guidance.
thank you.
({Students.Field2} in ["PHOEECOC", "DUBLECOC", "AUROECOC", "AUROBAOP", "PHOEBAOP", "DUBLBAOP", "AUROBAOS", "PHOEBAOS", "DUBLBAOS"]
and
{Students.Supervisor} not in ["Flint, David A.",”Jones, Bruce”,”Smith Scott C”]
or
({Students.Field2} in ["PHOEECOS", "DUBLECOS"] and
{Students.Supervisor} in ["Gomez, John", "Torres, Lilly", "Ward, Roger D."]))
IP Logged
