Total Tickets for month / Total Closed / Total Remain Open / Total Reassign

[Former Member]

Hello, I'm hoping someone can help.

I need to figure out how to do the following:

I need a report which shows the total number of calls received within a given period of time (example from 9/15/08 to 10/15/08, allowing the user to select the dates).

From that total number of tickets, I need it broke down to how many of those tickets were closed within that same time period; how many remain open and of the tickets remaining open, how many were reassigned.

I'm pulling this information from HEAT Call Logging System.

I hope someone can help.

Thanks

[Former Member · Accepted solution]

Hi Gary,

To get the required information you may have to write 3 formulas :

formula1

Numbervar closed;

if TicketStatus = 'Closed"

Then

Closed:=Closed+1;

Closed;

formula2

Numbervar open;

if TicketStatus = 'Open"

Then

open:=open+1;

open;

formula3

Numbervar reassign;

if TicketStatus = 'Reassign"

Then

reassign:=reassign+1;

reassign;

Now place these formulas on your report details section and insert summaries to get the total count.

Thanks,

Sastry

[Former Member · Accepted solution]

Thank you for your response.

I have tried this and everything seems to be working except for the 'reassign' section. When I try using this it throws the figures off for the other fields and the 'reassign' field comes back with 0.00.

Any other thoughts?

Also, with that in mind. Do you know how to remove the .00 from the end of the totals?

Thanks again.

[Former Member · Accepted solution]

I've been working alittle more with Crystal Reports and know alittle more about how to create formulas.

I've taken the information you have given and created a few formulas.

With this formula, I am trying to get a number of all tickets that are not closed.

Numbervar TicketsOpen;

if {CallLog.CallStatus} <> "Closed"

Then

TicketsOpen:=TicketsOpen+1;

TicketsOpen;

For some reason when the formula gives me the total count, it is adding 1 for each assignment within the ticket. So if I have 10 tickets that are not closed and 3 of them have 2 assignment pages, it is giving me a total count of 13 (10 open tickets + 3 additional assignments).

In my Select Expert I have it broken down by {CallLog.RecvdDate} in {@StartDateFormula} to {@EndDateFormula} and {CallLog.RecvdBy} with a list of associates.

I have tried to figure out a way to suppress the additional assignments if the Call.ID is the same, but Section Expert for the Report Footer does not allow for suppressing for duplicate information and I'm not sure how to write this into the above formula.

Any ideas?

Thanks again.