I have created a splash page showing Work Orders which were opened in the last 30 days. There are two kinds here, CUSTOMER WORK ORDERS and just WORK ORDERS.
Here is the report as it is coded now:
quote:
OPEN WORK ORDER FOR LAST <= 30 DAYS CUSTOMER ORDERS AND WORK ORDERS DATE: November 28, 2012
WDC WORKDESC COUNT
OPEN CUSTOMER WORK ORDERS
058 REINSPECT FOR SERVICE LEAK 4 303 CURB STOP INOPERABLE 2
OPEN WORK ORDERS
303 CURB STOP INOPERABLE 5 058 REINSPECT FOR SERVICE LEAK 2 258 LOCATE/ADJUST VALVE BOX 2
Here is the code for it:
DEFINE FILE SPL2
DLT/A2 = '<=';
ASGST/A30 = IF ASSIGNEE EQ 'SM06' THEN 'OPEN CUSTOMER ORDERS'
ELSE 'OPEN WORK ORDERS';
END
TABLE FILE SPL2
" OPEN WORK ORDER FOR LAST <DLT 30 DAYS "
" CUSTOMER ORDERS AND WORK ORDERS "
" DATE: &DATEMtrDYY "
" "
SUM SWDC
BY ASGST NOPRINT
BY HIGHEST SWDC NOPRINT
BY ASSIGNEE NOPRINT
BY WDC
BY WORKDESC
ON ASGST SKIP-LINE SUBHEAD
" "
" <ASGST "
ON TABLE SET PAGE NOPAGE
END
-RUN
I am trying to reformat it to look like this:
quote:
OPEN WORK ORDER FOR LAST <= 30 DAYS CUSTOMER ORDERS AND WORK ORDERS DATE: November 28, 2012
OPEN CUSTOMER WORK ORDERS
WDC WORKDESC COUNT 058 REINSPECT FOR SERVICE LEAK 4 303 CURB STOP INOPERABLE 4
OPEN WORK ORDERS
WDC WORKDESC COUNT 303 CURB STOP INOPERABLE 5 058 REINSPECT FOR SERVICE LEAK 2 258 LOCATE/ADJUST VALVE BOX 2
I have been looking through the doc and I cannot find an example for something like this.
Has anyone tried this?
Thanks.This message has been edited. Last edited by: Tomsweb,