-* File board_report_pdf -* Default Mode: ResourceLayout SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT PDF UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', 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='report1', TOC-LEVEL=2, POSITION=(0.516 1.144), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.479in; HEIGHT: 2.705in; OVERFLOW: auto; TOP: 1.144in; LEFT: 0.516in', $ COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 3.849), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.5in; HEIGHT: 3.024in; OVERFLOW: auto; TOP: 3.849in; LEFT: 0.5in', $ COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.521 6.874), DIMENSION=(7.483 3.537), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.483in; HEIGHT: 3.537in; OVERFLOW: auto; TOP: 6.874in; LEFT: 0.521in', $ OBJECT=STRING, NAME='text1', TEXT='<font face="ARIAL" size=10><center>[b]RECOMMENDED PERSONNEL ACTIONS<BR>Board of Trustees Meeting<BR>May 7, 2012[/b]</center></font>', POSITION=(0.500 0.500), MARKUP=ON, WRAP=ON, DIMENSION=(7.438 0.625), METADATA='', $ OBJECT=STRING, NAME='text2', TEXT='<font face="ARIAL" size=10>[b]DISTRICT[/b]</font>', POSITION=(0.500 1.144), MARKUP=ON, WRAP=ON, DIMENSION=(0.792 0.418), METADATA='', $ OBJECT=STRING, NAME='text3', TEXT='<font face="ARIAL" size=10>[b]New Employees[/b]</font>', POSITION=(0.500 1.542), MARKUP=ON, WRAP=ON, DIMENSION=(1.313 0.292), METADATA='', $ OBJECT=STRING, NAME='text4', TEXT='<font face="ARIAL" size=10>[b]Employee Changes[/b]</font>', POSITION=(0.500 4.167), MARKUP=ON, WRAP=ON, DIMENSION=(1.542 0.292), METADATA='', $ OBJECT=STRING, NAME='text5', TEXT='<font face="ARIAL" size=10>[b]Terminations (Includes terminations, resignations, and retirements)[/b]</font>', POSITION=(0.510 6.977), MARKUP=ON, WRAP=ON, DIMENSION=(4.468 0.207), METADATA='', $ 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,', $ OBJECT=STRING, NAME='text6', TEXT='<font face="ARIAL" size=10>[b]CENTRAL [/b]</font>', POSITION=(0.510 0.552), MARKUP=ON, WRAP=ON, DIMENSION=(0.813 0.417), METADATA='', $ OBJECT=STRING, NAME='text7', TEXT='<font face="ARIAL" size=10>[b]New Employees[/b]</font>', POSITION=(0.510 0.977), MARKUP=ON, WRAP=ON, DIMENSION=(1.760 0.311), METADATA='', $ COMPONENT='report4', TEXT='report4', TOC-LEVEL=2, POSITION=(0.500 0.879), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.5in; HEIGHT: 2.188in; OVERFLOW: auto; TOP: 0.879in; LEFT: 0.5in', $ OBJECT=STRING, NAME='text8', TEXT='<font face="ARIAL" size=10>[b]Employee Changes[/b]</font>', POSITION=(0.520 3.271), MARKUP=ON, WRAP=ON, DIMENSION=(1.352 0.312), METADATA='', $ COMPONENT='report5', TEXT='report5', TOC-LEVEL=2, POSITION=(0.521 3.390), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.291in; HEIGHT: 4.569in; OVERFLOW: auto; TOP: 3.39in; LEFT: 0.521in', $ END SET COMPONENT='report1' -*component_type report -DEFAULT &beg_date = '01-FEB-2012' -DEFAULT &end_date = '31-MAR-2012' ENGINE SQLORA SET DEFAULT_CONNECTION PROD SQL SQLORA PREPARE SQLOUT FOR select spriden_pidm as PIDM,nbrjobs_status AS STAT, CASE WHEN PEBEMPL_FIRST_HIRE_DATE between '&beg_date' and '&end_date' THEN 'NEWHIRE' ELSE 'CHANGE' END STATUS, spriden_last_name || ' '|| spriden_first_name || ', '|| nbrjobs_desc || '/'|| ftvorgn_title AS JB,' ,at an hourly rate of $'|| trunc(nbrjobs_reg_rate,2) AS PT, ', at a rate of $'|| nbrjobs_assgn_salary||' per month ' AS FT, ', effective as of ' || (TRUNC(nbrjobs_effective_date)) AS LINE,pebempl_internal_ft_pt_ind,pebempl_camp_code AS CMPCD from nbrjobs o,spriden,nbrbjob,ftvorgn,pebempl where nbrjobs_effective_date = (select max(nbrjobs_effective_date) from nbrjobs i where i.nbrjobs_pidm = o.nbrjobs_pidm and i.nbrjobs_posn = o.nbrjobs_posn and i.nbrjobs_suff = o.nbrjobs_suff and i.nbrjobs_effective_date between '&beg_date' and '&end_date' and trunc(i.nbrjobs_effective_date) <> '01-APR-12') and pebempl_pidm (+)= spriden_pidm and pebempl_pidm = nbrjobs_pidm and spriden_change_ind is null and nbrbjob_pidm = nbrjobs_pidm and nbrbjob_contract_type = 'P' and pebempl_camp_code = 'D' and nbrbjob_posn = nbrjobs_posn and nbrbjob_suff = nbrjobs_suff and nbrjobs_orgn_code_ts = ftvorgn_orgn_code and (ftvorgn_eff_date < '&end_date' and ftvorgn_nchg_date > '&end_date') order by spriden_last_name,STATUS ; END DEFINE FILE SQLOUT Part_time/A200=IF PEBEMPL_INTERNAL_FT_PT_IND = 'F' THEN JB || FT || LINE ELSE JB || PT || LINE; END TABLE FILE SQLOUT PRINT Part_time AS '' BY STATUS NOPRINT WHERE STATUS EQ 'NEWHIRE' ON STATUS SUBHEAD " " ON STATUS PAGE-BREAK ON TABLE SUBHEAD "" HEADING "" ON TABLE SET LINES 999999 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=16, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=SUBFOOT, SIZE=10, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ TYPE=REPORT, COLUMN=N1, WRAP=0.680556, $ ENDSTYLE END SET COMPONENT='report2' -*component_type report -DEFAULT &beg_date = '01-FEB-2012' -DEFAULT &end_date = '31-MAR-2012' ENGINE SQLORA SET DEFAULT_CONNECTION PROD SQL SQLORA PREPARE SQLOUT FOR select spriden_pidm as PIDM,nbrjobs_status AS STAT, CASE WHEN PEBEMPL_FIRST_HIRE_DATE between '&beg_date' and '&end_date' THEN 'NEWHIRE' ELSE 'CHANGE' END STATUS, spriden_last_name || ' '|| spriden_first_name || ', '|| nbrjobs_desc || '/'|| ftvorgn_title AS JB,' ,at an hourly rate of $'|| trunc(nbrjobs_reg_rate,2) AS PT, ', at a rate of $'|| nbrjobs_assgn_salary||' per month ' AS FT, ', effective as of ' || (TRUNC(nbrjobs_effective_date)) AS LINE,pebempl_internal_ft_pt_ind,pebempl_camp_code AS CMPCD from nbrjobs o,spriden,nbrbjob,ftvorgn,pebempl where nbrjobs_effective_date = (select max(nbrjobs_effective_date) from nbrjobs i where i.nbrjobs_pidm = o.nbrjobs_pidm and i.nbrjobs_posn = o.nbrjobs_posn and i.nbrjobs_suff = o.nbrjobs_suff and i.nbrjobs_effective_date between '&beg_date' and '&end_date' and trunc(i.nbrjobs_effective_date) <> '01-APR-12') and pebempl_pidm (+)= spriden_pidm and pebempl_pidm = nbrjobs_pidm and spriden_change_ind is null and nbrbjob_pidm = nbrjobs_pidm and nbrbjob_contract_type = 'P' and pebempl_camp_code = 'D' and nbrbjob_posn = nbrjobs_posn and nbrbjob_suff = nbrjobs_suff and nbrjobs_orgn_code_ts = ftvorgn_orgn_code and (ftvorgn_eff_date < '&end_date' and ftvorgn_nchg_date > '&end_date') order by spriden_last_name,STATUS ; END DEFINE FILE SQLOUT Part_time/A200=IF PEBEMPL_INTERNAL_FT_PT_IND = 'F' THEN JB || FT || LINE ELSE JB || PT || LINE; END TABLE FILE SQLOUT PRINT Part_time AS '' BY STATUS NOPRINT WHERE STATUS EQ 'CHANGE' ON STATUS SUBHEAD " " ON STATUS PAGE-BREAK ON TABLE SUBHEAD "" HEADING "" ON TABLE SET LINES 999999 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=16, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=SUBFOOT, SIZE=10, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ TYPE=REPORT, COLUMN=N1, WRAP=0.680556, $ ENDSTYLE END SET COMPONENT='report3' -*component_type report -DEFAULT &beg_date = '01-FEB-2012' -DEFAULT &end_date = '31-MAR-2012' ENGINE SQLORA SET DEFAULT_CONNECTION PROD SQL SQLORA PREPARE SQLOUT FOR select spriden_pidm as PIDM,nbrjobs_status AS STAT, CASE WHEN PEBEMPL_FIRST_HIRE_DATE between '&beg_date' and '&end_date' THEN 'NEWHIRE' ELSE 'CHANGE' END STATUS, spriden_last_name || ' '|| spriden_first_name || ', '|| nbrjobs_desc || '/'|| ftvorgn_title AS JB,' ,at an hourly rate of $'|| trunc(nbrjobs_reg_rate,2) AS PT, ', at a rate of $'|| nbrjobs_assgn_salary||' per month ' AS FT, ', effective as of ' || (TRUNC(nbrjobs_effective_date)) AS LINE,pebempl_internal_ft_pt_ind,pebempl_camp_code AS CMPCD from nbrjobs o,spriden,nbrbjob,ftvorgn,pebempl where nbrjobs_effective_date = (select max(nbrjobs_effective_date) from nbrjobs i where i.nbrjobs_pidm = o.nbrjobs_pidm and i.nbrjobs_posn = o.nbrjobs_posn and i.nbrjobs_suff = o.nbrjobs_suff and i.nbrjobs_effective_date between '&beg_date' and '&end_date' and trunc(i.nbrjobs_effective_date) <> '01-APR-12') and pebempl_pidm (+)= spriden_pidm and pebempl_pidm = nbrjobs_pidm and spriden_change_ind is null and nbrbjob_pidm = nbrjobs_pidm and nbrbjob_contract_type = 'P' and pebempl_camp_code = 'D' and nbrbjob_posn = nbrjobs_posn and nbrbjob_suff = nbrjobs_suff and nbrjobs_orgn_code_ts = ftvorgn_orgn_code and (ftvorgn_eff_date < '&end_date' and ftvorgn_nchg_date > '&end_date') order by spriden_last_name,STATUS ; END DEFINE FILE SQLOUT Part_time/A200=IF PEBEMPL_INTERNAL_FT_PT_IND = 'F' THEN JB || FT || LINE ELSE JB || PT || LINE; Term/A200=IF STAT = 'T' THEN JB || ' termination ' || LINE ELSE JB || ' termination ' || LINE; END TABLE FILE SQLOUT PRINT Term AS '' BY STATUS NOPRINT WHERE STAT EQ 'T'; ON STATUS SUBHEAD " " ON STATUS PAGE-BREAK ON TABLE SUBHEAD "" HEADING "" ON TABLE SET LINES 999999 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=16, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=SUBFOOT, SIZE=10, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ TYPE=REPORT, COLUMN=N1, WRAP=0.680556, $ ENDSTYLE END SET COMPONENT='report4' -*component_type report -DEFAULT &beg_date = '01-FEB-2012' -DEFAULT &end_date = '31-MAR-2012' ENGINE SQLORA SET DEFAULT_CONNECTION PROD SQL SQLORA PREPARE SQLOUT FOR select spriden_pidm as PIDM,nbrjobs_status AS STAT, CASE WHEN PEBEMPL_FIRST_HIRE_DATE between '&beg_date' and '&end_date' THEN 'NEWHIRE' ELSE 'CHANGE' END STATUS, spriden_last_name || ' '|| spriden_first_name || ', '|| nbrjobs_desc || '/'|| ftvorgn_title AS JB,' ,at an hourly rate of $'|| trunc(nbrjobs_reg_rate,2) AS PT, ', at a rate of $'|| nbrjobs_assgn_salary||' per month ' AS FT, ', effective as of ' || (TRUNC(nbrjobs_effective_date)) AS LINE,pebempl_internal_ft_pt_ind,pebempl_camp_code AS CMPCD from nbrjobs o,spriden,nbrbjob,ftvorgn,pebempl where nbrjobs_effective_date = (select max(nbrjobs_effective_date) from nbrjobs i where i.nbrjobs_pidm = o.nbrjobs_pidm and i.nbrjobs_posn = o.nbrjobs_posn and i.nbrjobs_suff = o.nbrjobs_suff and i.nbrjobs_effective_date between '&beg_date' and '&end_date' and trunc(i.nbrjobs_effective_date) <> '01-APR-12') and pebempl_pidm (+)= spriden_pidm and pebempl_pidm = nbrjobs_pidm and spriden_change_ind is null and nbrbjob_pidm = nbrjobs_pidm and nbrbjob_contract_type = 'P' and pebempl_camp_code = 'C' and nbrbjob_posn = nbrjobs_posn and nbrbjob_suff = nbrjobs_suff and nbrjobs_orgn_code_ts = ftvorgn_orgn_code and (ftvorgn_eff_date < '&end_date' and ftvorgn_nchg_date > '&end_date') order by spriden_last_name,STATUS ; END DEFINE FILE SQLOUT Part_time/A200=IF PEBEMPL_INTERNAL_FT_PT_IND = 'F' THEN JB || FT || LINE ELSE JB || PT || LINE; END TABLE FILE SQLOUT PRINT Part_time AS '' BY STATUS NOPRINT WHERE STATUS EQ 'NEWHIRE' WHERE STAT EQ 'A'; ON STATUS SUBHEAD " " ON STATUS PAGE-BREAK ON TABLE SUBHEAD "" HEADING "" ON TABLE SET LINES 999999 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=16, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=SUBFOOT, SIZE=10, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ TYPE=REPORT, COLUMN=N1, WRAP=0.680556, $ ENDSTYLE END SET COMPONENT='report5' -*component_type report -DEFAULT &beg_date = '01-FEB-2012' -DEFAULT &end_date = '31-MAR-2012' ENGINE SQLORA SET DEFAULT_CONNECTION PROD SQL SQLORA PREPARE SQLOUT FOR select spriden_pidm as PIDM,nbrjobs_status AS STAT, CASE WHEN PEBEMPL_FIRST_HIRE_DATE between '&beg_date' and '&end_date' THEN 'NEWHIRE' ELSE 'CHANGE' END STATUS, spriden_last_name || ' '|| spriden_first_name || ', '|| nbrjobs_desc || '/'|| ftvorgn_title AS JB,' ,at an hourly rate of $'|| trunc(nbrjobs_reg_rate,2) AS PT, ', at a rate of $'|| nbrjobs_assgn_salary||' per month ' AS FT, ', effective as of ' || (TRUNC(nbrjobs_effective_date)) AS LINE,pebempl_internal_ft_pt_ind,pebempl_camp_code AS CMPCD from nbrjobs o,spriden,nbrbjob,ftvorgn,pebempl where nbrjobs_effective_date = (select max(nbrjobs_effective_date) from nbrjobs i where i.nbrjobs_pidm = o.nbrjobs_pidm and i.nbrjobs_posn = o.nbrjobs_posn and i.nbrjobs_suff = o.nbrjobs_suff and i.nbrjobs_effective_date between '&beg_date' and '&end_date' and trunc(i.nbrjobs_effective_date) <> '01-APR-12') and pebempl_pidm (+)= spriden_pidm and pebempl_pidm = nbrjobs_pidm and spriden_change_ind is null and nbrbjob_pidm = nbrjobs_pidm and nbrbjob_contract_type = 'P' and pebempl_camp_code = 'C' and nbrbjob_posn = nbrjobs_posn and nbrbjob_suff = nbrjobs_suff and nbrjobs_orgn_code_ts = ftvorgn_orgn_code and (ftvorgn_eff_date < '&end_date' and ftvorgn_nchg_date > '&end_date') order by spriden_last_name,STATUS ; END DEFINE FILE SQLOUT Part_time/A200=IF PEBEMPL_INTERNAL_FT_PT_IND = 'F' THEN JB || FT || LINE ELSE JB || PT || LINE; END TABLE FILE SQLOUT PRINT Part_time AS '' BY STATUS NOPRINT WHERE STATUS EQ 'CHANGE' WHERE STAT EQ 'A'; ON STATUS SUBHEAD " " ON STATUS PAGE-BREAK ON TABLE SUBHEAD "" HEADING "" ON TABLE SET LINES 999999 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, SIZE=16, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, $ TYPE=SUBFOOT, SIZE=10, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ TYPE=REPORT, COLUMN=N1, WRAP=0.680556, $ ENDSTYLE END COMPOUND ENDThis message has been edited. Last edited by: Kerry,
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
-HTMLFORM BEGIN <HTML> <SPAN style="Z-INDEX: 1; POSITION: absolute; TEXT-ALIGN: center; WIDTH: 410px; FONT-FAMILY: Times New Roman; HEIGHT: 131px; FONT-SIZE: 14pt; TOP: 40px; LEFT: 320px" id=text1 tabIndex=1 persistentuniqueid="compUid_2"><B>RECOMMENDED PERSONNEL ACTIONS <BR>Board of Trustees Meeting <BR>May 7,2012 <BR></B></SPAN> <BODY> <BR> !IBI.AMP.DATE; <BR> !IBI.FIL.DISTRICT; <BR> !IBI.FIL.DISTT; <BR> !IBI.FIL.CENTRAL; <BR> !IBI.FIL.CENTT; <BR> !IBI.FIL.NORTH; <BR> !IBI.FIL.NORTHT; <BR> !IBI.FIL.SOUTH; <BR> !IBI.FIL.SOUTHT; </BODY> </HTML>
quote:Originally posted by susannah:
nb. you can't use dialog manager GOTO's with a compound pdf setup. whisky tango foxtrot!
TABLE FILE CAR LIST COUNTRY CAR MODEL IF RECORDLIMIT EQ 11 ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * COLOR=RED,$ ENDSTYLE END TABLE FILE BOTSCHED LIST SCHEDULEID PACKETID ON TABLE PCHOLD FORMAT PDF CLOSE ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * COLOR=GREEN,$ ENDSTYLE END
SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT PDF UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', 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='report1', TOC-LEVEL=2, POSITION=(0.832 0.625), DIMENSION=(6.870 2.080), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 6.87in; HEIGHT: 2.08in; OVERFLOW: auto; TOP: 0.625in; LEFT: 0.832in', $ COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.832 2.810), DIMENSION=(* *), METADATA='Z-INDEX: 103; POSITION: absolute; WIDTH: 6.876in; HEIGHT: 7.603in; OVERFLOW: auto; TOP: 2.81in; LEFT: 0.832in', $ END SET COMPONENT='report1' -*component_type report TABLE FILE CAR LIST COUNTRY CAR MODEL IF RECORDLIMIT EQ 5 ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * COLOR=RED,$ ENDSTYLE END SET COMPONENT='report2' -*component_type report TABLE FILE BOTSCHED LIST SCHEDULEID PACKETID ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * COLOR=GREEN,$ ENDSTYLE END COMPOUND END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
quote:Originally posted by j.gross:
Dan -
You're going to the well too many times -- The SQL SELECTs in reports 1, 2, and 3 are identical. Ditto for 4 and 5.
As Susan suggested, you should extract the SQL output to HOLD file(s), outside the Compound report structure; and within the Compound structure TABLE or GRAPH against the Hold file(s).
TABLE FILE HOLD_MAIN PRINT 'HOLD_MAIN.HOLD_MAI.Term' AS '' BY 'HOLD_MAIN.HOLD_MAI.STAT' NOPRINT ON TABLE SUBHEAD "Terminations (Includes terminations, resignations, and retirements)" HEADING "" WHERE HOLD_MAIN.HOLD_MAI.CMPCD EQ 'N'; WHERE STAT EQ 'T'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK ON TABLE SET HTMLCSS ON
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |