Displaying another Column

[gennaroalpha7]

Hello, and thanks in advance for your help.

I would like to show a column that displays (a subreport or not) "Open Tickets" that the analyst has currently opened when the report is ran or printed. I already have " ({CallLog.CallStatus} <> "Closed" or
({CallLog.CallStatus} = "Closed" " in the record selection. Here is my current code in the record selection formula.

not ({CallLog.KeyWord} in ["FIS", "TP Admin Defect", "TP Capture Defect", "TP Sales Defect", "TP Service Defect", "TP Teller Defect", "TPSS Defect"]) and
{CallLog.Tracker} in ["ANTONJ83", "bermun01", "CAMCACX1", "CHAVEV60", "COBBS53", "DONESC72", "FLOREV02", "HEALEP20", "Heldet00", "HERREC86", "jauree01", "LIMM01", "mirelj91", "Perezm58", "phant27", "Poste54", "Pricer64", "QUEZAM01", "RAVANR37", "RIGORAD1", "salesc01", "VAZQUD01"] and
({CallLog.CallStatus} <> "Closed" or
	({CallLog.CallStatus} = "Closed" and
		IsDate({CallLog.ClosedDate}) and
		
        Date({CallLog.ClosedDate}) = CurrentDate
	))

Is there a way to accomplish this? Would this be conflicting? Can it be accomplished with a formula

Thanks for the help.

G.

 

[Charliy]

Group by Analyst
Create a Running Total to count the tickets.
if you don't want to count the ones that were closed today, then Evaluate on Formula adn make the evaluate formula:
Date({CallLog.ClosedDate}) < CurrentDate

Reset the Running Total on the change of Group.

Put the running total in your group footer.

 

[gennaroalpha7]

Thanks. I'll give it a shake.

Thanks for your help.

G.