Jump to content
Changes to the Jaspersoft community edition download ×

How can I use the "printWhenExpression"???


2005 IR Help

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...