I am designing some reports to support our IT's service management processes (We use ITIL as a framework) and I have been asked to include some information on jobs that are overdue, or will become overdue within 24 hours.

 

I am using the Select Expert to select the expired jobs. That's easy enough, since the SLA_Violated field is a Y/N.

 

However, I'm not sure how to approach the issue of including jobs due to expire within 24 hours.  We do have a "required date" and a "required time" field (2 seperate fields), so I could measure against those 2...but I'm not too sure how to actually do it in crystal. 

 

Any help appreciated.

 

Regards,

 

AndyI

 

 

the view I am now using already has both an SLA expiry field (binary) and a Time To Violation field in the format needed :)

 

Possibly superfluous, but using those 2 fields, I was able to apply some intelligence to my listing of jobs (I couldn't use the previously suggested code properly and need to meet deadlines):

 

if {VIEW.sla_violation}=0 and
dateadd("h",24,CurrentDateTime) > {@Convert Date} then
"Due to expire within 24" else
if {VIEW.sla_violation}=1 then
"SLA Violated"
else
"Not due to expire within 24 hours"

 

Now to set up the summary :)