Focal Point
[CLOSED] Adding border around grids at end of report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5817025096

July 10, 2018, 04:50 PM
JackieO
[CLOSED] Adding border around grids at end of report
I have created a report using AppStudio 8201M. I have physically put the border text into my source code. The borders display in design mode, but when I run the report, the border fails to display. Please tell me where I have gone astray. Here's my source code:

-* File: IBFS:/Development/WFC/Repository/training/std_reports/jackieo1s6bm/ProfessionalVistatReport.fex Created by WebFOCUS AppStudio
-*WHENCE JO_HOLD1 MASTER
SET NODATA = ''
-SET &ACAD_YEAR_DISPLAY = EDIT(&ACADEMIC_YEAR, '9999-$$99');
FILEDEF JO_HOLD1 DISK jo_hold1.ftm
JOIN
PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE
IN professional_staff_data_elem_8 TO MULTIPLE
INSTITUTION.INSTITUTION.INSTITUTION_CODE IN institution TAG J0 AS J0
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=1;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=0;
GRP1_DESC/A40=' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
CNT.SOCIAL_SECURITY_NUMBER/I7C AS 'L_TOTAL'
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY LOWEST INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS JO_HOLD1 FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=2;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=0;
GRP1_DESC/A40=' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7S=0;
END

FILEDEF OUTFILE DISK jo_hold1.ftm (APPEND
TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=2;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=1;
GRP1_DESC/A40=
'HIRING STATUS: ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=2;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=1;
GRP1_DESC/A40='HIRING STATUS: ';
GRP2/I2=1;
GRP2_DESC/A30=
'NEW HIRES: ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=2;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=1;
GRP1_DESC/A40='HIRING STATUS: ';
GRP2/I2=1;
GRP2_DESC/A30='NEW HIRES: ';
GRP3/I2=
IF NEW_HIRE_FULL_OR_PART_TIME EQ '1' THEN 1
ELSE IF NEW_HIRE_FULL_OR_PART_TIME EQ '2' THEN 2
ELSE IF NEW_HIRE_FULL_OR_PART_TIME EQ '0' THEN 3;
GRP3_DESC/A15=
IF GRP3 EQ 1 THEN 'FULL TIME'
ELSE IF GRP3 EQ 2 THEN 'PART TIME'
ELSE IF GRP3 EQ 3 THEN 'DOES NOT APPLY'
ELSE ' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7C=1;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=2;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=2;
GRP1_DESC/A40=
'CITIZENSHIP STATUS: ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2C=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=2;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=2;
GRP1_DESC/A40=
'CITIZENSHIP STATUS: ';
GRP2/I2=
IF (CAT1 EQ 2 AND GRP1 EQ 2 AND CITIZENSHIP_STATUS EQ '1') THEN 1
ELSE IF (CAT1 EQ 2 AND GRP1 EQ 2 AND CITIZENSHIP_STATUS EQ '2') THEN 2
ELSE IF (CAT1 EQ 2 AND GRP1 EQ 2 AND CITIZENSHIP_STATUS EQ '3') THEN 3
ELSE 4;
GRP2_DESC/A30=
IF GRP2 EQ 1 THEN 'U.S. CITIZEN'
ELSE IF GRP2 EQ 2 THEN 'RESIDENT ALIEN'
ELSE IF GRP2 EQ 3 THEN 'NON-RESIDENT ALIEN'
ELSE ' ';
GRP3/I2C=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7C=1;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=3;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=
IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '1') THEN 1
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '2') THEN 2
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '3') THEN 3
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '4') THEN 4
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '5') THEN 5
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '6') THEN 6
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '7') THEN 7
ELSE IF (CAT1 EQ 3 AND ACADEMIC_RANK EQ '9') THEN 9
ELSE 10;
GRP1_DESC/A40=
IF GRP1 EQ 1 THEN 'PROFESSOR'
ELSE IF GRP1 EQ 2 THEN 'ASSOCIATE PROFESSOR'
ELSE IF GRP1 EQ 3 THEN 'ASSISTANT PROFESSOR'
ELSE IF GRP1 EQ 4 THEN 'INSTRUCTOR'
ELSE IF GRP1 EQ 5 THEN 'LECTURER'
ELSE IF GRP1 EQ 6 THEN 'UNDESIGNATED RANK'
ELSE IF GRP1 EQ 7 THEN 'GRADUATE STUDENT'
ELSE IF GRP1 EQ 9 THEN 'DOES NOT APPLY'
ELSE ' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5C=
IF GENDER EQ '1' THEN 1
ELSE 0;
FEMALE/I5C=
IF GENDER EQ '2' THEN 1
ELSE 0;
L_TOTAL/I7C=1;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=4;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=
IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '1') THEN 1
ELSE IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '2') THEN 2
ELSE IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '3') THEN 3
ELSE IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '4') THEN 4
ELSE IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '5') THEN 5
ELSE IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '6') THEN 6
ELSE IF (CAT1 EQ 4 AND MANPOWER_RESOURCE_CATEGORY EQ '9') THEN 9
ELSE 10;
GRP1_DESC/A40=
IF GRP1 EQ 1 THEN 'EXECUTIVE OFFICER'
ELSE IF GRP1 EQ 2 THEN 'DIRECTOR OF OPERATIONAL UNIT OR PROGRAM'
ELSE IF GRP1 EQ 3 THEN 'ADMINISTRATOR WITHIN OPERATIONAL UNIT'
ELSE IF GRP1 EQ 4 THEN 'INSTRUCTION/RESEARCH, PROFESSIONAL'
ELSE IF GRP1 EQ 5 THEN 'INSTRUCTION/RESEARCH ASSISTANTS'
ELSE IF GRP1 EQ 6 THEN 'SPECIALIST/SUPPORT, PROFESSIONAL'
ELSE IF GRP1 EQ 9 THEN 'OTHER (GRADUATE ASSISTANT)'
ELSE ' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5C=
IF GENDER EQ '1' THEN 1
ELSE 0;
FEMALE/I5C=
IF GENDER EQ '2' THEN 1
ELSE 0;
L_TOTAL/I7C=1;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY LOWEST ACADEMIC_YEAR AS 'YEAR'
BY LOWEST INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=5;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=0;
GRP1_DESC/A40=' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY LOWEST ACADEMIC_YEAR AS 'YEAR'
BY LOWEST INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
REST_OF_RACE/A5=
RACIAL_CODE_AFRICAN_AMERICAN ||
RACIAL_CODE_NATIVE_AMERICAN ||
RACIAL_CODE_MIDDLE_FAR_EAST ||
RACIAL_CODE_CAUCASIAN ||
RACIAL_CODE_PACIFIC_ISLANDER;
CAT1/I2=5;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=
IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '2') THEN 2
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '3') THEN 3
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '4') THEN 4
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '6') THEN 6
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '7') THEN 7
ELSE IF (CAT1 EQ 5 AND ACADEMIC_RANK EQ '9') THEN 9
ELSE 10;
GRP1_DESC/A40=
IF GRP1 EQ 1 THEN 'PROFESSOR'
ELSE IF GRP1 EQ 2 THEN 'ASSOCIATE PROFESSOR'
ELSE IF GRP1 EQ 3 THEN 'ASSISTANT PROFESSOR'
ELSE IF GRP1 EQ 4 THEN 'INSTRUCTOR'
ELSE IF GRP1 EQ 5 THEN 'LECTURER'
ELSE IF GRP1 EQ 6 THEN 'UNDESIGNATED RANK'
ELSE IF GRP1 EQ 7 THEN 'GRADUATE STUDENT'
ELSE IF GRP1 EQ 9 THEN 'DOES NOT APPLY'
ELSE ' ';
GRP2/I2=
IF (CAT1 EQ 5 AND GRP1 EQ 1 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 1 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 2 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 3 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 4 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 5 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 6 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 7 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 9 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 5 AND GRP1 EQ 10 AND REST_OF_RACE NE '00000') THEN 10;
GRP2_DESC/A30=
IF GRP2 EQ 1 THEN 'NON-RESIDENT ALIEN'
ELSE IF GRP2 EQ 2 THEN 'BLACK OR AFRICAN AMERICAN'
ELSE IF GRP2 EQ 3 THEN 'AMERICAN INDIAN OR ALASKAN NAT'
ELSE IF GRP2 EQ 4 THEN 'ASIAN'
ELSE IF GRP2 EQ 5 THEN 'HISPANIC OR LATINO'
ELSE IF GRP2 EQ 6 THEN 'WHITE'
ELSE IF GRP2 EQ 7 THEN 'NAT HAWAIIAN OR PAC ISLANDER'
ELSE IF GRP2 EQ 9 THEN 'UNKNOWN'
ELSE IF GRP2 EQ 10 THEN 'MULTIPLE RACES'
ELSE ' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5C=
IF GENDER EQ '1' THEN 1
ELSE 0;
FEMALE/I5C=
IF GENDER EQ '2' THEN 1
ELSE 0;
L_TOTAL/I7C=1;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'Y';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
TYPE=REPORT,
LINES-PER-PAGE=UNLIMITED,
$
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=6;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=0;
GRP1_DESC/A40=' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
L_TOTAL/I7S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'N';
BY LOWEST ACADEMIC_YEAR AS 'YEAR'
BY LOWEST INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
ENDSTYLE
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
REST_OF_RACE/A5=
RACIAL_CODE_AFRICAN_AMERICAN ||
RACIAL_CODE_NATIVE_AMERICAN ||
RACIAL_CODE_MIDDLE_FAR_EAST ||
RACIAL_CODE_CAUCASIAN ||
RACIAL_CODE_PACIFIC_ISLANDER;
CAT1/I2=6;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=
IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '2') THEN 2
ELSE IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '3') THEN 3
ELSE IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '4') THEN 4
ELSE IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '6') THEN 6
ELSE IF (CAT1 EQ 6 AND MANPOWER_RESOURCE_CATEGORY EQ '9') THEN 9
ELSE 10;
GRP1_DESC/A40=
IF GRP1 EQ 1 THEN 'EXECUTIVE OFFICER'
ELSE IF GRP1 EQ 2 THEN 'DIRECTOR OF OPERATIONAL UNIT OR PROGRAM'
ELSE IF GRP1 EQ 3 THEN 'ADMINISTRATOR WITHIN OPERATIONAL UNIT'
ELSE IF GRP1 EQ 4 THEN 'INSTRUCTION/RESEARCH, PROFESSIONAL'
ELSE IF GRP1 EQ 5 THEN 'INSTRUCTION/RESEARCH ASSISTANTS'
ELSE IF GRP1 EQ 6 THEN 'SPECIALIST/SUPPORT, PROFESSIONAL'
ELSE IF GRP1 EQ 9 THEN 'OTHER (GRADUATE ASSISTANT)'
ELSE ' ';
GRP2/I2=
IF (CAT1 EQ 6 AND GRP1 EQ 1 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 1 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 2 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 3 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 4 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 5 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 6 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 9 AND REST_OF_RACE NE '00000') THEN 10
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND NON_RESIDENT_ALIEN_FLAG EQ '1') THEN 1
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND RACIAL_CODE_HISPANIC_LATINO EQ '5') THEN 5
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE EQ '20000') THEN 2
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE EQ '03000') THEN 3
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00400') THEN 4
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00060') THEN 6
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00007') THEN 7
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE EQ '00000') THEN 9
ELSE IF (CAT1 EQ 6 AND GRP1 EQ 10 AND REST_OF_RACE NE '00000') THEN 10;
GRP2_DESC/A30=
IF GRP2 EQ 1 THEN 'NON-RESIDENT ALIEN'
ELSE IF GRP2 EQ 2 THEN 'BLACK OR AFRICAN AMERICAN'
ELSE IF GRP2 EQ 3 THEN 'AMERICAN INDIAN OR ALASKAN NAT'
ELSE IF GRP2 EQ 4 THEN 'ASIAN'
ELSE IF GRP2 EQ 5 THEN 'HISPANIC OR LATINO'
ELSE IF GRP2 EQ 6 THEN 'WHITE'
ELSE IF GRP2 EQ 7 THEN 'NAT HAWAIIAN OR PAC ISLANDER'
ELSE IF GRP2 EQ 9 THEN 'UNKNOWN'
ELSE IF GRP2 EQ 10 THEN 'MULTIPLE RACES'
ELSE ' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=IF GENDER EQ '1' THEN 1 ELSE 0;
FEMALE/I5S=IF GENDER EQ '2' THEN 1 ELSE 0;
L_TOTAL/I7S=1;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
L_TOTAL
COMPUTE SUB_TOTAL/A1 = 'Y';
BY ACADEMIC_YEAR AS 'YEAR'
BY INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SAVE AS OUTFILE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
TYPE=SUBFOOT,
BY=7,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
BY=7,
LINE=1,
OBJECT=TEXT,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
$
ENDSTYLE
END
-*-EXIT
-*
-*DOS dir *.*
-*DOS type jo_hold1.ftm
-*-EXIT

