Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
Prod: | WebFOCUS 7.6.10/8.1.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux | Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 | |||||||
Pity the lost knowledge of an old programmer! |
EX -LINES 14 EDAPUT MASTER,class_data,CV,FILE FILENAME=CLASS_DATA, SUFFIX=DFIX,$ SEGNAME=CLASS_DATA,$ FIELD=CASE_ID, ALIAS=CLASS_ID, A4, A4,$ FIELD=ISMAKEUP, ALIAS=ISMAKEUP, A6, A6,$ FIELD=CLASS, ALIAS=CLASS, A7, A7,$ FIELD=ISMARRIED, ALIAS=CLASS, A6, A6,$ FIELD=SESSION_1, ALIAS=SESSION_1, A2, A2,$ FIELD=SESSION_2, ALIAS=SESSION_2, A2, A2,$ FIELD=SESSION_3, ALIAS=SESSION_3, A2, A2,$ FIELD=SESSION_4, ALIAS=SESSION_4, A2, A2,$ FIELD=SESSION_5, ALIAS=SESSION_5, A2, A2,$ FIELD=SESSION_6, ALIAS=SESSION_6, A2, A2,$ FIELD=DELIMITER, ALIAS=',', A1, A1,$ FILEDEF CLASS_DATA DISK class_data.txt -RUN -WRITE CLASS_DATA 1111,TRUE,Class 1,FALSE,M,MF,M,M,F,MF -WRITE CLASS_DATA 2222,TRUE,Class 2,FALSE,MF,M,MF,M,M,F -WRITE CLASS_DATA 3333,TRUE,Class 3,FALSE,MF,F,F,M,M,MF -WRITE CLASS_DATA 4444,FALSE,Class 4,FALSE,F,MF,F,M,F,MF -WRITE CLASS_DATA 5555,FALSE,Class 5,FALSE,MF,MF,F,M,MF,F -RUN DEFINE FILE CLASS_DATA MARRIED/A20 = IF (ISMARRIED EQ 'FALSE') THEN 'Unmarried' ELSE IF (ISMARRIED EQ 'TRUE') THEN 'Married' ELSE 'Unknown'; CLASS_DESC/A50 = IF (ISMAKEUP EQ 'FALSE') THEN 'Class Attendance' ELSE IF (ISMAKEUP EQ 'TRUE') THEN 'Makeup Attendance' ELSE 'Unknown'; CLASS_TITLE/A10 = IF (ISMAKEUP EQ 'FALSE') THEN 'Class' ELSE IF (ISMAKEUP EQ 'TRUE') THEN 'Makeup' ELSE 'Unknown'; SESSION_TITLE/A10 = IF (CLASS_DESC EQ 'Class Attendance') THEN 'Session' ELSE ' '; SESSION_1_CNT/I8 = DECODE SESSION_1 ( 'MF' 2 'M' 1 'F' 1 ELSE 0); SESSION_2_CNT/I8 = DECODE SESSION_2 ( 'MF' 2 'M' 1 'F' 1 ELSE 0); SESSION_3_CNT/I8 = DECODE SESSION_3 ( 'MF' 2 'M' 1 'F' 1 ELSE 0); SESSION_4_CNT/I8 = DECODE SESSION_4 ( 'MF' 2 'M' 1 'F' 1 ELSE 0); SESSION_5_CNT/I8 = DECODE SESSION_5 ( 'MF' 2 'M' 1 'F' 1 ELSE 0); SESSION_6_CNT/I8 = DECODE SESSION_6 ( 'MF' 2 'M' 1 'F' 1 ELSE 0); DUMMY/A1 = ''; END TABLE FILE CLASS_DATA PRINT CLASS AS '' CASE_ID AS '' MARRIED AS '' SESSION_1 AS '' SESSION_2 AS '' SESSION_3 AS '' SESSION_4 AS '' SESSION_5 AS '' SESSION_6 AS '' BY CLASS_DESC NOPRINT BY DUMMY NOPRINT ON CLASS_DESC SUBHEAD "<DUMMY<+0><DUMMY<+0><DUMMY<+0><SESSION_TITLE" ON DUMMY SUBHEAD "<CLASS_TITLE<+0>CaseID<+0>Married/Unmarried<+0>1<+0>2<+0>3<+0>4<+0>5<+0>6" ON CLASS_DESC SUBFOOT "<CLASS_DESC<+0><ST.SESSION_1_CNT<+0><ST.SESSION_2_CNT<+0><ST.SESSION_3_CNT<+0><ST.SESSION_4_CNT<+0><ST.SESSION_5_CNT<+0><ST.SESSION_6_CNT" ON TABLE SUBFOOT "Total Class Attendance<+0><ST.SESSION_1_CNT<+0><ST.SESSION_2_CNT<+0><ST.SESSION_3_CNT<+0><ST.SESSION_4_CNT<+0><ST.SESSION_5_CNT<+0><ST.SESSION_6_CNT" ON TABLE NOTOTAL ON TABLE SET PAGE-NUM OFF ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN,PAGESIZE='Letter',LEFTMARGIN=0.250000,RIGHTMARGIN=0.250000,TOPMARGIN=0.25000,BOTTOMMARGIN=0.250000,SQUEEZE=ON,ORIENTATION=PORTRAIT,$ TYPE=REPORT,FONT='ARIAL',SIZE=10,COLOR='BLACK',STYLE=NORMAL,GRID=OFF,$ TYPE=SUBHEAD,BY=CLASS_DESC,HEADALIGN=BODY,STYLE=BOLD,$ TYPE=SUBHEAD,BY=CLASS_DESC,LINE=1,ITEM=4,OBJECT=FIELD,COLSPAN=6,JUSTIFY=CENTER,$ TYPE=SUBHEAD,BY=DUMMY,HEADALIGN=BODY,STYLE=BOLD,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-BOTTOM-STYLE=DOUBLE,$ TYPE=SUBFOOT,BY=CLASS_DESC,HEADALIGN=BODY,STYLE=BOLD,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-BOTTOM-STYLE=DOUBLE,$ TYPE=SUBFOOT,BY=CLASS_DESC,LINE=1,ITEM=1,OBJECT=FIELD,COLSPAN=3,$ TYPE=TABFOOTING,HEADALIGN=BODY,STYLE=BOLD,BORDER=MEDIUM,COLOR=RED,$ TYPE=TABFOOTING,LINE=1,ITEM=1,OBJECT=TEXT,COLSPAN=3,$ ENDSTYLE END
FILENAME= ****CLASS_TRACKING**, SUFFIX=SQLMSS , $ SEGMENT=***CLASS_TRACKING****, SEGTYPE=S0, $ FIELDNAME=EVENTID, ALIAS=eventid, USAGE=I11, ACTUAL=I4, FIELDTYPE=R, $ FIELDNAME=CASEID, ALIAS=caseid, USAGE=I11, ACTUAL=I4, $ FIELDNAME=TITLE, ALIAS=title, USAGE=A100V, ACTUAL=A100V, MISSING=ON, $ FIELDNAME=MARRIEDIND, ALIAS=marriedind, USAGE=I11, ACTUAL=I4, MISSING=ON, $ FIELDNAME=ISMAKEUP, ALIAS=isMakeup, USAGE=A1V, ACTUAL=A1V, $ FIELDNAME=1, ALIAS=1, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=2, ALIAS=2, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=3, ALIAS=3, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=4, ALIAS=4, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=5, ALIAS=5, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=6, ALIAS=6, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=7, ALIAS=7, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=8, ALIAS=8, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=9, ALIAS=9, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=10, ALIAS=10, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=11, ALIAS=11, USAGE=A2V, ACTUAL=A2V,$ FIELDNAME=12, ALIAS=12, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=13, ALIAS=13, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=14, ALIAS=14, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=15, ALIAS=15, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=16, ALIAS=16, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=17, ALIAS=17, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=18, ALIAS=18, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=19, ALIAS=19, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=20, ALIAS=20, USAGE=A2V, ACTUAL=A2V, $ FIELDNAME=21, ALIAS=21, USAGE=A2V, ACTUAL=A2V,$