Question

Locked

Coding Help with Crystal 11

By samcarter1022 ·
I am trying to create a report that checks to see if a ticket was compelted within a certain SLA. In this case the SLAs are < 6 hours for high and < 4 hours for Urgent tickets.

I have the following already setup, but I can't seem to get the hours right, no matter which way I type them crystal seems to be making up it's own mind as to which falls into which category.

AssignDuration formula:

stringvar AssignDuration;

if IsNull({@Assigned_ACK_DateTime}) then AssignDuration := totext(DateDiff("m", {@AssignDateTime}, CurrentDateTime))

else AssignDuration := totext((datediff ("n", {@AssignDateTime}, {@Assigned_ACK_DateTime})));

AssignDuration

SLANotes Formula:

stringvar SLANotes;

if {CALLLOG.PRIORITY} = "1-Urgent" then

(
if {@AssignDuration} < "4" then (SLANotes := "Within SLA")
else SLANotes := "Out of SLA"
)

else

if {CALLLOG.PRIORITY} = "2-High" then

(
if {@AssignDuration} < "6" then (SLANotes := "Within SLA")
else SLANotes := "Out of SLA"
);

SLANotes

Any help you can provide would be appreciated.

Thanks,

Kerry.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums