Report work complete within timeframe

[typhoid]

Hi, looking for some assistance with this one, thought it was easier than it is.
I am looking to produce a report that identifies that work orders have been completed within set guidelines/timeframes.
I have a report date = work order (W/o) raised (date and time)automatic on raising w/o
I have a status change date = date that the w/o was modified
(status that identify that w/o's have been dealt with are: Cancel, Wfin, Comp or Close. however any 1 w/o may go through 2 of these states eg work may be Comp and then the W/o will be closed).
I have a status field = current status of w/o
I have a priority field = priorities have time criteria
Priority 1=30mins,2=60mins,3=4hrs,4=1day,5=2days,6=3days,7=4days,8=7days,9=10days,10=14days,11=1month,12=a specified date,13=contract spec(and will be set)14=20days,15=2hrs.
I then need to identify the percentage of W/o's being completed within the timeframe which I would like to graph on a monthly basis as workflow fluctuates throughout the year.
Anyone like to have a go??

 

[typhoid]

Whoops,
we are using Crystal 7

 

[Ngolem]

Why don't you try it yourself and ask for help when you reach a problem....don't want to spoon feed you.

Jim Broadbent

 

[typhoid]

Well,

this was the track I was going down, but it didn't cut the mustard, was lookin for ideas on other ways to go about it, rather than to confuse the issue

Step 1. Calculate due date based on priority
E.g
if {WORKORDER.WOPRIORITY} = 4
then {WORKORDER.ACTSTART} + 1
else
if {WORKORDER.WOPRIORITY} = 5
then {WORKORDER.ACTSTART} + 2
else
if {WORKORDER.WOPRIORITY} = 6
then {WORKORDER.ACTSTART} + 3
else....................

Step 2 - Exclude weekends
E.g
if DayOfWeek ({WORKORDER.ACTSTART})>=5 and {WORKORDER.WOPRIORITY}>3
then STEP1 + 2
else STEP 1

Step 3 - Check WO's completed within timeframe
E.g
if {WORKORDER.ACTFINISH}> STEP 2
then 'FAIL'
else 'PASS'

Calculate % based on number 'PASS' / {WORKORDER.ACTFINISH}

somehow have to make it dynamic to pick up each month for last 12 months and secondary report to pick up previous calender year

 

[typhoid]

ps golem....thanks for your useful contribution
I never would have thought to try to do it myself first.
problem is I have previously on used report writers to identify current now type data

 

[Ngolem]

**********
problem is I have previously on used report writers to identify current now type data
**********

??? Sorry I don't understand this sentence

Jim Broadbent