DEFINE FILE JO_HOLD1
Supressed_Male/I7C MISSING ON=IF MALE EQ 0 THEN MISSING ELSE MALE;
Supressed_Female/I7C MISSING ON=IF FEMALE EQ 0 THEN MISSING ELSE FEMALE;
Supressed_Total/I9C MISSING ON=IF L_TOTAL EQ 0 THEN MISSING ELSE L_TOTAL;
TotalRecordCount/I9C=IF CAT1 EQ 1 THEN L_TOTAL;
YEAR1/A4=SUBSTR(8, YEAR, 1, 4, 4, YEAR1);
YEAR2/A4=SUBSTR(8, YEAR, 5, 8, 4, YEAR2);
END

TABLE FILE JO_HOLD1
SUM
Supressed_Male AS 'MALE'
Supressed_Female AS 'FEMALE'
Supressed_Total AS 'TOTAL'
BY YEAR NOPRINT
BY LOWEST INSTITUTION_CODE NOPRINT
BY LOWEST LONG_NAME NOPRINT
BY LOWEST CAT1 NOPRINT
BY LOWEST CAT1_DESC AS 'CATEGORY'
BY LOWEST GRP1 NOPRINT
BY LOWEST GRP1_DESC AS 'SUBGROUP,ONE'
BY LOWEST GRP2 NOPRINT
BY LOWEST GRP2_DESC AS 'SUBGROUP,TWO'
BY LOWEST GRP3 NOPRINT
BY GRP3_DESC AS 'SUBGROUP,THREE'

