[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 ENDThis 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