14bdb8224a5bb68b0bd5b9245c13a159d4823700.svn-base 12.6 KB
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
		 name="PR053"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Landscape"
		 pageWidth="842"
		 pageHeight="595"
		 columnWidth="535"
		 columnSpacing="0"
		 leftMargin="17"
		 rightMargin="17"
		 topMargin="17"
		 bottomMargin="17"
		 whenNoDataType="NoPages"
		 isTitleNewPage="false"
		 isSummaryNewPage="false">
	<variable name="sumIncome" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__memployee9_9summary_inc},"0"))))
]]></variableExpression>	</variable>
	<variable name="sumSoc" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__memployee9_9summary_soc},"0"))))]]></variableExpression>	</variable>
	<variable name="sumPvf_m" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__memployee9_9summary_pvf_m},"0"))))]]></variableExpression>	</variable>
	<variable name="sumInc_tax" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__memployee9_9summary_tax},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula01" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula01},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula02" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula02},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula03" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula03},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula04" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula04},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula05" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula05},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula06" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula06},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula07" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula07},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula08" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula08},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula09" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula09},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula10" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula10},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula11" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula11},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula12" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula12},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula13" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula13},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula14" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula14},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula15" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula15},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula16" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula16},"0"))))]]></variableExpression>	</variable>
	<variable name="sumFormula17" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(String.valueOf(Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula17},"0"))))]]></variableExpression>	</variable>
	<variable name="sumNetincome" class="java.lang.String" resetType="Report" calculation="Nothing">
		<variableExpression><![CDATA[String.valueOf(
	Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula01},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula02},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula03},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula04},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula05},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula06},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula07},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula08},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula09},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula10},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula11},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula12},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula13},"0"))
	+Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula14},"0"))
	-Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula15},"0"))
	-Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula16},"0"))
	-Double.parseDouble(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula17},"0"))
)]]></variableExpression>	</variable>
	<variable name="TOTALBU1" class="java.lang.Integer" resetType="Report" calculation="Count">
		<variableExpression><![CDATA[$F{Memployee__employeeid}]]></variableExpression>	</variable>
	<variable name="TOTALBU2" class="java.lang.Integer" resetType="Report" calculation="Count">
		<variableExpression><![CDATA[$F{Memployee__employeeid}]]></variableExpression>	</variable>
	<variable name="TOTALBU3" class="java.lang.Integer" resetType="Report" calculation="Count">
		<variableExpression><![CDATA[$F{Memployee__employeeid}]]></variableExpression>	</variable>
	<variable name="TOTALBU4" class="java.lang.Integer" resetType="Report" calculation="Count">
	</variable>
	<variable name="TOTALBU5" class="java.lang.Integer" resetType="Report" calculation="Count">
		<variableExpression><![CDATA[$F{Memployee__employeeid}]]></variableExpression>	</variable>
	<variable name="TOTALBRANCH" class="java.lang.Integer" resetType="Report" calculation="Count">
		<variableExpression><![CDATA[$F{Memployee__employeeid}]]></variableExpression>	</variable>
	<variable name="TOTALCOMPANY" class="java.lang.Integer" resetType="Report" calculation="Count">
		<variableExpression><![CDATA[$F{Memployee__employeeid}]]></variableExpression>	</variable>
	<variable name="sumBranch" class="java.lang.Double" resetType="Report" calculation="Sum">
		<variableExpression><![CDATA[Double.valueOf(new com.csc.library.utilities.CheckNull().chkNullString($F{memployee__simtpytran0_rep9_9formula01},"0"))]]></variableExpression>	</variable>
	<variable name="NETINCOME_COMPANY" class="java.lang.String" resetType="Report" calculation="Nothing">
		<variableExpression><![CDATA[String.valueOf(
	Double.parseDouble(String.valueOf($V{sumFormula01}))
	+Double.parseDouble(String.valueOf($V{sumFormula02}))
	+Double.parseDouble(String.valueOf($V{sumFormula03}))
	+Double.parseDouble(String.valueOf($V{sumFormula04}))
	+Double.parseDouble(String.valueOf($V{sumFormula05}))
	+Double.parseDouble(String.valueOf($V{sumFormula06}))
	+Double.parseDouble(String.valueOf($V{sumFormula07}))
	+Double.parseDouble(String.valueOf($V{sumFormula08}))
	+Double.parseDouble(String.valueOf($V{sumFormula09}))
	+Double.parseDouble(String.valueOf($V{sumFormula10}))
	+Double.parseDouble(String.valueOf($V{sumFormula11}))
	+Double.parseDouble(String.valueOf($V{sumFormula12}))
	+Double.parseDouble(String.valueOf($V{sumFormula13}))
	+Double.parseDouble(String.valueOf($V{sumFormula14}))
	-Double.parseDouble(String.valueOf($V{sumFormula15}))
	-Double.parseDouble(String.valueOf($V{sumFormula16}))
	-Double.parseDouble(String.valueOf($V{sumFormula17}))
)]]></variableExpression>	</variable>
		<background>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</background>
		<title>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</title>
		<pageHeader>
			<band height="145"  isSplitAllowed="true" >
			</band>
		</pageHeader>
		<columnHeader>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</columnHeader>
		<detail>
			<band height="19"  isSplitAllowed="true" >
			</band>
		</detail>
		<columnFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</columnFooter>
		<pageFooter>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</pageFooter>
		<summary>
			<band height="66"  isSplitAllowed="true" >
			</band>
		</summary>
</jasperReport>