ON CAT1 UNDER-LINE

ON GRP1_DESC SUBTOTAL
Supressed_Total AS ''
WHEN SUB_TOTAL EQ 'Y';
HEADING
"OKLAHOMA STATE REGENTS FOR HIGHER EDUCATION"
"UDS PROFESSIONAL STAFF DATA SUBMISSION SUMMARY FOR: <+0> &ACAD_YEAR_DISPLAY (SEE NOTE*)"
"REPORT END DATE: &DATEMDYY"
"FOOTING
"BY SIGNING BELOW, I CERTIFY THAT THE ABOVE SUMMARY OF THE ACCOMPANYING UDS DATA SUBMISSION REPRESENTS TRUE AND ACCURATE INFORMATION FOR THE ACADEMIC YEAR AND SEMESTER SHOWN."
" "
"________________________________________________________________________________________________________________________________________________________________________________________________"
"PRESIDENT OR DESIGNEE'S SIGNATURE<+0>DATE"
" "
"ACCOMPANYING UDS SUBMISSION CONTAINS:"
"RECORD TYPE P COUNT:" "
" "
"NOTE:<+0>THE SUM SHOULD MATCH THE GRAND TOTAL."
"NOTE:" <+0>SUMMER:<+0> "
" <+0>FALL:" <+0>SPRING:ON TABLE SET PAGE-NUM OFF
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/ok.sty,
$
TYPE=REPORT,
LINES-PER-PAGE=UNLIMITED,
ARGRAPHENGINE=JSCHART,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=OFF,
JUSTIFY=LEFT,
WIDTH=5.875,
$
TYPE=FOOTING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=7.125,
$
TYPE=FOOTING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=ON,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=CENTER,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=1.625,
$
TYPE=FOOTING,
LINE=7,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=11.375,
$
TYPE=FOOTING,
LINE=8,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=9,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=13.000,
$
TYPE=FOOTING,
LINE=10,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=OFF,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=FOOTING,
LINE=10,
OBJECT=TEXT,
ITEM=2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=12.000,
$
TYPE=FOOTING,
LINE=11,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=OFF,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=FOOTING,
LINE=11,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=12.000,
$
TYPE=FOOTING,
LINE=12,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=OFF,
JUSTIFY=RIGHT,
WIDTH=1.000,
$
TYPE=FOOTING,
LINE=12,
OBJECT=TEXT,
ITEM=2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
JUSTIFY=LEFT,
WIDTH=.875,
$
TYPE=FOOTING,
LINE=12,
OBJECT=TEXT,
ITEM=3,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=11.125,
$
TYPE=FOOTING,
LINE=13,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=OFF,
JUSTIFY=RIGHT,
WIDTH=1.000,
$
TYPE=FOOTING,
LINE=13,
OBJECT=TEXT,
ITEM=2,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
JUSTIFY=LEFT,
WIDTH=.875,
$
TYPE=FOOTING,
LINE=13,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=11.125,
$
TYPE=FOOTING,
LINE=14,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=MEDIUM,
BORDER-RIGHT=OFF,
JUSTIFY=RIGHT,
WIDTH=1.000,
$
TYPE=FOOTING,
LINE=14,
OBJECT=TEXT,
ITEM=2,
BORDER-TOP=OFF,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
JUSTIFY=LEFT,
WIDTH=.875,
$
TYPE=FOOTING,
LINE=14,
OBJECT=FIELD,
ITEM=1,
BORDER-TOP=OFF,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=MEDIUM,
JUSTIFY=LEFT,
WIDTH=11.125,
$
TYPE=SUBTOTAL,
BY=7,
SIZE=10,
$
TYPE=SUBTOTAL,
BY=7,
OBJECT=TAG,
SIZE=8,
JUSTIFY=RIGHT,
$
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 7.6
Windows, All Outputs
July 10, 2018, 05:22 PM
Doug
Can you provide some simple code to illustrate you concern, as we don't have access to that source data?
July 12, 2018, 04:13 PM
JackieO
Doug

I don't remember how to upload files to the forum. Don't see any way using this reply. I have captured the report in design mode that shows the border present. I also have captured the submitted report that fails to display the border. Since the report consists of appended reports in a hold table, can you just use the last two reports from the code that I have already provided?


WebFOCUS 7.6
Windows, All Outputs
July 13, 2018, 07:39 AM
MartinY
@Jackie,

Doug point is : can you reproduce your issue with a IB sample file such as CAR ?
We don't need to have your data and we don't want to.

Sometime by reproducing the problem you find the issue yourself and have it fixed.

Thanks


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007