gennaroalpha7
Technical User
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
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