gerramirez

February 25, 2019

i have the expretion:

$F{NROLIGNE} == null? $V{COMMT}: $V{COMMT} + $F{COMMENT}

but print:

FECHA

MATRI CULA

CIA

NRO. VOL.

TIPO VOL.

APD

APA

STD

ATD

ATA

STA

COD. RETA1

TPS. RET1

COD. RETA2

TPS. RET2

COD. RETA3

TPS. RET3

CTE

2019/01/01

XA-MKH

TAO

927

XTA

MEX

ZIH

16:00

15:45

16:50

17:15

0

MEDLEG / MEDLEG OCHOA

0TI.NAL.13 INT.00 CNX.NAL.04 INT.00 R.17 I.00 F.00 TLLS.17 *EMV

2019/01/01

XA-MKH

TAO

927

XTA

MEX

ZIH

16:00

15:45

16:50

17:15

0

MEDLEG / 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/01

XA-MKH

TAO

927

XTA

MEX

ZIH

16:00

15:45

16:50

17:15

0

MEDLEG / 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?

July 6, 2018

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?

June 25, 2018

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

April 11, 2017

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

April 11, 2017

Establezca el tipo de origen de datos y sus propiedades

Seleccione primero el tipo de origen de datos que desea agregar y, a continuación, introduzca los valores de propiedad necesarios.

Entradas de usuario

Tipo:

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

February 27, 2017

How connect J Studio with an iSeries DB.

February 27, 2017

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"?>

</parameter>

<![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>

</variable>

</variable>

</variable>

</variable>

<title>

<box>

</box>

</textElement>

</staticText>

</band>

</title>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

<box>

</box>

</textElement>

</staticText>

</band>

</columnHeader>

<box>

</box>

</textElement>

</textField>

<box>

</box>

</textElement>

</textField>

<box>

</box>

</textElement>

</textField>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</textElement>

</textField>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</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>

<box>

</box>

</textElement>

</textField>

<box>

</box>

</textElement>

</textField>

<box>

</box>

</textElement>

</textField>

</textField>

</band>

</detail>

</jasperReport>

February 25, 2017

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

February 24, 2017

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

Sign In

gerramirez

Posts

Joined

Last visited

Content Type

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by gerramirez

Print the last concat field

How to make $X{[BETWEEN] with parameter of type date range

Field Date

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

not install com.ibm.as400.access.AS400JDBCDriver

Establezca el tipo de origen de datos y sus propiedades

Seleccione primero el tipo de origen de datos que desea agregar y, a continuación, introduzca los valores de propiedad necesarios.

How connect J Studio with an iSeries

Subtract dates

Subtract dates

Subtract dates

Activity

Products

Explore