gerramirez

i have the expretion: $F{NROLIGNE} == null? $V{COMMT}: $V{COMMT} + $F{COMMENT} but print: FECHAMATRI CULACIANRO. VOL.TIPO VOL.APDAPASTDATDATASTACOD. RETA1TPS. RET1COD. RETA2TPS. RET2COD. RETA3TPS. RET3CTE 2019/01/01XA-MKHTAO927 XTAMEXZIH16:0015:4516:5017:15 0 0 0MEDLEG / MEDLEG OCHOA 0TI.NAL.13 INT.00 CNX.NAL.04 INT.00 R.17 I.00 F.00 TLLS.17 *EMV 2019/01/01XA-MKHTAO927 XTAMEXZIH16:0015:4516:5017:15 0 0 0MEDLEG / MEDLEG OCHOA 0TI.NAL.13 INT.00 CNX.NAL.04 INT.00 R.17 I.00 F.00 TLLS.17 *EMV TAO648/4 2019/01/01XA-MKHTAO927 XTAMEXZIH16:0015:4516:5017:15 0 0 0MEDLEG / MEDLEG OCHOA 0TI.NAL.13 INT.00 CNX.NAL.04 INT.00 R.17 I.00 F.00 TLLS.17 *EMV TAO648/4 OPS IVAN//01AEROCAR//CP1545//T9 I needed print only the last record whit all concat in last colum. Can you help me?

