Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Adding border around grids at end of report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Adding border around grids at end of report
 Login/Join
 
Member
posted
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
 
Posts: 26 | Location: Oklahoma City | Registered: January 27, 2012Report This Post
Expert
posted Hide Post
Can you provide some simple code to illustrate you concern, as we don't have access to that source data?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Member
posted Hide Post
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
 
Posts: 26 | Location: Oklahoma City | Registered: January 27, 2012Report This Post
Virtuoso
posted Hide Post
@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
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Adding border around grids at end of report

Copyright © 1996-2020 Information Builders