I need a support to find a Error UID:d079dd48-0193-4716-acbc-2e078d2ef0e8

ahmed.khaliq · June 1, 2022

I am getting following error UID:d079dd48-0193-4716-acbc-2e078d2ef0e8 while running the report on jasper server however the report is running perfectly on jasper soft studio.

erikmarbad · June 1, 2022

Hello, can you provide the code of the report?

ahmed.khaliq · June 1, 2022

<?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="risk_transactions" pageWidth="1500" pageHeight="595" orientation="Landscape" columnWidth="1460" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d439063d-2489-47a2-a19d-ceab4ee94457">
 <property name="com.jaspersoft.studio.data.defaultdataadapter" value="payment_sbx"/>
 <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
 <property name="com.jaspersoft.studio.unit." value="pixel"/>
 <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
 <property name="ireport.jasperserver.url" value="http://192.168.1.100:6050/jasperserver/"/>
 <property name="ireport.jasperserver.user" value="jasperadmin"/>
 <property name="ireport.jasperserver.report.resource" value="/Risk_Analysis/Risk_Analysis_Summary_files/main_jrxml"/>
 <property name="ireport.jasperserver.reportUnit" value="/risk_analysis/Risk_Analysis_Summary"/>
 <property name="net.sf.jasperreports.viewer.zoom" value="FitWidth"/>
 <parameter name="Products" class="java.util.List">
 <defaultValueExpression><![CDATA[new ArrayList()]]></defaultValueExpression>
 </parameter>
 <parameter name="datefrom" class="net.sf.jasperreports.types.date.DateRange">
 <defaultValueExpression><![CDATA[new net.sf.jasperreports.types.date.DateRangeBuilder("MONTH-1").toDateRange()]]></defaultValueExpression>
 </parameter>
 <parameter name="dateto" class="net.sf.jasperreports.types.date.DateRange">
 <parameterDescription><![CDATA[]]></parameterDescription>
 <defaultValueExpression><![CDATA[new net.sf.jasperreports.types.date.DateRangeBuilder("DAY").toDateRange()]]></defaultValueExpression>
 </parameter>
 <parameter name="Risk" class="java.lang.String" evaluationTime="Late"/>
 <parameter name="Rule" class="java.lang.Integer" evaluationTime="Late"/>
 <queryString>
 <![CDATA[select
COALESCE(tr.product_code, '-')::text as product_code ,
COALESCE(p.name, '-')::text as product_name,
COALESCE(rp.code, '-')::text as risk_code,
COALESCE(rp.name, '-')::text as risk_title,
tr.risk_plan_rule_id as rule_id,
COALESCE(rpr.risk_plan_code, '-')::text as rule_code,
COALESCE(rpr.title, rrtgr.title, rpr.risk_plan_code, '-')::text as rule_name,
COALESCE(als.name, '-')::text as aggregate_level,
COALESCE(ats.name, '-')::text as aggregate_type,
count(case when (tr.trans_status = 'D' or tr.result_code in ('TR', 'TL')) then tr.risk_plan_rule_id end) as declined_count,
sum(case when (tr.trans_status = 'D' or tr.result_code in ('TR', 'TL')) then ROUND(COALESCE(tr.amount_transaction, 0.00), 2) * -1 end) as declined_amount,
count(case when (tr.trans_status != 'D' or tr.result_code not in ('TR', 'TL')) then tr.risk_plan_rule_id end) as forced_post_count,
sum(case when (tr.trans_status != 'D' or tr.result_code not in ('TR', 'TL')) then ROUND(COALESCE(tr.amount_transaction, 0.00), 2) * -1 end) as forced_post_amount,
count( tr.risk_plan_rule_id) as risk_trans_count,
cast((count(tr.risk_plan_rule_id) * 100)::float / t.total_count as numeric) as total_per,
cast((count(case when (tr.trans_status = 'D' or tr.result_code in ('TR', 'TL')) then tr.id end) * 100)::float / t.risk_count as numeric) as decl_per,
t.total_count as trans_count,
t.risk_count,
count(tr.cardholder_id) as cardholder_count,
count(case when (tr.card_status_before != 'F' and tr.card_status_after = 'F') then tr.id end) as blocked_card_counts
from transactions tr
join (select count(case when risk_plan_rule_id is not null then risk_plan_rule_id end) - count(case when risk_plan_rule_id is not null and (trans_status != 'D' or result_code not in ('TR', 'TL')) then id end ) as risk_count,
count(case when risk_plan_rule_id is null then id end ) as total_count
from transactions where message_type not in ('0722') and $X{IN, product_code, Products}) t on 1=1
join products p on tr.product_code = p.code
left join risk_plans rp on rp.code = p.risk_plan_code
left join risk_plan_rules rpr on rpr.id = tr.risk_plan_rule_id
left join risk_req_type_grps rrtgr on rpr.risk_req_type_grp_code = rrtgr.code
left join b_aggregate_levels als on als.code = rpr.aggregate_level_code
left join b_aggregate_types ats on ats.code = rpr.aggregate_type_code
where tr.message_type not in ('0722') and tr.risk_plan_rule_id is not null and $X{IN, p.code, Products}
and $X{[GREATER, tr.created_on, datefrom} and $X{LESS], tr.created_on, dateto}
and ( $P{Risk} = rp.name or $P{Risk} is null)
and ( $P{Rule} = tr.risk_plan_rule_id or $P{Rule} is null)
group by 1,2,3,4,5,6,7,8,9,17,18
order by 1,3]]>
 </queryString>
 <field name="product_code" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="product_code"/>
 <property name="com.jaspersoft.studio.field.label" value="product_code"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="transactions"/>
 </field>
 <field name="product_name" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="product_name"/>
 <property name="com.jaspersoft.studio.field.label" value="product_name"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="products"/>
 </field>
 <field name="risk_code" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="risk_code"/>
 <property name="com.jaspersoft.studio.field.label" value="risk_code"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="risk_plans"/>
 </field>
 <field name="risk_title" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="risk_title"/>
 <property name="com.jaspersoft.studio.field.label" value="risk_title"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="risk_plans"/>
 </field>
 <field name="rule_id" class="java.lang.Integer">
 <property name="com.jaspersoft.studio.field.name" value="rule_id"/>
 <property name="com.jaspersoft.studio.field.label" value="rule_id"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="transactions"/>
 </field>
 <field name="rule_code" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="rule_code"/>
 <property name="com.jaspersoft.studio.field.label" value="rule_code"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="risk_plan_rules"/>
 </field>
 <field name="rule_name" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="rule_name"/>
 <property name="com.jaspersoft.studio.field.label" value="rule_name"/>
 </field>
 <field name="aggregate_level" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="aggregate_level"/>
 <property name="com.jaspersoft.studio.field.label" value="aggregate_level"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="b_aggregate_levels"/>
 </field>
 <field name="aggregate_type" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.name" value="aggregate_type"/>
 <property name="com.jaspersoft.studio.field.label" value="aggregate_type"/>
 <property name="com.jaspersoft.studio.field.tree.path" value="b_aggregate_types"/>
 </field>
 <field name="declined_count" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="declined_count"/>
 <property name="com.jaspersoft.studio.field.label" value="declined_count"/>
 </field>
 <field name="declined_amount" class="java.math.BigDecimal">
 <property name="com.jaspersoft.studio.field.name" value="declined_amount"/>
 <property name="com.jaspersoft.studio.field.label" value="declined_amount"/>
 </field>
 <field name="forced_post_count" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="forced_post_count"/>
 <property name="com.jaspersoft.studio.field.label" value="forced_post_count"/>
 </field>
 <field name="forced_post_amount" class="java.math.BigDecimal">
 <property name="com.jaspersoft.studio.field.name" value="forced_post_amount"/>
 <property name="com.jaspersoft.studio.field.label" value="forced_post_amount"/>
 </field>
 <field name="risk_trans_count" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="risk_trans_count"/>
 <property name="com.jaspersoft.studio.field.label" value="risk_trans_count"/>
 </field>
 <field name="total_per" class="java.math.BigDecimal">
 <property name="com.jaspersoft.studio.field.name" value="total_per"/>
 <property name="com.jaspersoft.studio.field.label" value="total_per"/>
 </field>
 <field name="decl_per" class="java.math.BigDecimal">
 <property name="com.jaspersoft.studio.field.name" value="decl_per"/>
 <property name="com.jaspersoft.studio.field.label" value="decl_per"/>
 </field>
 <field name="trans_count" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="trans_count"/>
 <property name="com.jaspersoft.studio.field.label" value="trans_count"/>
 </field>
 <field name="risk_count" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="risk_count"/>
 <property name="com.jaspersoft.studio.field.label" value="risk_count"/>
 </field>
 <field name="cardholder_count" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="cardholder_count"/>
 <property name="com.jaspersoft.studio.field.label" value="cardholder_count"/>
 </field>
 <field name="blocked_card_counts" class="java.lang.Long">
 <property name="com.jaspersoft.studio.field.name" value="blocked_card_counts"/>
 <property name="com.jaspersoft.studio.field.label" value="blocked_card_counts"/>
 </field>
 <variable name="declined_count1" class="java.lang.Long" resetType="Group" resetGroup="1" calculation="Sum">
 <variableExpression><![CDATA[$F{declined_count}]]></variableExpression>
 </variable>
 <variable name="declined_amount1" class="java.math.BigDecimal" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{declined_amount}]]></variableExpression>
 </variable>
 <variable name="forced_post_count1" class="java.lang.Long" calculation="Sum">
 <variableExpression><![CDATA[$F{forced_post_count}]]></variableExpression>
 </variable>
 <variable name="forced_post_amount1" class="java.math.BigDecimal" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{forced_post_amount}]]></variableExpression>
 </variable>
 <variable name="risk_trans_count1" class="java.lang.Long" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{risk_trans_count}]]></variableExpression>
 </variable>
 <variable name="G_total_p" class="java.math.BigDecimal" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{total_per}]]></variableExpression>
 </variable>
 <variable name="G_dcl_p" class="java.math.BigDecimal" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{decl_per}]]></variableExpression>
 </variable>
 <variable name="GRAND_dcl_count" class="java.lang.Long" calculation="Sum">
 <variableExpression><![CDATA[$F{declined_count}]]></variableExpression>
 </variable>
 <variable name="GRAND_f_count" class="java.lang.Long" calculation="Sum">
 <variableExpression><![CDATA[$F{forced_post_count}]]></variableExpression>
 </variable>
 <variable name="GRAND_f_amount" class="java.math.BigDecimal" calculation="Sum">
 <variableExpression><![CDATA[$F{forced_post_amount}]]></variableExpression>
 </variable>
 <variable name="GRAND_r_trans_count" class="java.lang.Long" calculation="Sum">
 <variableExpression><![CDATA[$F{risk_trans_count}]]></variableExpression>
 </variable>
 <variable name="GRAND_t_per" class="java.math.BigDecimal" calculation="Sum">
 <variableExpression><![CDATA[$F{total_per}]]></variableExpression>
 </variable>
 <variable name="GRAND_dcl_per" class="java.math.BigDecimal" calculation="Sum">
 <variableExpression><![CDATA[$F{decl_per}]]></variableExpression>
 </variable>
 <variable name="testGDCLAmount" class="java.math.BigDecimal" calculation="Sum">
 <variableExpression><![CDATA[$F{declined_amount}]]></variableExpression>
 </variable>
 <variable name="GRAND_dcl_amount" class="java.math.BigDecimal" calculation="Sum">
 <variableExpression><![CDATA[$F{declined_amount}]]></variableExpression>
 </variable>
 <variable name="cardholder_count1" class="java.lang.Long" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{cardholder_count}]]></variableExpression>
 </variable>
 <variable name="Grand_cardholder_count" class="java.lang.Long" calculation="Sum">
 <variableExpression><![CDATA[$F{cardholder_count}]]></variableExpression>
 </variable>
 <variable name="block_card_count1" class="java.lang.Integer" resetType="Group" resetGroup="ProductCodeGroup" calculation="Sum">
 <variableExpression><![CDATA[$F{blocked_card_counts}]]></variableExpression>
 </variable>
 <variable name="Grand_blocked_card_count" class="java.lang.Integer" calculation="Sum">
 <variableExpression><![CDATA[$F{blocked_card_counts}]]></variableExpression>
 </variable>
 <group name="1">
 <groupExpression><![CDATA[$F{product_code}]]></groupExpression>
 </group>
 <group name="ProductCodeGroup">
 <groupExpression><![CDATA[$F{product_code}]]></groupExpression>
 <groupHeader>
 <band height="36">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <frame>
 <reportElement mode="Opaque" x="0" y="3" width="1460" height="30" backcolor="#E8E8E8" uuid="c3bea1ca-4f0c-429b-a4ee-f865dcc79b43">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textField textAdjust="ScaleFont">
 <reportElement x="0" y="0" width="270" height="30" uuid="32c8087b-7949-4361-ab7e-b8b67ea2b1c5">
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Left" verticalAlignment="Middle">
 
 <paragraph leftIndent="5"/>
 </textElement>
 <textFieldExpression><![CDATA[string.valueOf("Product: " + $F{product_code}+ " - " + $F{product_name} )]]></textFieldExpression>
 </textField>
 <textField textAdjust="ScaleFont" evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="855" y="0" width="71" height="30" uuid="2af32475-005f-4048-8a08-d2e8ef17e6c6">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{declined_count1} == 0 ? String.valueOf("-") : String.valueOf($V{declined_count1}))]]></textFieldExpression>
 </textField>
 <textField textAdjust="ScaleFont">
 <reportElement x="270" y="0" width="285" height="30" uuid="6c4230c5-b34a-496f-9e5f-44791b9bf9ca">
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="5"/>
 </textElement>
 <textFieldExpression><![CDATA[string.valueOf("Risk Plan: " + $F{risk_title})]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="931" y="0" width="72" height="30" uuid="3d046f59-8e6d-4b3a-9ed1-4b47cf6f6973">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 </textElement>
 <textFieldExpression><![CDATA[($V{declined_amount1} ==null ? String.valueOf("-") : String.valueOf($V{declined_amount1}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="1007" y="0" width="71" height="30" uuid="ed5c3794-5d92-4aeb-8ecd-01e8a2859162">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{forced_post_count1} == 0 ? String.valueOf("-") : String.valueOf($V{forced_post_count1}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="1083" y="0" width="71" height="30" uuid="bcf68234-78d9-4ac2-9c59-5c277bbbc346">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{forced_post_amount1} ==null ? String.valueOf("-") : String.valueOf($V{forced_post_amount1}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="1159" y="0" width="95" height="30" uuid="4ca8ffb5-7b7e-4771-b885-32df2e1b688a">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf($V{risk_trans_count1})]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="1259" y="0" width="95" height="30" uuid="1dd567b6-1bdb-4a91-b45c-7a9c6dcae156">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.format("%.2f",(double)($V{G_total_p}.doubleValue()))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="1359" y="0" width="100" height="30" uuid="8cc0a64f-528a-4117-985d-ed774dc49b71">
 <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.format("%.2f",(double)($V{G_dcl_p}.doubleValue()))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="555" y="0" width="97" height="30" uuid="90704777-07d0-4356-bfba-56bec4e71712">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{cardholder_count1} == 0 ? String.valueOf("-") : String.valueOf($V{cardholder_count1}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="654" y="0" width="95" height="30" uuid="e2495253-93eb-4452-b234-30c90002c58c">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{cardholder_count1} == 0 ? String.valueOf("-") : String.valueOf($V{cardholder_count1}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Group" evaluationGroup="ProductCodeGroup">
 <reportElement x="755" y="0" width="95" height="30" uuid="c7fa3cd4-bd10-4037-a9d7-b621c7df9668">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{block_card_count1} == 0 ? String.valueOf("-") : String.valueOf($V{block_card_count1}))]]></textFieldExpression>
 </textField>
 </frame>
 </band>
 </groupHeader>
 </group>
 <columnHeader>
 <band height="201">
 <frame>
 <reportElement x="0" y="10" width="1460" height="70" uuid="ea09bcb6-4caf-4f9c-9f5a-9a450a5ca5ee">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <staticText>
 <reportElement x="640" y="40" width="160" height="20" uuid="c20de568-4852-4aec-a48c-c35f4bf90b63">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.y" value="px"/>
 </reportElement>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Group By Product, Risk Plan]]></text>
 </staticText>
 <staticText>
 <reportElement x="0" y="15" width="1460" height="50" uuid="ce5fe220-e36f-47ba-84b1-dd2c85a6ae9c">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.y" value="px"/>
 </reportElement>
 <textElement textAlignment="Center" verticalAlignment="Top" markup="html">
 
 </textElement>
 <text><![CDATA[Risk Analysis Summary]]></text>
 </staticText>
 <staticText>
 <reportElement x="1309" y="35" width="60" height="20" uuid="8adbc6b4-e5f8-453a-943d-acf5ba3bc44b"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <text><![CDATA[Time: ]]></text>
 </staticText>
 <textField pattern="hh:mm:ss a z">
 <reportElement x="1369" y="35" width="91" height="20" uuid="aeb52901-a879-486c-9a4e-38671ff4ab72"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
 </textField>
 <staticText>
 <reportElement x="1309" y="15" width="60" height="20" uuid="9d110981-18a8-471f-adb6-37da9a3ed2bd"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <text><![CDATA[Date: ]]></text>
 </staticText>
 <textField pattern="yyyy-MM-dd">
 <reportElement x="1369" y="15" width="91" height="20" uuid="6f2ffe8a-b693-46a7-86fb-12bb85503cb4"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
 </textField>
 <image>
 <reportElement x="0" y="15" width="120" height="38" uuid="230658bb-ff95-489e-8211-5aecef92faf0">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <imageExpression><![CDATA["repo:original_logo.png"]]></imageExpression>
 </image>
 </frame>
 <frame>
 <reportElement mode="Opaque" x="0" y="121" width="1460" height="50" backcolor="#C0C0C0" uuid="4ff51515-e727-4c82-b687-8f410bd0c5bb">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <staticText>
 <reportElement x="100" y="0" width="304" height="50" uuid="5b860f13-6268-4fac-8b49-0e4367a94f55">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="1.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="5"/>
 </textElement>
 <text><![CDATA[Rule Name]]></text>
 </staticText>
 <staticText>
 <reportElement x="404" y="30" width="75" height="20" uuid="f9ed399f-966d-4540-94f4-21d953584d12">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="10"/>
 </textElement>
 <text><![CDATA[Level]]></text>
 </staticText>
 <staticText>
 <reportElement x="0" y="0" width="100" height="50" uuid="2efba7e7-9818-4d46-8603-1471e8ce99b1">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Rule ID]]></text>
 </staticText>
 <staticText>
 <reportElement x="651" y="0" width="104" height="50" uuid="443da012-c596-4d83-aab6-bd4ce54f82f2">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Total Cards Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="755" y="0" width="100" height="50" uuid="406b6f13-fd88-41f4-af4a-8649d721da28">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[blocked Cards Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="855" y="0" width="152" height="30" uuid="e620ce42-8908-49ba-8364-959176b4fd91">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Decline Trans]]></text>
 </staticText>
 <staticText>
 <reportElement x="1007" y="0" width="152" height="30" uuid="2f09922d-bb68-4076-8b14-f50823205e76">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Forced Post Trans]]></text>
 </staticText>
 <staticText>
 <reportElement x="1259" y="0" width="200" height="30" uuid="850b47c4-2d9e-4083-a780-c91fdfeebb94">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Top" markup="none">
 
 </textElement>
 <text><![CDATA[Trans Percentage of]]></text>
 </staticText>
 <staticText>
 <reportElement x="1159" y="0" width="100" height="50" uuid="9928d501-73c8-49a9-8595-255afc1d3316">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Total Trans Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="855" y="30" width="76" height="20" uuid="54fdb936-5d33-4fab-ab4f-8969aeb9861a">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="931" y="30" width="75" height="20" uuid="7c591537-7ec6-41e3-8bad-58a5a52b404c">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Amount]]></text>
 </staticText>
 <staticText>
 <reportElement x="1006" y="30" width="76" height="20" uuid="99011a3e-b51c-4421-8382-6c55c73e9bab">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="1082" y="30" width="77" height="20" uuid="289521af-ea29-4b61-84fe-195340882f31">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Amount]]></text>
 </staticText>
 <staticText>
 <reportElement x="1259" y="30" width="100" height="20" uuid="eddd8b28-286a-47ca-91a2-f83adcc2e9ff">
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Total]]></text>
 </staticText>
 <staticText>
 <reportElement x="1359" y="30" width="100" height="20" uuid="58f4fd8b-7db4-408b-8a50-4a8a4b7a0aca">
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Declined]]></text>
 </staticText>
 <staticText>
 <reportElement x="404" y="0" width="150" height="30" uuid="c81b8ebf-2f00-4634-ba43-bd259c9dd60d"/>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Aggregate]]></text>
 </staticText>
 <staticText>
 <reportElement x="479" y="30" width="75" height="20" uuid="f39eb2be-d689-4540-8745-5fe94d85537b">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="5"/>
 </textElement>
 <text><![CDATA[Type]]></text>
 </staticText>
 <staticText>
 <reportElement x="554" y="0" width="97" height="50" uuid="5e20fdcd-4d96-4dd5-a31a-9437b6c40d9e">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Cardholders Count ]]></text>
 </staticText>
 </frame>
 <frame>
 <reportElement mode="Opaque" x="0" y="171" width="1460" height="30" backcolor="#E8E8E8" uuid="635dc359-39e9-4863-bc38-7634132cd5a8">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <staticText>
 <reportElement x="0" y="0" width="100" height="30" uuid="2fd7ba16-0116-42f7-9144-4a64eb50ac5b">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 </reportElement>
 <textElement textAlignment="Center" verticalAlignment="Middle"/>
 <text><![CDATA[Grand Total:]]></text>
 </staticText>
 <textField evaluationTime="Report">
 <reportElement x="855" y="0" width="71" height="30" uuid="428c8980-64a3-4e22-8d6f-fcb85fc153e3">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{GRAND_dcl_count} == 0 ? String.valueOf("-") : String.valueOf($V{GRAND_dcl_count}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="931" y="0" width="72" height="30" uuid="1448e988-19df-4eeb-9035-118c1fc62f76">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 </textElement>
 <textFieldExpression><![CDATA[($V{GRAND_dcl_amount} == null ? String.valueOf("-") : String.valueOf($V{GRAND_dcl_amount}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="1007" y="0" width="71" height="30" uuid="1460efbc-74e8-4c81-a50a-e6b89276396c">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{GRAND_f_count} == 0 ? String.valueOf("-") : String.valueOf($V{GRAND_f_count}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="1083" y="0" width="71" height="30" uuid="82e9a76e-51a5-4d44-901e-e56344036731">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{GRAND_f_amount} == null ? String.valueOf("-") : String.valueOf($V{GRAND_f_amount}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="1159" y="0" width="95" height="30" uuid="6b65e128-8585-4906-8cec-c0e9c252b559">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf($V{GRAND_r_trans_count})]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="1359" y="0" width="100" height="30" uuid="a7ab071a-834c-4b60-aa23-c6411a540b81"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.format("%.2f",(double)($V{GRAND_dcl_per}.doubleValue()))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="554" y="0" width="98" height="30" uuid="774a772a-db72-428c-a737-483b7d328fc6">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{Grand_cardholder_count} == 0 ? String.valueOf("-") : String.valueOf($V{Grand_cardholder_count}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="654" y="0" width="95" height="30" uuid="0785beeb-5cc1-4b3d-bab8-ff551c444730">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{Grand_cardholder_count} == 0 ? String.valueOf("-") : String.valueOf($V{Grand_cardholder_count}))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="1259" y="0" width="95" height="30" uuid="de3d4ce4-8d69-44d2-813a-c4c681ee8aa7">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.format("%.2f",(double)($V{GRAND_t_per}.doubleValue()))]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report">
 <reportElement x="755" y="0" width="95" height="30" uuid="4b779601-ecca-405b-838c-980848aa6c09">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($V{Grand_blocked_card_count} == 0 ? String.valueOf("-") : String.valueOf($V{Grand_blocked_card_count}))]]></textFieldExpression>
 </textField>
 </frame>
 <textField>
 <reportElement x="1" y="80" width="1458" height="20" uuid="2ae45839-8ed7-4b04-a516-18d524e8de07"/>
 <textElement textAlignment="Center"/>
 <textFieldExpression><![CDATA[($P{Products}.size() > 0 || $P{datefrom} != null || $P{dateto} != null ) ?
 (($P{datefrom} != null || $P{dateto} != null) ? "Transaction Date: " + new SimpleDateFormat("yyyy/MM/dd").format($P{datefrom}.getStart()) + " - " + new SimpleDateFormat("yyyy/MM/dd").format($P{dateto}.getEnd())+ ($P{Products}.size() > 0 ? (", Products: " + $P{Products}): "")
 :
 ($P{Products}.size() > 0 ? "Products: " + $P{Products} : "")
 )

: ""]]></textFieldExpression>
 </textField>
 </band>
 </columnHeader>
 <detail>
 <band height="20">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <frame>
 <reportElement x="1" y="0" width="1459" height="20" uuid="ebf666e6-4473-4911-95b1-462696972f81">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 </reportElement>
 <textField>
 <reportElement x="-1" y="0" width="101" height="20" uuid="99897cfb-6fb2-4b90-9c73-c0f57a4ca96f">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f9c8b001-f601-409d-a25f-5b10dd7a7d3e"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Center" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[$F{rule_id}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="100" y="0" width="304" height="20" uuid="ccc3817e-156a-4fb4-a149-6aa11d0e6dab">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="62b21cb9-778b-4bec-b784-8a6c18ae5db4"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{rule_name} == null ? '-' : $F{rule_name}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="405" y="0" width="90" height="20" uuid="75d0f2b8-3cc7-4cd5-862c-df4abad88ea0">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="555a53e1-66a0-40e5-bbae-0c0890b1f5fb"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{aggregate_level} == null ? '-' : $F{aggregate_level}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="495" y="0" width="60" height="20" uuid="121a756b-0564-4b9f-aaf3-df41775c0824">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="123f6c24-8452-41e5-afc2-203919ca4bd4"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{aggregate_type} == null ? '-' : $F{aggregate_type}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="855" y="0" width="70" height="20" uuid="347dff37-c551-4ef4-996e-30d48c10bc17">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1f80449b-3f35-46fe-b749-e9fce94accfc"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{declined_count} == 0 ? "-" : $F{declined_count}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="931" y="0" width="71" height="20" uuid="e22ee3a5-2ca9-49e9-8737-a9493c603717">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dd9f43a-beb7-431d-b836-9843dcac8586"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{declined_amount} == null ? '-' : $F{declined_amount}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="1007" y="0" width="70" height="20" uuid="85c0b0a3-36b4-480d-82b8-04a78147b4e4">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0083c246-3717-4749-9337-791fd333f7e8"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{forced_post_count} == 0 ? "-" : $F{forced_post_count}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="1083" y="0" width="70" height="20" uuid="183a8bce-b18e-4d4f-a517-f34d3b29b444">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e1ae7c5d-26b9-4ea8-be9f-6852f899317e"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{forced_post_amount} ==null ? '-' : $F{forced_post_amount}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="1160" y="0" width="93" height="20" uuid="f35fe304-e02a-49a9-bb18-5a308fa5387e">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="db7a4295-645d-4528-bed7-3772997d1b84"/>
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[($F{risk_trans_count} == 0 ? String.valueOf("-") : String.valueOf($F{risk_trans_count}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="1258" y="0" width="95" height="20" uuid="7d3e0fdc-55dc-49c9-bebe-3dd1f3c57564">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="85ce7fe8-187b-4898-88e5-7ab4cc1dc09a"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.format("%.2f",(double)($F{total_per}.doubleValue()))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="1360" y="0" width="98" height="20" uuid="9ea88aab-5c87-4245-913a-a064c3ef89f4">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7f4a2058-0204-4a7f-a111-b509598b655f"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.format("%.2f",(double)($F{decl_per}.doubleValue()))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="556" y="0" width="95" height="20" uuid="66176f1d-4b33-432a-b7c9-ec254cf30a5d">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="04937cc2-181e-40b6-a5d5-8be8c6b6d67a"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{cardholder_count} == 0 ? "-" : $F{cardholder_count}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="653" y="-1" width="95" height="20" uuid="808f61d7-f735-4951-8eb9-8f19d085c17c">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="04937cc2-181e-40b6-a5d5-8be8c6b6d67a"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[string.valueOf(($F{cardholder_count} == 0 ? "-" : $F{cardholder_count}))]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="754" y="0" width="95" height="20" uuid="c87ec47a-e5ee-4487-a7d7-5020567d4604">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f67e10e6-6dfd-4cd7-ae1f-57445cd8e4b7"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 </textElement>
 <textFieldExpression><![CDATA[string.valueOf(($F{blocked_card_counts} == 0 ? "-" : $F{blocked_card_counts}))]]></textFieldExpression>
 </textField>
 </frame>
 </band>
 </detail>
 <pageFooter>
 <band height="30">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <textField>
 <reportElement x="1" y="0" width="1456" height="30" uuid="6f6ba80a-c9f0-4e9c-8cb6-ad2de3d37b78"/>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
 </textField>
 </band>
 </pageFooter>
 <noData>
 <band height="174">
 <frame>
 <reportElement x="0" y="10" width="1460" height="70" uuid="d751682d-23b8-444c-b436-e6cbc02d2082">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <staticText>
 <reportElement x="640" y="40" width="160" height="20" uuid="8e69a69f-b000-4178-8059-a63e5bba7e94">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.y" value="px"/>
 </reportElement>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Group By Product, Risk Plan]]></text>
 </staticText>
 <staticText>
 <reportElement x="0" y="15" width="1460" height="50" uuid="17d3d71a-54fd-41b0-bec2-31883cddb4a8">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.y" value="px"/>
 </reportElement>
 <textElement textAlignment="Center" verticalAlignment="Top">
 
 </textElement>
 <text><![CDATA[Risk Analysis Summary]]></text>
 </staticText>
 <textField pattern="hh:mm:ss a z">
 <reportElement x="1369" y="35" width="91" height="20" uuid="8802d544-c87b-4a45-b2a1-ee4335e785d5"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
 </textField>
 <staticText>
 <reportElement x="1309" y="35" width="60" height="20" uuid="fcca45b8-079b-4773-8fec-eec56909ef26"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <text><![CDATA[Time: ]]></text>
 </staticText>
 <textField pattern="yyyy-MM-dd">
 <reportElement x="1369" y="15" width="91" height="20" uuid="accc2926-ff52-4989-b8a2-823638156473"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
 </textField>
 <staticText>
 <reportElement x="1309" y="15" width="60" height="20" uuid="98da04cf-a004-47af-88a1-a934b9be59fa"/>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <text><![CDATA[Date: ]]></text>
 </staticText>
 <image>
 <reportElement x="0" y="15" width="120" height="38" uuid="c0c9fe42-009d-4716-acff-6beeb1d98676">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <imageExpression><![CDATA["repo:original_logo.png"]]></imageExpression>
 </image>
 </frame>
 <frame>
 <reportElement mode="Opaque" x="0" y="80" width="1460" height="50" backcolor="#C0C0C0" uuid="7eaf389e-18e4-4840-9e46-98bd7fad583f">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <staticText>
 <reportElement x="100" y="0" width="304" height="50" uuid="9c10483f-a905-47a7-a692-935dd1cf8b99">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="1.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="5"/>
 </textElement>
 <text><![CDATA[Rule Name]]></text>
 </staticText>
 <staticText>
 <reportElement x="404" y="30" width="75" height="20" uuid="991dde4b-769f-44ad-8351-ade012c43195">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="10"/>
 </textElement>
 <text><![CDATA[Level]]></text>
 </staticText>
 <staticText>
 <reportElement x="0" y="0" width="100" height="50" uuid="bcadaa07-b975-46a5-8aac-0a3a02bf35dd">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Rule ID]]></text>
 </staticText>
 <staticText>
 <reportElement x="554" y="0" width="100" height="50" uuid="14e4c334-c954-40ec-8e66-8107e911cbea">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Cardholders Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="654" y="0" width="101" height="50" uuid="566e9040-e79f-46bb-b22b-0acbf2e80df8">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Total Cards Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="755" y="0" width="100" height="50" uuid="9c85aec7-d0f2-404a-acab-9e3545403fc7">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[blocked Cards Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="855" y="0" width="152" height="30" uuid="e96cb0c4-a6a3-408a-bc1b-87c0c394a12e">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Decline Trans]]></text>
 </staticText>
 <staticText>
 <reportElement x="1007" y="0" width="152" height="30" uuid="4ad79270-7a96-4bb2-86ed-d3d4b1c0a9dd">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Forced Post Trans]]></text>
 </staticText>
 <staticText>
 <reportElement x="1259" y="0" width="200" height="30" uuid="7b4eb235-5fde-4438-875b-b598bd5290e1">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Top" markup="none">
 
 </textElement>
 <text><![CDATA[Trans Percentage of]]></text>
 </staticText>
 <staticText>
 <reportElement x="1159" y="0" width="100" height="50" uuid="192ece8d-a239-4610-a31a-fe3360b35fad">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Total Trans Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="855" y="30" width="76" height="20" uuid="35dc506a-0d7c-428d-88be-03de82434b41">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="931" y="30" width="76" height="20" uuid="43148aeb-3701-46f4-bb20-e1cd1ff85afc">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Amount]]></text>
 </staticText>
 <staticText>
 <reportElement x="1007" y="30" width="76" height="20" uuid="ac833306-f550-4b34-9402-b439ac961539">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Count]]></text>
 </staticText>
 <staticText>
 <reportElement x="1083" y="30" width="76" height="20" uuid="04daca13-cf75-4c85-a143-fcdf42cd8565">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Amount]]></text>
 </staticText>
 <staticText>
 <reportElement x="1259" y="30" width="100" height="20" uuid="f7e339d7-9863-4ce2-8f0f-40332202addc">
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Total]]></text>
 </staticText>
 <staticText>
 <reportElement x="1359" y="30" width="100" height="20" uuid="f206e81c-a945-480d-b604-ad8d80c70b48">
 <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 <paragraph rightIndent="5"/>
 </textElement>
 <text><![CDATA[Declined]]></text>
 </staticText>
 <staticText>
 <reportElement x="404" y="0" width="150" height="30" uuid="a507a2e1-73a9-400f-b6c5-c421791312e0"/>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Aggregate]]></text>
 </staticText>
 <staticText>
 <reportElement x="479" y="30" width="75" height="20" uuid="37a6c77b-12ff-491b-81f3-66d707bb6fcd">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/>
 </reportElement>
 <box>
 <pen lineWidth="0.0" lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
 </box>
 <textElement verticalAlignment="Middle">
 
 <paragraph leftIndent="5"/>
 </textElement>
 <text><![CDATA[Type]]></text>
 </staticText>
 </frame>
 <staticText>
 <reportElement x="0" y="154" width="1460" height="20" uuid="6c5f2fe9-1a8e-4eb2-8ad0-8d3665188d26"/>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[No record found.]]></text>
 </staticText>
 </band>
 </noData>
