Mirrored Columns

[gennaroalpha7]

Hello, I have a report that has a column named Asgnmnt.Assignee, for this column I have included the Fidelity (people) group to fill that column according to what ticket they are assigned to.

I want to add another column in the same report with the column named, as above, Asgnmnt.Assignee and I want the group (people) Contract.Services to populate that column according to what ticket number they are assigned. I do not want any people from the group Fidelity in that column, only the group Contract.Services. When I add another column, Asgnmnt.Assignee , with the group Contract.Services to the code it only creates a mirrored column - not a totally separate column.

This is a little above me as I am still learning Crystal Syntax. How can I add another column with the same Asgnmnt.Assignee and at the same time keep them separate? Can an If else statement required?

Here is the code that I have now...

{Asgnmnt.AssignStatus} <> "Closed" and
not ({Asgnmnt.Assignee} in ["Fidelity"]) and
{Asgnmnt.GroupName} in ["Fidelity"] and
{CallLog.CustType} in ["Branch", "Employee"] and
{CallLog.KeyWord} in ["Teller Capture", "Touch Point Sales", "Touch Point Service", "Touch Point Teller", "TP Admin Defect", "TP Sales Defect", "TP Sales/Service", "TP Sales/Services", "TP Service Defect", "TP Teller Defect", "TPSS Defect"] and
{CallLog.CallStatus} <> "Closed" and
{CallLog.RecvdDate} >= "2009-08-01"

Thank you.
Alpha7

 

[gennaroalpha7]

Hello,

Fyi

Here is the code with the Contract.Services group added.

{Asgnmnt.AssignStatus} <> "Closed" and
{CallLog.CallStatus} <> "Closed" and
{CallLog.RecvdDate} >= "2009-08-01" and
{CallLog.KeyWord} in ["Teller Capture", "Touch Point Sales", "Touch Point Service", "Touch Point Teller", "TP Admin Defect", "TP Sales Defect", "TP Sales/Service", "TP Sales/Services", "TP Service Defect", "TP Teller Defect", "TPSS Defect"] and
{CallLog.CustType} in ["Branch", "Employee"] and
{Asgnmnt.GroupName} in ["Contract Services", "Fidelity"] and
not ({Asgnmnt.Assignee} in ["Contract Services", "Fidelity"])

Is there a way to make this two columns instead of one? One colomn with the Fidelity group and the other with the Contract Services group.

Thanks.
Alpha7