Ho to make $X{[bETWEEN] with parameter of type date range AND $X{EQUAL, "FRRM"."AVNUMAP", AVION_SERIE} AND $X{BETWEEN, DATE, FECHA_INICIAL, FECHA_FINAL} thats righ?

i want conver $F{RMJJ} + "/" + $F{RMMM} + "/" + $F{RMA4} to dd/MM/yyyy I have $P{DATE_FROM} and $P{DATE_TO} What is the better way to convert. thanks

How set up default_master.properties with com.ibm.as400.access.AS400JDBCDriver

Establezca el tipo de origen de datos y sus propiedadesSeleccione primero el tipo de origen de datos que desea agregar y, a continuación, introduzca los valores de propiedad necesarios.Entradas de usuarioTipo: Origen de datos de AWS Origen de datos de bean Origen de datos de Cassandra Origen de datos de diagnóstico interno Origen de datos JDBC Origen de datos JDBC MongoDB Origen de datos JNDI Origen de datos MongoDB Origen de datos SQL de Azure Origen de datos virtual Propiedades de accesoControlador JDBC: IBM DB2 (com.ibm.db2.jcc.DB2Driver) MySQL (org.mariadb.jdbc.Driver) Oracle (oracle.jdbc.OracleDriver) PostgreSQL (org.postgresql.Driver) NO INSTALADO: Informix (com.informix.jdbc.IfxDriver) NO INSTALADO: Ingres (com.ingres.jdbc.IngresDriver) NO INSTALADO: MS SQL Server 2000 (com.microsoft.jdbc.sqlserver.SQLServerDriver) NO INSTALADO: MS SQL Server 2005 (com.microsoft.sqlserver.jdbc.SQLServerDriver) NO INSTALADO: MySQL (com.mysql.jdbc.Driver) NO INSTALADO: Sybase jConnect (com.sybase.jdbc4.jdbc.SybDriver) NO INSTALADO: Vertica (com.vertica.jdbc.Driver) NO INSTALADO: com.ibm.as400.access.AS400JDBCDriver (com.ibm.as400.access.AS400JDBCDriver) Otro... Agregar controlador... URL (obligatorio):Consejo: jdbc:postgresql://localhost:5432/mydbNombre de usuario:Contraseña:Zona horaria: Usar los ajustes de la base de datos. America/Mexico_City - Hora estándar Central America/Los_Angeles - Hora estándar del Pacífico America/Denver - Hora estándar de las Rocosas America/Chicago - Hora estándar Central America/New_York - Hora estándar Oriental Europe/London - Hora del Meridiano de Greenwich Europe/Berlin - Hora de Europa Central Europe/Bucharest - Hora de Europa Oriental Consejo: no cambie los ajustes de la zona horaria a menos que esté seguro de que los datos de marca de fecha y hora de la base de datos no sean correctos.Prueba de conexión Conexión superada

How connect J Studio with an iSeries DB.

your xml is well work with me too. but I work in ireport 5.6 and I send you my xml, my connection is to iSeries can you tell me your opinion please. tank you very much <?xml version="1.0" encoding="UTF-8"?> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Componentes_Avion" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="921e2d7e-53ee-4ca7-a490-655d0cb63226"> <property name="ireport.zoom" value="1.4641000000000006"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="ireport.jasperserver.reportUnit" value="/reports/Reportes_Planeacion/COMPONENTES_DE_AVION"/> <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/services/repository"/> <parameter name="AVION" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT FRPS."PSPN" AS FRPS_PSPN, FRPS."PSCODSIT" AS FRPS_PSCODSIT, FRNM."NMDESIGN" AS FRNM_NMDESIGN, FRAV."AVIMMATR" AS FRAV_AVIMMATR, FRPS."PSTSN" AS FRPS_PSTSN, FRPS."PSTSO" AS FRPS_PSTSO, FRPS."PSSN" AS FRPS_PSSN, FRPS."PSCSN" AS FRPS_PSCSN, FRPS."PSCSO" AS FRPS_PSCSO, FRPS."PSJSN" AS FRPS_PSJSN, FRPS."PSJSO" AS FRPS_PSJSO, FRAV."AVHVAB" AS FRAV_AVHVAB, FRAV."AVCY" AS FRAV_AVCY, FRKX."AVHVAB" AS FRKX_AVHVAB, FRKX."AVCY" AS FRKX_AVCY, FRPS."PSTSI2" AS FRPS_PSTSI2, FRPS."PSTSI" AS FRPS_PSTSI, FRPS."PSJSI2" AS FRPS_PSJSI2, FRPS."PSJSI" AS FRPS_PSJSI, FRPS."PSCSI2" AS FRPS_PSCSI2, FRPS."PSCSI" AS FRPS_PSCSI, FRKX."KXFIN" AS FRKX_KXFIN, FRKX."KXPOSAV" AS FRKX_KXPOSAV, FRKX."KXTYPE" AS FRKX_KXTYPE, FRPS."PSA4" AS FRPS_PSA4, FRPS."PSMM" AS FRPS_PSMM, FRPS."PSJJ" AS FRPS_PSJJ, FRAV."AVCRMA4" AS FRAV_AVCRMA4, FRAV."AVCRMMM" AS FRAV_AVCRMMM, FRAV."AVCRMJJ" AS FRAV_AVCRMJJ FROM "AMSF"."FRNM" FRNM INNER JOIN "AMSF"."FRPS" FRPS ON FRNM."NMPN" = FRPS."PSPN" LEFT OUTER JOIN "AMSF"."FRAV" FRAV ON FRPS."PSNUMAP" = FRAV."AVNUMAP" LEFT OUTER JOIN "AMSF"."FRKX" FRKX ON FRPS."PSPN" = FRKX."PSPN" AND FRKX."PSSN" = FRPS."PSSN" WHERE FRPS."PSCODSIT" = '41' AND FRAV."AVACTIF" = 'O' AND FRKX."KXTYPE" = 'O/C' AND FRAV."AVIMMATR" = $P{AVION} ORDER BY FRAV."AVIMMATR" ASC]]> </queryString> <field name="FRPS_PSPN" class="java.lang.String"/> <field name="FRPS_PSCODSIT" class="java.lang.String"/> <field name="FRNM_NMDESIGN" class="java.lang.String"/> <field name="FRAV_AVIMMATR" class="java.lang.String"/> <field name="FRPS_PSTSN" class="java.math.BigDecimal"/> <field name="FRPS_PSTSO" class="java.math.BigDecimal"/> <field name="FRPS_PSSN" class="java.lang.String"/> <field name="FRPS_PSCSN" class="java.math.BigDecimal"/> <field name="FRPS_PSCSO" class="java.math.BigDecimal"/> <field name="FRPS_PSJSN" class="java.math.BigDecimal"/> <field name="FRPS_PSJSO" class="java.math.BigDecimal"/> <field name="FRAV_AVHVAB" class="java.math.BigDecimal"/> <field name="FRAV_AVCY" class="java.math.BigDecimal"/> <field name="FRKX_AVHVAB" class="java.math.BigDecimal"/> <field name="FRKX_AVCY" class="java.math.BigDecimal"/> <field name="FRPS_PSTSI2" class="java.math.BigDecimal"/> <field name="FRPS_PSTSI" class="java.math.BigDecimal"/> <field name="FRPS_PSJSI2" class="java.math.BigDecimal"/> <field name="FRPS_PSJSI" class="java.math.BigDecimal"/> <field name="FRPS_PSCSI2" class="java.math.BigDecimal"/> <field name="FRPS_PSCSI" class="java.math.BigDecimal"/> <field name="FRKX_KXFIN" class="java.lang.String"/> <field name="FRKX_KXPOSAV" class="java.lang.String"/> <field name="FRKX_KXTYPE" class="java.lang.String"/> <field name="FRPS_PSA4" class="java.lang.String"/> <field name="FRPS_PSMM" class="java.lang.String"/> <field name="FRPS_PSJJ" class="java.lang.String"/> <field name="FRAV_AVCRMA4" class="java.lang.String"/> <field name="FRAV_AVCRMMM" class="java.lang.String"/> <field name="FRAV_AVCRMJJ" class="java.lang.String"/> <variable name="Fecha_Avion" class="java.util.Date"> <variableExpression><![CDATA[]]></variableExpression> <initialValueExpression><![CDATA[($F{FRAV_AVCRMA4}+"-"+$F{FRAV_AVCRMMM}+"-"+$F{FRAV_AVCRMJJ})]]></initialValueExpression> </variable> <variable name="Fecha_Install" class="java.util.Date"> <variableExpression><![CDATA[]]></variableExpression> <initialValueExpression><![CDATA[$F{FRPS_PSA4}+"-"+$F{FRPS_PSMM}+"-"+$F{FRPS_PSJJ}]]></initialValueExpression> </variable> <variable name="TEST1" class="java.util.Date"> <variableExpression><![CDATA[]]></variableExpression> <initialValueExpression><![CDATA[(new SimpleDateFormat("yyyy/MM/dd hh:mm:ss")).parse($F{FRAV_AVCRMA4}+"/"+$F{FRAV_AVCRMMM}+"/"+$F{FRAV_AVCRMJJ})]]></initialValueExpression> </variable> <variable name="TEST2" class="java.util.Date"> <variableExpression><![CDATA[]]></variableExpression> <initialValueExpression><![CDATA[(new SimpleDateFormat("yyyy/MM/dd hh:mm:ss")).parse($F{FRPS_PSA4}+"/"+$F{FRPS_PSMM}+"/"+$F{FRPS_PSJJ})]]></initialValueExpression> </variable> <title> <band height="54" splitType="Stretch"> <staticText> <reportElement x="211" y="17" width="333" height="32" uuid="118105b8-9570-44b7-aa4e-8167feec88d0"/> <box> <pen lineWidth="2.0" lineStyle="Double" lineColor="#006699"/> <topPen lineWidth="2.0" lineStyle="Double" lineColor="#006699"/> <leftPen lineWidth="2.0" lineStyle="Double" lineColor="#006699"/> <bottomPen lineWidth="2.0" lineStyle="Double" lineColor="#006699"/> <rightPen lineWidth="2.0" lineStyle="Double" lineColor="#006699"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="16" isBold="true" isUnderline="true"/> </textElement> <text><![CDATA[COMPONENTES O/C POR AVIÓN]]></text> </staticText> </band> </title> <columnHeader> <band height="30" splitType="Stretch"> <staticText> <reportElement mode="Opaque" x="0" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="34bb1dd0-2c88-4619-91bd-0392da0f2fff"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[A/C]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="40" y="10" width="50" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="31e3af2a-b7df-4f54-b479-4d0d778f6478"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[P/N]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="90" y="10" width="50" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="c8c55ded-edbc-4cc3-9001-76ca24fa34f5"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[s/N]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="303" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="b51bd072-ae08-4fac-84dd-9cb26f7d25f2"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[TSO]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="463" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="3d32fae8-b13d-40b3-b1b4-821c63eb5ce2"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[CSO]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="623" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="c6664cc9-bd1c-44ec-8d30-b21f87948dc4"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DSO]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="263" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="e36686c6-3e81-457b-acfa-7f9587f6e2bc"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[TSN]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="423" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="ef85dffc-f628-4af8-9172-895379c57aad"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[CSN]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="583" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="2bd3a680-1385-4d77-81ad-394637864bd1"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DSN]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="140" y="10" width="50" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="fd8f0644-4d1a-4034-a54f-47b442d4098d"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DESCRIPTION]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="343" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="a55da4ed-063c-460a-ac45-4865d6aa0312"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[TSI2]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="383" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="524e81f3-e607-404b-916b-94b537b2a4d2"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[TSI]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="503" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="2482d440-909e-4cbd-a6a0-4b8ff65c4074"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[CSI2]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="543" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="6a177173-0e63-44d3-8e1e-cc8b700f04f2"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[CSI]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="663" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="76376b8c-314f-40b0-9079-f0964a970a4e"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DSI2]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="703" y="10" width="40" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="fb6c6cdd-4c8e-4870-b0a3-8249537073e4"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[DSI]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="190" y="10" width="25" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="f7ba488a-13b7-45c9-9d8f-bd93acc1d601"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[POSICION]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="215" y="10" width="25" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="3f85485a-ea51-4599-8a44-0fe6ee996c57"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[FIN]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="240" y="10" width="23" height="20" forecolor="#000000" backcolor="#CCFFFF" uuid="1a58d1c9-caf0-4962-98a7-b4e4de01efa9"/> <box> <pen lineWidth="1.5" lineStyle="Double"/> <topPen lineWidth="1.5" lineStyle="Double"/> <leftPen lineWidth="1.5" lineStyle="Double"/> <bottomPen lineWidth="1.5" lineStyle="Double"/> <rightPen lineWidth="1.5" lineStyle="Double"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[TYPE]]></text> </staticText> </band> </columnHeader> <detail> <band height="25" splitType="Stretch"> <textField pattern="---" isBlankWhenNull="false"> <reportElement mode="Transparent" x="0" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="10563d51-2a00-48ff-8117-bca80cc5e71d"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRAV_AVIMMATR}]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="40" y="0" width="50" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="297b9ae6-048b-4009-86bf-689140f0f990"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRPS_PSPN}]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="90" y="0" width="50" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="82576fe4-c1fa-4e84-aeca-5e7188662412"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRPS_PSSN}]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="303" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="f8d7bf07-81f8-4808-a9ec-be98a9f6b875"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSTSO}.intValue()==999995 ? "UNK" : ($F{FRPS_PSTSO}.intValue()==999996 ? "C/M" : ($F{FRPS_PSTSO}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSTSO}.intValue()==999998 ? "O/C" : ($F{FRPS_PSTSO}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSTSO}+($F{FRAV_AVHVAB}-$F{FRKX_AVHVAB}) ))))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="463" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="b02f37fb-e304-4977-bf79-267543be8798"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSCSO}.intValue()==999995 ? "UNK" : ($F{FRPS_PSCSO}.intValue()==999996 ? "C/M" : ($F{FRPS_PSCSO}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSCSO}.intValue()==999998 ? "O/C" : ($F{FRPS_PSCSO}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSCSO}+($F{FRAV_AVCY}-$F{FRKX_AVCY}) ))))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="623" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="6434dae2-5823-404f-9f01-bc23361b6b54"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSJSO}.intValue()==999995 ? "UNK" : ($F{FRPS_PSJSO}.intValue()==999996 ? "C/M" : ($F{FRPS_PSJSO}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSJSO}.intValue()==999998 ? "O/C" : ($F{FRPS_PSJSO}.intValue()==999999 ? "N/FLW" : $F{FRPS_PSJSO} )))))]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="263" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="0df0be7f-70d5-4541-85eb-0b19d83f1cdf"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSTSN}.intValue()==999995 ? "UNK" : ($F{FRPS_PSTSN}.intValue()==999996 ? "C/M" : ($F{FRPS_PSTSN}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSTSN}.intValue()==999998 ? "O/C" : ($F{FRPS_PSTSN}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSTSN}+($F{FRAV_AVHVAB}-$F{FRKX_AVHVAB}) ))))))]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="583" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="93cdfdb3-ee92-4ded-81ee-7e5749eea4de"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSJSN}.intValue()==999995 ? "UNK" : ($F{FRPS_PSJSN}.intValue()==999996 ? "C/M" : ($F{FRPS_PSJSN}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSJSN}.intValue()==999998 ? "O/C" : ($F{FRPS_PSJSN}.intValue()==999999 ? "N/FLW" : $F{FRPS_PSJSN} )))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="423" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="a69c4cbf-e084-4936-9f14-21b39e7d4dc6"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSCSN}.intValue()==999995 ? "UNK" : ($F{FRPS_PSCSN}.intValue()==999996 ? "C/M" : ($F{FRPS_PSCSN}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSCSN}.intValue()==999998 ? "O/C" : ($F{FRPS_PSCSN}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSCSN}+($F{FRAV_AVCY}-$F{FRKX_AVCY}) ))))))]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="140" y="0" width="50" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="c7a3b5d2-f8f2-4229-b1cd-fc3225b12808"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRNM_NMDESIGN}]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="343" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="07b9a728-86ec-47e3-8b4d-ca616e0bf711"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSTSI2}.intValue()==999995 ? "UNK" : ($F{FRPS_PSTSI2}.intValue()==999996 ? "C/M" : ($F{FRPS_PSTSI2}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSTSI2}.intValue()==999998 ? "O/C" : ($F{FRPS_PSTSI2}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSTSI2}+($F{FRAV_AVHVAB}-$F{FRKX_AVHVAB}) ))))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="383" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="f4dd7bb3-f787-484d-9d72-ad5bff33e61b"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSTSI}.intValue()==999995 ? "UNK" : ($F{FRPS_PSTSI}.intValue()==999996 ? "C/M" : ($F{FRPS_PSTSI}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSTSI}.intValue()==999998 ? "O/C" : ($F{FRPS_PSTSI}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSTSI}+($F{FRAV_AVHVAB}-$F{FRKX_AVHVAB}) ))))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="503" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="fad02ae3-8de5-467f-a8d5-192c57056cb6"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSCSI2}.intValue()==999995 ? "UNK" : ($F{FRPS_PSCSI2}.intValue()==999996 ? "C/M" : ($F{FRPS_PSCSI2}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSCSI2}.intValue()==999998 ? "O/C" : ($F{FRPS_PSCSI2}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSCSI2}+($F{FRAV_AVCY}-$F{FRKX_AVCY}) ))))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="543" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="458496eb-a50c-4544-855c-c9578bc689bf"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSCSI}.intValue()==999995 ? "UNK" : ($F{FRPS_PSCSI}.intValue()==999996 ? "C/M" : ($F{FRPS_PSCSI}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSCSI}.intValue()==999998 ? "O/C" : ($F{FRPS_PSCSI}.intValue()==999999 ? "N/FLW" : ($F{FRPS_PSCSI}+($F{FRAV_AVCY}-$F{FRKX_AVCY}) ))))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="663" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="002e699e-b646-4693-80d1-1ec3a3640258"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSJSI2}.intValue()==999995 ? "UNK" : ($F{FRPS_PSJSI2}.intValue()==999996 ? "C/M" : ($F{FRPS_PSJSI2}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSJSI2}.intValue()==999998 ? "O/C" : ($F{FRPS_PSJSI2}.intValue()==999999 ? "N/FLW" : $F{FRPS_PSJSI2}) ))))]]></textFieldExpression> </textField> <textField pattern="###0" isBlankWhenNull="false"> <reportElement mode="Transparent" x="703" y="0" width="40" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="6a3d559f-bb72-4ac6-9006-8852d73560ae"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[($F{FRPS_PSJSI}.intValue()==999995 ? "UNK" : ($F{FRPS_PSJSI}.intValue()==999996 ? "C/M" : ($F{FRPS_PSJSI}.intValue()==999997 ? "UNLIMIT" : ($F{FRPS_PSJSI}.intValue()==999998 ? "O/C" : ($F{FRPS_PSJSI}.intValue()==999999 ? "N/FLW" : $F{FRPS_PSJSI}) ))))]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="190" y="0" width="25" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="90a5dea2-dd7b-4f9f-be6a-22e77afd0836"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRKX_KXPOSAV}]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="215" y="0" width="25" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="605dec37-ae5b-478a-8731-228e51bed691"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRKX_KXFIN}]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement mode="Transparent" x="240" y="0" width="23" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="ac8d0403-22e8-466b-927b-3f4e65edf476"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Single"/> </textElement> <textFieldExpression><![CDATA[$F{FRKX_KXTYPE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" evaluationTime="Auto" pattern="yyyy/MM/dd hh:mm:ss"> <reportElement x="743" y="0" width="31" height="20" uuid="857dd9e6-492c-44d5-9b04-a092f15599c8"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[($V{TEST1}.getTime() - $V{TEST2}.getTime())/1000/60/60]]></textFieldExpression> </textField> </band> </detail> </jasperReport>

I HAVE THIS EXPRESSION IN TEXT FIELD ESPRESSION BUT DON'T WORK, IT SHOW ME AS NULL ($V{TEST1}.getTime() - $V{TEST2}.getTime())/1000/60/60

In my report I have two dates and I want to get the difference in days. you cant help me. I HAVE THIS EXPRESSION IN TEXT FIELD ESPRESSION BUT DON'T WORK, IT SHOW ME AS NULL ($V{TEST1}.getTime() - $V{TEST2}.getTime())/1000/60/60