ssuryan Posted November 14, 2018 Share Posted November 14, 2018 We have below in the jrxml that we use. It used to work fine in Jasper 6.4(ours is a webapplication which has jasper embedded into it) but when i use it with Jasper 6.7 getting the below exception.<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="ErrorTransactionsReport" pageWidth="100" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="100" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4e9a536f-29dd-4b74-9e77-fa6c8af619ae"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="net.sf.jasperreports.data.adapter" value="JdbcDataAdapter.xml"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JdbcDataAdapter"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">[/code]Getting resource not found exception.Caused by: net.sf.jasperreports.engine.JRException: Resource not found at: ./../../../../../../JdbcDataAdapter.xml.[/code]Also tried using repo:/JdbcDataAdapter.xml but did not work.Any help is highly appreciated.Attached the jrxml.<?xml version="1.0" encoding="UTF-8"?><br><!-- Created with Jaspersoft Studio version 6.4.2.final using JasperReports Library version 6.4.1 --><br><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="ErrorTransactionsReport" pageWidth="100" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="100" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4e9a536f-29dd-4b74-9e77-fa6c8af619ae"><br> <property name="com.jaspersoft.studio.data.sql.tables" value=""/><br> <property name="net.sf.jasperreports.data.adapter" value="JdbcDataAdapter.xml"/><br> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JdbcDataAdapter"/><br> <property name="com.jaspersoft.studio.unit." value="pixel"/><br> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 1_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> <conditionalStyle><br> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression><br> <style backcolor="#F2F2F2"/><br> </conditionalStyle><br> </style><br> <style name="Table 2_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 2_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 2_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 3_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 3_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 3_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> <conditionalStyle><br> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression><br> <style backcolor="#E1E4E8"/><br> </conditionalStyle><br> </style><br> <style name="Table 4_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 4_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 4_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> <conditionalStyle><br> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression><br> <style backcolor="#EBECED"/><br> </conditionalStyle><br> </style><br> <style name="Table 5_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 5_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 5_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <pen lineWidth="0.5" lineColor="#000000"/><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <leftPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> <rightPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> <conditionalStyle><br> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression><br> <style backcolor="#F2F2F2"/><br> </conditionalStyle><br> </style><br> <style name="Table 6_TH" mode="Opaque" backcolor="#F0F8FF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 6_CH" mode="Opaque" backcolor="#BFE1FF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> </style><br> <style name="Table 6_TD" mode="Opaque" backcolor="#FFFFFF"><br> <box><br> <topPen lineWidth="0.5" lineColor="#000000"/><br> <bottomPen lineWidth="0.5" lineColor="#000000"/><br> </box><br> <conditionalStyle><br> <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression><br> <style backcolor="#F2F2F2"/><br> </conditionalStyle><br> </style><br> <subDataset name="Dataset1" uuid="99a49cf2-3b4d-4de4-8a7d-3a274be768c4"><br> <property name="com.jaspersoft.studio.data.sql.tables" value=""/><br> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JdbcDataAdapter"/><br> <property name="net.sf.jasperreports.data.adapter" value="./../../../../../../JdbcDataAdapter.xml"/><br> <parameter name="Protocols" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="Operations" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="Status" class="java.lang.String"><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="S" class="java.lang.String"><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="E" class="java.lang.String"><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="Q" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["and ts >= '2017-01-01 00:34:56' and ts<= '2017-01-04 01:31:58'"]]></defaultValueExpression><br> </parameter><br> <parameter name="Partners" class="java.lang.String"><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="MSSQLDummy" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="FetchSize" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="MSSQLFetchSize" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="ENTIRE_QUERY" class="java.lang.String"><br> <defaultValueExpression><![CDATA["SELECT B.TPNAME ,B.HOST_INITIATES,B.STATUS,B.TS from BC_TRANSACTIONS B where B.STATUS $P!{Status} and PROTOCOL_NAME $P!{Protocols} and OPERATION_ID $P!{Operations} and (TPNAME $P!{Partners} OR HOSTNAME $P!{Partners}) $P!{Q} ORDER by B.TS "]]></defaultValueExpression><br> </parameter><br> <queryString language="SQL"><br> <![CDATA[$P!{ENTIRE_QUERY}]]><br> </queryString><br> <field name="TPNAME" class="java.lang.String"/><br> <field name="HOST_INITIATES" class="java.lang.String"/><br> <field name="STATUS" class="java.lang.String"/><br> <field name="TS" class="java.sql.Timestamp"/><br> <variable name="Variable_1" class="java.lang.Integer" resetType="None" incrementType="Report" calculation="Count"/><br> </subDataset><br> <parameter name="Dummy" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="Protocols" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="Operations" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="Status" class="java.lang.String"><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="S" class="java.lang.String"><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="E" class="java.lang.String"><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="Q" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["and ts >= '2017-01-01 00:34:56' and ts<= '2017-01-04 01:31:58'"]]></defaultValueExpression><br> </parameter><br> <parameter name="Partners" class="java.lang.String"><br> <defaultValueExpression><![CDATA["like '%'"]]></defaultValueExpression><br> </parameter><br> <parameter name="MSSQLDummy" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="FetchSize" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="MSSQLFetchSize" class="java.lang.String"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="ENTIRE_QUERY" class="java.lang.String"><br> <defaultValueExpression><![CDATA["SELECT B.TPNAME ,B.HOST_INITIATES,B.STATUS,B.TS from BC_TRANSACTIONS B where B.STATUS $P!{Status} and PROTOCOL_NAME $P!{Protocols} and OPERATION_ID $P!{Operations} and (TPNAME $P!{Partners} OR HOSTNAME $P!{Partners}) $P!{Q} ORDER by B.TS "]]></defaultValueExpression><br> </parameter><br> <queryString language="SQL"><br> <![CDATA[select $P!{MSSQLDummy} B.TPNAME ,B.HOST_INITIATES,B.STATUS,B.TS from BC_TRANSACTIONS b $P!{Dummy}]]><br> </queryString><br> <field name="TPNAME" class="java.lang.String"/><br> <field name="HOST_INITIATES" class="java.lang.String"/><br> <field name="STATUS" class="java.lang.String"/><br> <field name="TS" class="java.sql.Timestamp"/><br> <variable name="Variable_1" class="java.lang.Integer" resetType="None" incrementType="Report" calculation="Count"/><br> <background><br> <band splitType="Stretch"/><br> </background><br> <pageHeader><br> <band height="40"><br> <textField isStretchWithOverflow="true"><br> <reportElement x="0" y="10" width="40" height="23" uuid="9f588112-cd23-4beb-ae5c-b0dd573eeef2"/><br> <textElement textAlignment="Right"><br> <font size="16" isBold="true"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true" evaluationTime="Report"><br> <reportElement x="40" y="10" width="100" height="23" uuid="77789ab0-6020-4ae3-874b-57fc26ecc1dd"/><br> <textElement textAlignment="Left"><br> <font size="16" isBold="true"/><br> </textElement><br> <textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression><br> </textField><br> </band><br> </pageHeader><br> <detail><br> <band height="233" splitType="Stretch"><br> <property name="com.jaspersoft.studio.unit.height" value="pixel"/><br> <staticText><br> <reportElement positionType="Float" x="0" y="30" width="140" height="35" uuid="ff8a82ab-c00f-422a-a907-06d4021b87bd"><br> <property name="com.jaspersoft.studio.unit.y" value="pixel"/><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="18" isBold="true"/><br> </textElement><br> <text><![CDATA[No Data]]></text><br> </staticText><br> <componentElement><br> <reportElement stretchType="RelativeToBandHeight" x="1" y="0" width="1610" height="233" uuid="f13263d9-842f-4c18-aab6-79aabd49744c"><br> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/><br> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 6_TH"/><br> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 6_CH"/><br> <property name="com.jaspersoft.studio.table.style.detail" value="Table 6_TD"/><br> </reportElement><br> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"><br> <datasetRun subDataset="Dataset1" uuid="e2b780a1-7ba4-426f-93ad-a621f58459f0"><br> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <returnValue fromVariable="Variable_1" toVariable="Variable_1" calculation="Count"/><br> </datasetRun><br> <jr:column width="386" uuid="22419361-f83b-45b8-a347-f2c7e6cef6de"><br> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/><br> <printWhenExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}.containsKey( "request-TPNAME" )]]></printWhenExpression><br> <jr:columnHeader style="Table 6_CH" height="30"><br> <textField><br> <reportElement x="0" y="0" width="386" height="30" uuid="951520a8-bd64-4ad6-af43-95fa6162eaf4"/><br> <box><br> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="16" isBold="true"/><br> </textElement><br> <textFieldExpression><![CDATA["Trading Partner"]]></textFieldExpression><br> </textField><br> </jr:columnHeader><br> <jr:detailCell style="Table 6_TD" height="30"><br> <textField><br> <reportElement x="0" y="0" width="386" height="30" uuid="de2cef60-74d1-451a-9254-7d7ab1beb341"/><br> <box><br> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="14"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{TPNAME}]]></textFieldExpression><br> </textField><br> </jr:detailCell><br> </jr:column><br> <jr:column width="256" uuid="dc69f1e1-10e5-43c3-a6a3-047bbbdb6465"><br> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/><br> <printWhenExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}.containsKey( "request-HOST_INITIATES" )]]></printWhenExpression><br> <jr:columnHeader style="Table 6_CH" height="30"><br> <textField><br> <reportElement x="0" y="0" width="256" height="30" uuid="be478735-f291-46ab-8b45-fbb1a17a8851"/><br> <box><br> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="16" isBold="true"/><br> </textElement><br> <textFieldExpression><![CDATA[" Inbound/Outbound"]]></textFieldExpression><br> </textField><br> </jr:columnHeader><br> <jr:detailCell style="Table 6_TD" height="30"><br> <textField><br> <reportElement x="0" y="0" width="256" height="30" uuid="2218e398-1b13-48e6-95f1-7ed1a48358db"/><br> <box><br> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="14"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{HOST_INITIATES}.equals("true")?"Outbound":"Inbound"]]></textFieldExpression><br> </textField><br> </jr:detailCell><br> </jr:column><br> <jr:column width="307" uuid="3d19efc2-1774-4056-bf2b-3d99c5296c7c"><br> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/><br> <printWhenExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}.containsKey( "request-STATUS" )]]></printWhenExpression><br> <jr:columnHeader style="Table 6_CH" height="30"><br> <staticText><br> <reportElement positionType="Float" x="0" y="0" width="307" height="30" uuid="04d21006-3d38-4a06-b868-e61f60951c56"/><br> <box><br> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="16" isBold="true"/><br> </textElement><br> <text><![CDATA[status]]></text><br> </staticText><br> </jr:columnHeader><br> <jr:detailCell style="Table 6_TD" height="30"><br> <textField><br> <reportElement x="0" y="0" width="307" height="30" uuid="cbb71e63-887e-4560-a7ac-3d1e5004b081"/><br> <box><br> <pen lineWidth="1.0" lineStyle="Solid"/><br> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="14"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{STATUS}]]></textFieldExpression><br> </textField><br> </jr:detailCell><br> </jr:column><br> <jr:column width="361" uuid="1800559f-3a4c-4963-bb46-7eb104daf215"><br> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/><br> <printWhenExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}.containsKey( "request-TS" )]]></printWhenExpression><br> <jr:columnHeader style="Table 6_CH" height="30"><br> <staticText><br> <reportElement x="0" y="0" width="361" height="30" uuid="9c62fac2-7ad1-44e3-89ba-2329867b006b"/><br> <box><br> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="16" isBold="true"/><br> </textElement><br> <text><![CDATA[Time Stamp]]></text><br> </staticText><br> </jr:columnHeader><br> <jr:detailCell style="Table 6_TD" height="30"><br> <textField><br> <reportElement x="0" y="0" width="361" height="30" uuid="79ad5677-b241-406e-9353-e242e8669e61"/><br> <box><br> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="14"/><br> </textElement><br> <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("MMM-dd-yyyy hh:mm:ss aaa").format($F{TS})]]></textFieldExpression><br> </textField><br> </jr:detailCell><br> </jr:column><br> </jr:table><br> </componentElement><br> </band><br> </detail><br></jasperReport><br>[/code] Link to comment Share on other sites More sharing options...
prusyn Posted November 14, 2018 Share Posted November 14, 2018 Can you upload jrxml file of your report? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now