</jasperReport>

ahmed.khaliq · June 1, 2022

This is the jrxml code.

erikmarbad · June 1, 2022

Where do you have the images stored? If you have them in the Images folder, then you are passing the wrong path.
It should be something like
repo:/images/logo.jpg

Does the error occur before running the report or after running it?

ahmed.khaliq · June 1, 2022

Image is uploaded in the same path. and the error occur once i click on the report in the jasper server.

erikmarbad · June 1, 2022

By the way, those kind of errors where the report works in Jaspersoft Studio but not in JasperReports Server is usually due to issues with paths or SQL code (JasperReports Server doesn't support all expressions that work in Jaspersoft Studio, an example is the WITH clause, which to make it work you either have to restructure the SQL code or you can also alter the JRS source files)

erikmarbad · June 1, 2022

If you are going to make a list, you must do it from JRS in the input controls, outside of Jaspersoft Studio this parameter will not take any value.

erikmarbad · June 1, 2022

Ok since the problem occurs as soon as you click on the report, possibly the problem is in one of these aspects:
- SQL code
- Routes
- Means
- Input control mapping error

Verify that the SQL code is valid for JRS, you can test this with other reports you have on the server and see if the clauses you place work or not.

Check that all the paths are correct, I still have a hard time understanding why you don't have the images in the Images folder.

Verify that all the resources that will be used in the report are in the report, you can find this out by selecting the report, clicking on edit and then on controls and resources.

If at the time of uploading the report I assign those parameters to existing input controls on the server, check that they have the same ID.

Sign In

I need a support to find a Error UID:d079dd48-0193-4716-acbc-2e078d2ef0e8

Recommended Posts

ahmed.khaliq

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

erikmarbad

Link to comment

Share on other sites

ahmed.khaliq

Link to comment

Share on other sites

ahmed.khaliq

Link to comment

Share on other sites

erikmarbad

Link to comment

Share on other sites

ahmed.khaliq

Link to comment

Share on other sites

erikmarbad

Link to comment

Share on other sites

erikmarbad

Link to comment

Share on other sites

erikmarbad

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore