2005 IR Help Posted August 27, 2006 Share Posted August 27, 2006 By: Delia - ce_medinadelia How can I use the "printWhenExpression"??? 2004-09-20 10:51 Hi all. I have the following problem: I created a variable which calls sumDeducciones and assigns him: Calculation Type:Sum, Reset type:Group, ResetGroup:OtrasDeducciones, Variable Expresion=$F{MONTO}. Then I placed it in the report footer, with the following values Print when expression:new Boolean((($F{COD_CONCEPTO}).intValue()> 500 ) && (($F{COD_CONCEPTO}).intValue()!=683 ) && (($F{COD_CONCEPTO}).intValue()!=688 ) and in ltext field in the part of textfiled expression place:$V{sumDeducciones} My problem is that it omits to the when expression because everything adds up (so... all the deductions, including the total from that I do not need) What can i do??? Please helpme... This is mi code: <?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="pago" columnCount="1" printOrder="Horizontal" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <parameter name="FechaDePago" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["'01-09-2004'"]]></defaultValueExpression> </parameter> <queryString><![CDATA[select a.fecha_proceso,a.CEDULA_TRABAJADOR,a.cod_condicion_cargo, a.NOMBRE_TRABAJADOR, a.FECHA_INGRESO, a.SUELDO_TRABAJADOR, a.NETO_1_QUINCENA,a.NETO_2_QUINCENA,a.TIPO_NOMINA, a.cod_cargo,a.tipo_nomina, b.cod_controla, b.cod_concepto,b.monto,c.descrip_concepto, d.cod_origen,d.descrip_servicio,d.descrip_origen, d.cod_servicio from reportes_nomina_m a, reportes_nomina_d b, origen d, conceptos c where a.cedula_trabajador IN ('2742516','8370534','9224720','13288792') and a.fecha_proceso =($P!{FechaDePago}) and a.cedula_trabajador = b.cedula_trabajador(+) and a.fecha_proceso = b.fecha_proceso(+) and a.cod_condicion_cargo = b.cod_condicion_cargo(+) and b.cod_concepto = c.cod_concepto and a.cod_origen = d.cod_origen and a.cod_servicio = d.cod_servicio and b.monto <> '0' AND b.cod_concepto BETWEEN '001' AND '473' union select a.fecha_proceso,a.CEDULA_TRABAJADOR,a.cod_condicion_cargo, a.NOMBRE_TRABAJADOR, a.FECHA_INGRESO, a.SUELDO_TRABAJADOR, a.NETO_1_QUINCENA,a.NETO_2_QUINCENA,a.TIPO_NOMINA, a.cod_cargo, a.tipo_nomina, e.cod_controla, e.cod_concepto,e.monto, f.descrip_concepto, d.cod_origen,d.descrip_servicio,d.descrip_origen, d.cod_servicio from reportes_nomina_m a, vista_reportes_nomina_d e, origen d,conceptos f,cargos g where a.cedula_trabajador IN ('2742516','8370534','9224720','13288792') and a.fecha_proceso =($P!{FechaDePago}) and a.cedula_trabajador = e.cedula_trabajador(+) and a.fecha_proceso = e.fecha_proceso(+) and a.cod_condicion_cargo = e.cod_condicion_cargo(+) and a.cod_origen = d.cod_origen and a.cod_servicio = d.cod_servicio and e.cod_concepto = f.cod_concepto and e.monto <> '0' AND e.cod_concepto BETWEEN '500' AND '950' and e.cod_concepto = f.cod_concepto ORDER BY 1,2,3,4,13,12]]></queryString> <field name="FECHA_PROCESO" class="java.sql.Timestamp"/> <field name="CEDULA_TRABAJADOR" class="java.lang.Double"/> <field name="COD_CONDICION_CARGO" class="java.lang.Double"/> <field name="NOMBRE_TRABAJADOR" class="java.lang.String"/> <field name="FECHA_INGRESO" class="java.sql.Timestamp"/> <field name="SUELDO_TRABAJADOR" class="java.lang.Double"/> <field name="NETO_1_QUINCENA" class="java.lang.Double"/> <field name="NETO_2_QUINCENA" class="java.lang.Double"/> <field name="TIPO_NOMINA" class="java.lang.String"/> <field name="COD_CARGO" class="java.lang.Double"/> <field name="COD_CONTROLA" class="java.lang.Double"/> <field name="COD_CONCEPTO" class="java.lang.Double"/> <field name="MONTO" class="java.lang.Double"/> <field name="DESCRIP_CONCEPTO" class="java.lang.String"/> <field name="COD_ORIGEN" class="java.lang.Double"/> <field name="DESCRIP_SERVICIO" class="java.lang.String"/> <field name="DESCRIP_ORIGEN" class="java.lang.String"/> <field name="COD_SERVICIO" class="java.lang.Double"/> <variable name="fechaCalculo" class="java.lang.String" resetType="Report" calculation="Nothing"> <variableExpression><![CDATA["'01/09/2004'"]]></variableExpression> </variable> <variable name="SumQuincena" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{NETO_1_QUINCENA}]]></variableExpression> </variable> <variable name="sumDeducciones" class="java.lang.Double" resetType="Group" resetGroup="cedula_trabajador" calculation="Sum"> <variableExpression><![CDATA[$F{MONTO}]]></variableExpression> <initialValueExpression><![CDATA[new Double(0)]]></initialValueExpression> </variable> <group name="cedula_trabajador" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{CEDULA_TRABAJADOR}]]></groupExpression> <groupHeader> <band height="136" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="52" y="3" width="215" height="32" forecolor="#666666" backcolor="#FFFFFF" key="staticText-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="9" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Ministerio del Trabajo Instituto Venezolano de los Seguros Sociales División de Servicios Administrativos ]]></text> </staticText> <image scaleImage="FillFrame" vAlign="Top" hAlign="Left" isUsingCache="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="5" y="1" width="45" height="35" forecolor="#000000" backcolor="#FFFFFF" key="image-2" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> <imageExpression class="java.lang.String"><![CDATA["C:\jakarta-tomcat-4.1.30\webapps\pagoNomina\images\logopeq_ivss.gif"]]></imageExpression> </image> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="494" y="12" width="33" height="19" forecolor="#999999" backcolor="#FFFFFF" key="textField-3" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Pag " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="2" y="1" width="531" height="0" forecolor="#666666" backcolor="#FFFFFF" key="line-2" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="2Point" fill="Solid" /> </line> <staticText> <reportElement mode="Opaque" x="1" y="85" width="36" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-23" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[sERV.]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="35" y="85" width="62" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-24" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[ N° CARGO]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="97" y="85" width="49" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-25" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[CÉDULA]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="266" y="85" width="188" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-26" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[ FECHA INGRESO]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="146" y="85" width="120" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-27" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[NOMBRES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="454" y="85" width="80" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-29" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Justified" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[ CARGO]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="107" y="34" width="295" height="15" forecolor="#999999" backcolor="#FFFFFF" key="staticText-30" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[NÓMINA GENERAL DE PAGO: GASTOS ADMINISTRATIVOS]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="416" y="33" width="44" height="17" forecolor="#999999" backcolor="#FFFFFF" key="staticText-33" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Para el:]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="dd/MM/yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="459" y="32" width="73" height="18" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_PROCESO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="325" y="69" width="203" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="9" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIP_ORIGEN}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="###0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="97" y="98" width="49" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" printWhenGroupChanges="cedula_trabajador" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{CEDULA_TRABAJADOR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="147" y="98" width="196" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_TRABAJADOR}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="343" y="98" width="78" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INGRESO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="###0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="2" y="72" width="52" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{COD_ORIGEN}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="55" y="67" width="11" height="13" forecolor="#000000" backcolor="#FFFFFF" key="staticText-45" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[_]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="68" y="71" width="100" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIP_SERVICIO}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="1" y="111" width="327" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-50" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[ASIGNACIONES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="326" y="111" width="109" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-51" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[ DEDUCCIONES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="435" y="111" width="98" height="12" forecolor="#FFFFFF" backcolor="#666666" key="staticText-52" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[NETO]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="###0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="3" y="98" width="33" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{COD_SERVICIO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="###0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="38" y="98" width="56" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{COD_CARGO}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="85" y="123" width="110" height="13" forecolor="#333333" backcolor="#FFFFFF" key="staticText-53" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[sUELDO MENSUAL]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="257" y="48" width="62" height="13" forecolor="#999999" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_NOMINA}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="233" y="123" width="91" height="13" forecolor="#330033" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" printWhenGroupChanges="cedula_trabajador" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{SUELDO_TRABAJADOR}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="190" y="48" width="67" height="13" forecolor="#999999" backcolor="#FFFFFF" key="staticText-54" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[PERSONAL]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="60" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="91" y="45" width="157" height="15" forecolor="#999999" backcolor="#FFFFFF" key="staticText-39" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Total por empleado Bs:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="423" y="10" width="108" height="15" forecolor="#666666" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{NETO_1_QUINCENA}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="#,##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="423" y="26" width="108" height="15" forecolor="#666666" backcolor="#FFFFFF" key="textField" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{NETO_2_QUINCENA}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="91" y="13" width="157" height="15" forecolor="#999999" backcolor="#FFFFFF" key="staticText-35" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Neto 1ra. Quincena:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="91" y="29" width="157" height="15" forecolor="#999999" backcolor="#FFFFFF" key="staticText-36" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Neto 2da. Quincena:]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="423" y="42" width="108" height="15" forecolor="#666666" backcolor="#FFFFFF" key="textField-7" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[new Double(($F{NETO_1_QUINCENA}.doubleValue()) + ($F{NETO_2_QUINCENA}).doubleValue())]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="92" y="0" width="157" height="15" forecolor="#999999" backcolor="#FFFFFF" key="staticText-55" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Otras Deducciones:]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="254" y="4" width="85" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField-23" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[new Boolean((($F{COD_CONCEPTO}).intValue()> 500 ) && (($F{COD_CONCEPTO}).intValue()!=683 ) && (($F{COD_CONCEPTO}).intValue()!=688 ))]]></printWhenExpression> </reportElement> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{sumDeducciones}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <group name="OtrasDeducciones" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" > <groupExpression><![CDATA[$F{MONTO}]]></groupExpression> <groupHeader> <band height="13" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <background> <band height="742" isSplitAllowed="true" > <image scaleImage="FillFrame" vAlign="Top" hAlign="Left" isUsingCache="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="169" y="129" width="238" height="133" forecolor="#000000" backcolor="#FFFFFF" key="image-3" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> <imageExpression class="java.lang.String"><![CDATA["C:\jakarta-tomcat-4.1.30\webapps\pagoNomina\images\fondoivss.gif"]]></imageExpression> </image> <image scaleImage="FillFrame" vAlign="Top" hAlign="Left" isUsingCache="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="158" y="386" width="238" height="133" forecolor="#000000" backcolor="#FFFFFF" key="image-4" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> <imageExpression class="java.lang.String"><![CDATA["C:\jakarta-tomcat-4.1.30\webapps\pagoNomina\images\fondoivss.gif"]]></imageExpression> </image> </band> </background> <title> <band height="0" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="3" y="-1001" width="96" height="16" forecolor="#0033CC" backcolor="#CCCCFF" key="staticText" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Times-Roman" pdfFontName="Times-Roman" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Caja Regional:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="3" y="-1001" width="96" height="16" forecolor="#0033CC" backcolor="#CCCCFF" key="staticText" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Times-Roman" pdfFontName="Times-Roman" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Caja Regional:]]></text> </staticText> </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > <staticText> <reportElement mode="Opaque" x="3" y="-801" width="96" height="16" forecolor="#0033CC" backcolor="#CCCCFF" key="staticText" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Times-Roman" pdfFontName="Times-Roman" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Caja Regional:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="3" y="-801" width="96" height="16" forecolor="#0033CC" backcolor="#CCCCFF" key="staticText" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Times-Roman" pdfFontName="Times-Roman" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" /> </textElement> <text><![CDATA[Caja Regional:]]></text> </staticText> </band> </columnHeader> <detail> <band height="37" isSplitAllowed="true" > <textField isStretchWithOverflow="true" pattern="###0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="47" y="0" width="19" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField-8" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[(new Boolean(($F{COD_CONTROLA}).intValue() == 0))]]></printWhenExpression> </reportElement> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{COD_CONTROLA}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" pattern="###0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Opaque" x="65" y="0" width="32" height="13" forecolor="#000000" backcolor="#FFFFFF" key="textField-9" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression><![CDATA[(new Boolean(($F{COD_CONTROLA}).intValue() == 0))]]></printWhenExpression> </reportElement> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$F{COD_CONCEPTO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true&quo Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now