March 30, 2011, 03:00 PM
MAdams1Hi Kerry,
Thank you for responding. Here is my code.
Michelle
Compound report:
-* File admit_entry_compound
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
OBJECT=TOC, NAME='text1', TEXT='<font face="ARIAL" size=10 color=#000000>Admit Entry Reports - Table of Contents<BR></font>', MARKUP=ON, TOC-NUMBERING=OFF, POSITION=(0.813 0.813), DIMENSION=(7.000 9.500), font='ARIAL', color=RGB(0 0 0), size=10, TOC-FILL=DOTS, METADATA=' TOCTITLE: Table of Contents', $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='Applicants by Student Type Report', TOC-LEVEL=2, POSITION=(2.208 0.250), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 5.101in; HEIGHT: 2.292in; OVERFLOW: auto; TOP: 0.25in; LEFT: 2.208in', $
COMPONENT='graph1', TEXT='Applicants by Student Type Graph', TOC-LEVEL=2, POSITION=(0.708 2.667), DIMENSION=(7.289 2.124), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.289in; HEIGHT: 2.124in; TOP: 2.667in; LEFT: 0.708in', $
COMPONENT='report2', TEXT='Applicants by Gender Report', TOC-LEVEL=2, POSITION=(2.771 5.292), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.769in; HEIGHT: 2.1in; OVERFLOW: auto; TOP: 5.292in; LEFT: 2.771in', $
COMPONENT='graph2', TEXT='Applicants by Gender Graph', TOC-LEVEL=2, POSITION=(0.833 7.333), DIMENSION=(7.292 3.169), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.292in; HEIGHT: 3.169in; TOP: 7.333in; LEFT: 0.833in', $
OBJECT=BOX, NAME='line1', POSITION=(0.729 5.021), DIMENSION=(7.188 0.050), BACKCOLOR=RGB(220 220 220), BORDER-COLOR=RGB(220 220 220), METADATA='Z-INDEX: 100; POSITION: absolute; BACKGROUND-COLOR: rgb(220,220,220); WIDTH: 7.188in; HEIGHT: 0.05in; FONT-SIZE: 1pt; TOP: 5.021in; LEFT: 0.729in', $
OBJECT=BOX, NAME='line3', POSITION=(0.812 10.625), DIMENSION=(7.188 0.050), BACKCOLOR=RGB(220 220 220), BORDER-COLOR=RGB(220 220 220), METADATA='Z-INDEX: 101; POSITION: absolute; BACKGROUND-COLOR: rgb(220,220,220); WIDTH: 7.188in; HEIGHT: 0.05in; FONT-SIZE: 1pt; TOP: 10.625in; LEFT: 0.812in', $
PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report3', TEXT='Applicants by Age Group Report', TOC-LEVEL=2, POSITION=(2.604 1.063), DIMENSION=(3.957 3.024), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.957in; HEIGHT: 3.024in; OVERFLOW: auto; TOP: 1.063in; LEFT: 2.604in', $
COMPONENT='graph3', TEXT='Applicants by Age Group Graph', TOC-LEVEL=2, POSITION=(1.583 4.458), DIMENSION=(5.838 3.897), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 5.838in; HEIGHT: 3.897in; TOP: 4.458in; LEFT: 1.583in', $
OBJECT=BOX, NAME='line4', POSITION=(0.646 9.125), DIMENSION=(7.188 0.050), BACKCOLOR=RGB(220 220 220), BORDER-COLOR=RGB(220 220 220), METADATA='Z-INDEX: 100; POSITION: absolute; BACKGROUND-COLOR: rgb(220,220,220); WIDTH: 7.188in; HEIGHT: 0.05in; FONT-SIZE: 1pt; TOP: 9.125in; LEFT: 0.646in', $
PAGELAYOUT=3, NAME='Page layout 3', text='Page layout 3', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report4', TEXT='report4', TOC-LEVEL=2, POSITION=(2.396 0.854), DIMENSION=(3.750 2.396), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.75in; HEIGHT: 2.396in; OVERFLOW: auto; TOP: 0.854in; LEFT: 2.396in', $
COMPONENT='graph4', TEXT='graph4', TOC-LEVEL=2, POSITION=(1.458 3.563), DIMENSION=(5.833 2.813), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 5.833in; HEIGHT: 2.813in; TOP: 3.563in; LEFT: 1.458in', $
OBJECT=BOX, NAME='line5', POSITION=(0.646 8.667), DIMENSION=(7.188 0.050), BACKCOLOR=RGB(220 220 220), BORDER-COLOR=RGB(220 220 220), METADATA='Z-INDEX: 100; POSITION: absolute; BACKGROUND-COLOR: rgb(220,220,220); WIDTH: 7.188in; HEIGHT: 0.05in; FONT-SIZE: 1pt; TOP: 8.667in; LEFT: 0.646in', $
PAGELAYOUT=4, NAME='Page layout 4', text='Page layout 4', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='DfltCmpt5', POSITION=(0 0), DIMENSION=(0 0), $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE admit_apps_by_stud_type_report.fex
SET COMPONENT='graph1'
-*component_type graph
-INCLUDE admit_apps_by_stud_type_graph.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE admit_apps_by_gender_report.fex
SET COMPONENT='graph2'
-*component_type graph
-INCLUDE admit_apps_by_gender_graph.fex
SET COMPONENT='report3'
-*component_type report
-INCLUDE admit_apps_by_age_group_report.fex
SET COMPONENT='graph3'
-*component_type graph
-INCLUDE admit_apps_by_age_group_graph1.fex
SET COMPONENT='report4'
-*component_type report
SET COMPONENT='graph4'
-*component_type graph
SET COMPONENT='DfltCmpt5'
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
IF READLIMIT EQ 1
ON TABLE SET PREVIEW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
object=line, position=(-1 -1), endpoint=(-2 -2), $
END
COMPOUND END
Graph Code with tool tips that work:
-* File admit_apps_by_stud_type.fex
SET ASNAMES=ON
DEFINE FILE STUDENT_APPL_HISTORY_DIM
app_month/A4V=HNAME(STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_DATE, 'MONTH', app_month);
app_mon_int/I2=DECODE app_month( JAN 1 FEB 2 MAR 3 APR 4 MAY 5 JUN 6 JUL 7 AUG 8 SEP 9 OCT 10 NOV 11 DEC 12 );
app_year/A4=HNAME(STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_DATE, 'YEAR', app_year);
percent/P9%=STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM;
NEW_DAY_TIME/HMTDYYIA=HGETC(8, NEW_DAY_TIME);
TRANSFCNTR/I5=
IF STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_CODE
EQ 'T' AND STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM NE LAST
STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM THEN 1 ELSE 0;
NEWSTDCNTR/I5=
IF STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_CODE
EQ 'N' AND STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM NE LAST
STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM THEN 1 ELSE 0;
RETSTDCNTR/I5=
IF STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_CODE
EQ 'R' AND STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM NE LAST
STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM THEN 1 ELSE 0;
MYCNTR/I5=
IF STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM
EQ LAST STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM
THEN 0 ELSE 1;
HSCNTR/I5=
IF STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_CODE
EQ 'H' AND STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM NE LAST
STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM THEN 1 ELSE 0;
END
-***TABLE FILE FOR GRAPH***
TABLE FILE STUDENT_APPL_HISTORY_DIM
SUM
'CNT.DST.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM' AS 'CNT_PIDMS'
'PCT.CNT.STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent' AS ''
BY 'STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.STUDENT_TYPE_DESC' AS ''
ON TABLE SUBHEAD
"Applicants by Student Type"
" "
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.app_mon_int LE &app_mon_int.(<January,1>,<February,2>,<March,3>,<April,4>,<May,5>,<June,6>,<July,7>,<August,8>,<September,9>,<October,10>,<November,11>,<December,12>).app_mon_int.;
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.APPLICATION_TERM_CODE EQ '&APPLICATION_TERM_CODE';
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.app_year EQ '&app_year';
WHERE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PROGRAM_OF_STUDY_CODE NE 'CD';
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.PIDM STUDENT_APPL_HISTORY_DIM.STUDENT_APPL_HISTORY_DIM.percent AS 'Total'
ON TABLE HOLD AS STYPEHOLD FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = kvcc_wf_no_logo,
$
TYPE=REPORT,
GRID=OFF,
$
TYPE=DATA,
BACKCOLOR=( 'WHITE' RGB(230 230 230) ),
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(230 230 230),
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(230 230 230),
$
ENDSTYLE
END
DEFINE FILE STYPEHOLD
PERCENT/P9%=CNT_PIDMS;
NEW_DAY_TIME/HMTDYYIA=HGETC(8, NEW_DAY_TIME);
END
-***GRAPH***
GRAPH FILE STYPEHOLD
SUM PCT.STYPEHOLD.STYPEHOL.PERCENT AS ''
BY STYPEHOLD.STYPEHOL.STUDENT_TYPE_DESC
ON GRAPH SET LOOKGRAPH PIEMULTP
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT GIF
ON GRAPH SET GRAPHSTYLE *
setFontName(getPieSliceLabel(),"Verdana");
setFontName(getPieLabel(),"Verdana");
setFontSize(getPieLabel(),12);
setPlaceResize(getPieSliceLabel(),0);
setFontSizeAbsolute(getPieSliceLabel(),true);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(1);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(2);
setTextFormatPreset(getPieSliceLabel(),1);
setPieRotate(75);
setLegendDisplay(false);
setFootnoteString("Applicants by Student Type");
setTextJustHoriz(getFootnote(),1);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),12);
setFontStyle(getFootnote(),0);
setTextRotation(getFootnote(),0);
setTextWrap(getFootnote(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontStyle(getY1Label(),2);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setFontSizeAbsolute(getO1Label(),true);
setFontStyle(getO1Label(),1);
setTemplateFile("/images/tdg/template/IBITrueColors.txt");
setPlaceResize(getFootnote(),0);
setPlaceRotate(getFootnote(),0);
setPlaceAlign(getFootnote(),0);
setPlaceWordWrap(getFootnote(),0);
setFillColor (getChartBackground(), new Color (241, 241, 241));
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
$
ENDSTYLE
END