Jump to content
We've recently updated our Privacy Statement, available here ×

ahmed.khaliq

Members
  • Posts

    4
  • Joined

  • Last visited

ahmed.khaliq's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Image is uploaded in the same path. and the error occur once i click on the report in the jasper server.
  2. <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.19.1.final using JasperReports Library version 6.19.1-867c00bf88cd4d784d404379d6c05e1b419e8a4c --> <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"> <font size="9" isBold="true"/> <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"> <font size="9" isBold="true"/> <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"> <font isBold="false"/> </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"> <font isBold="true"/> </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"> <font size="18" isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="false"/> </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"> <font isBold="false"/> </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"> <font size="18"/> </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"> <font isBold="true"/> </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"> <font size="18" isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> </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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> <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"> <font isBold="true"/> </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"> <font isBold="true"/> <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"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[No record found.]]></text> </staticText> </band> </noData> </jasperReport>
  3. 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.
×
×
  • Create New...