Menu
▾
▴
[Rlib-devel] rlib anomoly.
|
From: Louis E D. <lou...@Co...> - 2011-09-02 16:55:52
|
<?xml version="1.0"?>
<!DOCTYPE report >
<Report fontSize="9" orientation="landscape">
<Alternate>
<NoData>
<Output>
<Line fontSize="12">
<literal>NO DATA</literal>
</Line>
</Output>
</NoData>
</Alternate>
<ReportHeader>
<Output>
</Output>
</ReportHeader>
<Breaks>
<Break name="break0" newpage="no" headernewpage="no" surpressblank="yes">
<BreakHeader>
<Output>
<Line>
<field value="data.DEPTTREE_LEVEL06_DESC" align="left" col="1" bold="Yes" />
</Line>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.DEPTTREE_LEVEL06_DESC" />
</BreakFields>
</Break>
<Break name="break2" newpage="no" headernewpage="no" surpressblank="yes">
<BreakHeader>
<Output>
<Line>
<literal width="1"/>
<field value="data.DEPTTREE_LEVEL07_DESC" align="left" col="2" bold="Yes" />
</Line>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.DEPTTREE_LEVEL07_DESC" />
</BreakFields>
</Break>
<Break name="break3" newpage="no" headernewpage="no" >
<BreakHeader>
<Output>
<Line suppress="(iif(data.DEPTTREE_LEVEL08_DESC != ' ', false, true))">
<literal width="2"/>
<field value="data.DEPTTREE_LEVEL08_DESC" align="left" col="3" bold="Yes" />
</Line>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.DEPTTREE_LEVEL08_DESC" />
</BreakFields>
</Break>
<Break name="break4" newpage="no" headernewpage="no">
<BreakHeader>
<Output>
<Line suppress="(iif(data.DEPTTREE_LEVEL09_DESC != ' ', false, true))">
<literal width="3"/>
<field value="data.DEPTTREE_LEVEL09_DESC" align="left" col="4" bold="Yes" />
</Line>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.DEPTTREE_LEVEL09_DESC"/>
</BreakFields>
</Break>
<Break name="break5" newpage="no" headernewpage="no">
<BreakHeader>
<Output>
<Line suppress="(iif(data.DEPTTREE_LEVEL10_DESC != ' ', false, true))">
<literal width="4"/>
<field value="data.DEPTTREE_LEVEL10_DESC" align="left" col="5" bold="Yes" />
</Line>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.DEPTTREE_LEVEL10_DESC" />
</BreakFields>
</Break>
<Break name="break6" newpage="no" headernewpage="no" suppressblank="yes">
<BreakHeader>
<Output>
<Line>
<field color="'white'" value="data.DEPT_ID" col="6"/>
<field color="'white'" value="data.DEPT_DESC" col="7"/>
</Line>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.DEPT_ID"/>
</BreakFields>
<BreakFooter>
<Output>
<HorizontalLine size="1" bgcolor="'black'" indent="5"/>
<Line>
<literal width="5" />
<literal bold="yes">Department: </literal>
<field bold="yes" value="data.DEPT_ID" />
<literal width="2" />
<field bold="yes" value="data.DEPT_DESC" />
</Line>
<Line>
<literal width="9" />
<literal width="14" />
<literal bold="yes">Total </literal>
<literal width="10" />
<field bold="yes" value="v.dtot_cbudget" width="14" align="right" format="'!$%!.0n'"/>
<field bold="yes" value="v.dtot_tempbudget" width="14" align="right" format="'!$%!.0n'" />
<field bold="yes" value="v.dtot_totbudget" width="14" align="right" format="'!$%!.0n'" />
<field bold="yes" value="v.dtot_exp" width="14" align="right" format="'!$%!.2n'" />
<field bold="yes" value="v.dtot_balbefenc" width="14" align="right" format="'!$%!.2n'" />
<field bold="yes" value="v.dtot_encumb" width="14" align="right" format="'!$%!.2n'" />
<field bold="yes" value="v.dtot_budbalavail" width="15" align="right" format="'!$%!.2n'" />
</Line>
<Line />
</Output>
</BreakFooter>
</Break>
<Break name="break7" newpage="no" headernewpage="no" suppressblank="yes">
<BreakHeader>
<Output>
<Line>
<literal width="5"/>
<literal bold="yes">Program: </literal>
<field value="data.PGM_CODE"/>
<literal width="3"> - </literal>
<field width="20" value="data.PGM_DESC"/>
<literal width="1"/>
<literal bold="yes">Speed Type: </literal>
<field value="data.SPD_KEY_CODE" col="8"/>
<literal width="3"> - </literal>
<field width="30" value="data.SPD_DESC" col="9"/>
<literal width="5"/>
<literal bold="yes">FOPPS Type: </literal>
<field value="data.FOPPS_TYPE" col="10"/>
</Line>
<HorizontalLine size="1" bgcolor="'black'" indent="5"/>
</Output>
</BreakHeader>
<BreakFields>
<BreakField value="data.PGM_CODE"/>
</BreakFields>
<BreakFooter>
<Output>
<HorizontalLine size="1" bgcolor="'black'" indent="24"/>
<Line>
<literal width="10" />
<literal width="14" />
<literal bold="yes">Program Totals: </literal>
<literal width="2" />
<field bold="yes" value="v.ptot_cbudget" width="14" align="right" format="'!$%!.0n'"/>
<field bold="yes" value="v.ptot_tempbudget" width="14" align="right" format="'!$%!.0n'" />
<field bold="yes" value="v.ptot_totbudget" width="14" align="right" format="'!$%!.0n'" />
<field bold="yes" value="v.ptot_exp" width="14" align="right" format="'!$%!.2n'" />
<field bold="yes" value="v.ptot_balbefenc" width="14" align="right" format="'!$%!.2n'" />
<field bold="yes" value="v.ptot_encumb" width="14" align="right" format="'!$%!.2n'" />
<field bold="yes" value="v.ptot_budbalavail" width="15" align="right" format="'!$%!.2n'" />
</Line>
<Line />
</Output>
</BreakFooter>
</Break>
</Breaks>
<Variables>
<Variable name="counter" value="r.detailcnt" type="count" resetonbreak="break7" />
<Variable name="balance_before_enc" value="fxpval(data.AVAILABLE_AMT,0)+fxpval(data.SUM_TOTAL_ENCUMBERED_AMT,0)" type="expression"/>
<Variable name="dtot_cbudget" value="val(data.BUDGET_CONT_AMT)" type="sum" resetonbreak="break6"/>
<Variable name="dtot_tempbudget" value="val(data.BUDGET_TEMP_AMT)" type="sum" resetonbreak="break6"/>
<Variable name="dtot_totbudget" value="val(data.TOTAL_BUDGET_AMT)" type="sum" resetonbreak="break6"/>
<Variable name="dtot_exp" value="val(data.ACTUALS_AMT)" type="sum" resetonbreak="break6"/>
<Variable name="dtot_balbefenc" value="val(data.BAL_BEFORE_ENCUMBERED)" type="sum" resetonbreak="break6"/>
<Variable name="dtot_encumb" value="val(data.TOTAL_ENCUMBERED_AMT)" type="sum" resetonbreak="break6"/>
<Variable name="dtot_budbalavail" value="val(data.AVAILABLE_AMT)" type="sum" resetonbreak="break6"/>
<Variable name="ptot_cbudget" value="val(data.BUDGET_CONT_AMT)" type="sum" resetonbreak="break7"/>
<Variable name="ptot_tempbudget" value="val(data.BUDGET_TEMP_AMT)" type="sum" resetonbreak="break7"/>
<Variable name="ptot_totbudget" value="val(data.TOTAL_BUDGET_AMT)" type="sum" resetonbreak="break7"/>
<Variable name="ptot_exp" value="val(data.ACTUALS_AMT)" type="sum" resetonbreak="break7"/>
<Variable name="ptot_balbefenc" value="val(data.BAL_BEFORE_ENCUMBERED)" type="sum" resetonbreak="break7"/>
<Variable name="ptot_encumb" value="val(data.TOTAL_ENCUMBERED_AMT)" type="sum" resetonbreak="break7"/>
<Variable name="ptot_budbalavail" value="val(data.AVAILABLE_AMT)" type="sum" resetonbreak="break7"/>
<Variable name="grand_tot_cbudget" value="val(data.BUDGET_CONT_AMT)" type="sum" />
<Variable name="grand_tot_tempbudget" value="val(data.BUDGET_TEMP_AMT)" type="sum" />
<Variable name="grand_tot_totbudget" value="val(data.TOTAL_BUDGET_AMT)" type="sum" />
<Variable name="grand_tot_exp" value="val(data.ACTUALS_AMT)" type="sum" />
<Variable name="grand_tot_balbefenc" value="val(data.BAL_BEFORE_ENCUMBERED)" type="sum" />
<Variable name="grand_tot_encumb" value="val(data.TOTAL_ENCUMBERED_AMT)" type="sum" />
<Variable name="grand_tot_budbalavail" value="val(data.AVAILABLE_AMT)" type="sum" />
</Variables>
<Detail>
<FieldHeaders>
<Output>
<Image value="'report_header.jpg'" type="'jpeg'" width="225" height="45" />
<Line />
<Line fontSize="10">
<literal width="42" />
<literal>FY </literal>
<field value="info.fiscal_year" width="6" align="left"/>
<literal>A&S General Fund(10) Account Summary Report</literal>
</Line>
<Line fontSize="10">
<literal width="93" />
<literal width="15" />
<literal width="6" align="left">Page: </literal>
<field value="r.pageno" width="3" align="center"/>
</Line>
<Line fontSize="10">
<literal width="108" />
<literal width="10" align="left">Run Date: </literal>
<field value="info.date" width="10" align="center"/>
</Line>
<Line fontSize="10">
<literal width="50" />
<literal width="50" align="center"> </literal>
<literal width="8" />
<literal width="10" align="left">Run Time: </literal>
<field value="info.time" width="10" align="center"/>
</Line>
<HorizontalLine size="1" bgcolor="'black'"/>
<Line/>
<HorizontalLine size="2" bgcolor="'black'"/>
<Line bgcolor="'0xe5e5e5'">
<literal width="6" />
<literal width="14" col="11" align="left" bold="Yes">Description</literal>
<literal width="22" />
<literal width="14" col="12" align="right" bold="Yes">Continuing</literal>
<literal width="14" col="13" align="right" bold="Yes">Temporary</literal>
<literal width="14" col="14" align="right" bold="Yes">Total</literal>
<literal width="14" col="15" align="right" bold="Yes">Expenditure</literal>
<literal width="14" col="16" align="right" bold="Yes">Balance</literal>
<literal width="14" col="17" align="right" bold="Yes">Encumberance</literal>
<literal width="15" col="18" align="right" bold="Yes">Budget Balance</literal>
</Line>
<Line bgcolor="'0xe5e5e5'">
<literal width="42" />
<literal width="14" col="11" align="right" bold="Yes">Budget</literal>
<literal width="14" col="12" align="right" bold="Yes">Budget</literal>
<literal width="14" col="13" align="right" bold="Yes">Budget</literal>
<literal width="14" col="14" align="right" bold="Yes"></literal>
<literal width="14" col="15" align="right" bold="Yes">Before ENC</literal>
<literal width="14" col="16" align="right" bold="Yes">& PreEncumb</literal>
<literal width="15" col="17" align="right" bold="Yes">Available</literal>
</Line>
</Output>
</FieldHeaders>
<FieldDetails>
<Output>
<Line bgcolor="iif(v.counter%2,'0xCCCCCC','white')">
<literal width="6" bgcolor="'white'" />
<field value="ACCTTREE_LEVEL05_DESC" align="left" col="10" width="34"/>
<literal width="2" />
<field width="14" value="iif(val(data.BUDGET_CONT_AMT), val(data.BUDGET_CONT_AMT), '')" align="right" format="'!$%!.0n'" col="11"/>
<field width="14" value="iif(val(data.BUDGET_TEMP_AMT), val(data.BUDGET_TEMP_AMT), '')" align="right" format="'!$%!.0n'" col="12"/>
<field width="14" value="iif(val(data.TOTAL_BUDGET_AMT), val(data.TOTAL_BUDGET_AMT), '')" align="right" format="'!$%!.0n'" col="13"/>
<field width="14" value="iif(val(data.ACTUALS_AMT), val(data.ACTUALS_AMT), '')" align="right" format="'!$%!.2n'" col="14"/>
<field width="14" value="iif(val(data.BAL_BEFORE_ENCUMBERED), val(data.BAL_BEFORE_ENCUMBERED), '')" format="'!$%!.2n'" align="right" col="15"/>
<field width="14" value="iif(val(data.TOTAL_ENCUMBERED_AMT), val(data.TOTAL_ENCUMBERED_AMT), '')" format="'!$%!.2n'" align="right" col="16"/>
<field width="15" value="iif(val(data.AVAILABLE_AMT), val(data.AVAILABLE_AMT), '')" align="right" format="'!$%!.2n'" col="17"/>
</Line>
</Output>
</FieldDetails>
</Detail>
<PageFooter>
<Output>
<Line>
</Line>
<HorizontalLine size="1" bgcolor="'black'"/>
</Output>
</PageFooter>
<ReportFooter>
<Output>
<Line>
<literal width="10" />
<literal width="17" col="6" align="left" bold="Yes">Totals</literal>
</Line>
<HorizontalLine size="2" bgcolor="'black'" indent="10" />
<Line fontSize="8">
<literal width="47" bgcolor="'white'" />
<field width="16" value="v.grand_tot_cbudget" align="right" format="'!$%!.0n'" />
<field width="16" value="v.grand_tot_tempbudget" align="right" format="'!$%!.0n'" />
<field width="16" value="v.grand_tot_totbudget" align="right" format="'!$%!.0n'" />
<field width="16" value="v.grand_tot_exp" align="right" format="'!$%!.2n'" />
<field width="16" value="v.grand_tot_balbefenc" format="'!$%!.2n'" align="right" />
<field width="16" value="v.grand_tot_encumb" format="'!$%!.2n'" align="right" />
<field width="16" value="v.grand_tot_budbalavail" align="right" format="'!$%!.2n'" />
</Line>
</Output>
</ReportFooter>
</Report> |
