Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Separate Columns

Status
Not open for further replies.

gennaroalpha7

Technical User
Nov 28, 2012
253
US
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


 
Please do not start multiple threads on the same issue. I suspect the reason nobody responded the first time was because they didn't understand it - I certainly didn't.

Perhaps if you posted some sample data and how you want it displayed someone might be able to assist. As it stands, I wouldn't know where to start.

Cheers
Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top