Jump to content
Changes to the Jaspersoft community edition download ×

Problem in the excel output


sapna.singh

Recommended Posts

Hi,

I've created a report, in which there is sum of respective columns are there in the column footer. While preview of the report ,from designer, is absolutely the way i wanted.But once i publish it on the server and

schedule the report in excel format, the output is not showing data of column footer.

What should i do. Please Help.

 

Regards,

Sapna.

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi Hozawa,

 

I'm not able to attach the output. I hope below source code will help you understand the report. 

 

 

 

<?xml version="1.0" encoding="UTF-8"?>

<!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1  -->

<!-- 2017-03-08T16:21:34 -->

<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="Commission report updated" pageWidth="3450" pageHeight="1000000000" whenNoDataType="AllSectionsNoDetail" columnWidth="3450" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true" uuid="a219baa2-7c57-4eb1-98ed-de80e02d6341">

<property name="com.jaspersoft.studio.data.sql.tables" value=""/>

<property name="com.jaspersoft.studio.data.defaultdataadapter" value="ReportingCon"/>

<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="net.sf.jasperreports.print.keep.full.text" value="true"/>

<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/>

<property name="net.sf.jasperreports.export.xls.sheet.names.{arbitrary_name}" value="Commission Report"/>

<property name="ireport.jasperserver.url" value="http://52.204.124.225/jasperserver-pro/"/>

<property name="ireport.jasperserver.user" value="superuser"/>

<property name="ireport.jasperserver.report.resource" value="/organizations/organization_1/reports/Scheduled_Reports/Commission_Report_updated12_files/main_jrxml"/>

<property name="ireport.jasperserver.reportUnit" value="/organizations/organization_1/reports/Scheduled_Reports/Commission_Report_updated12"/>

<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>

<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true"/>

 

 

 

<field name="Deal_ID" class="java.lang.Integer"/>

<field name="Case ID" class="java.lang.Long"/>

<field name="Client Name" class="java.lang.String"/>

<field name="Business Name" class="java.lang.String"/>

<field name="Case Status" class="java.lang.String"/>

<field name="Funded Date" class="java.sql.Date"/>

<field name="Funded Amount" class="java.lang.Double"/>

<field name="Factor Rate" class="java.lang.Double"/>

<field name="Term" class="java.lang.String"/>

<field name="Lender Name" class="java.lang.String"/>

<field name="FRSA Uploaded" class="java.lang.String"/>

<field name="Renewal" class="java.lang.String"/>

<field name="B2C Borrower Fee Per" class="java.math.BigDecimal"/>

<field name="B2C Borrower Fee" class="java.lang.Double"/>

<field name="B2C Lender Fee Per" class="java.lang.Double"/>

<field name="B2C Lender Fee" class="java.lang.Double"/>

<field name="Total Fees Recieved" class="java.lang.Double"/>

<field name="Referral Partner" class="java.lang.String"/>

<field name="Referral Partner's Per" class="java.lang.Double"/>

<field name="Fess Payable to others" class="java.lang.Double"/>

<field name="Commissionable Fees" class="java.lang.Double"/>

<field name="Case Notes" class="java.lang.String"/>

<field name="Case Manager Name" class="java.lang.String"/>

<variable name="Commissionable Fees1" class="java.lang.Double" resetType="Column" calculation="Sum">

<variableExpression><![CDATA[$F{Commissionable Fees}]]></variableExpression>

</variable>

<variable name="Fess Payable to others1" class="java.lang.Double" resetType="Column" calculation="Sum">

<variableExpression><![CDATA[$F{Fess Payable to others}]]></variableExpression>

</variable>

<variable name="Total Fees Recieved1" class="java.lang.Double" resetType="Column" calculation="Sum">

<variableExpression><![CDATA[$F{Total Fees Recieved}]]></variableExpression>

</variable>

<variable name="B2C Lender Fee1" class="java.lang.Double" resetType="Column" calculation="Sum">

<variableExpression><![CDATA[$F{B2C Lender Fee}]]></variableExpression>

</variable>

<variable name="B2C Borrower Fee1" class="java.lang.Double" resetType="Column" calculation="Sum">

<variableExpression><![CDATA[$F{B2C Borrower Fee}]]></variableExpression>

</variable>

<variable name="Funded Amount1" class="java.lang.Double" resetType="Column" calculation="Sum">

<variableExpression><![CDATA[$F{Funded Amount}]]></variableExpression>

</variable>

<background>

<band splitType="Stretch"/>

</background>

<title>

<band height="50" splitType="Stretch">

<property name="com.jaspersoft.studio.unit.height" value="pixel"/>

<staticText>

<reportElement mode="Opaque" x="0" y="0" width="3450" height="50" forecolor="#993300" backcolor="#FFFFCC" uuid="67ee3365-f04c-4220-b920-cd8b09f54369"/>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="14" isBold="true"/>

</textElement>

<text><![CDATA[Commission Report of the Month]]></text>

</staticText>

</band>

</title>

<pageHeader>

<band height="36" splitType="Stretch">

<textField pattern="M/d/yy">

<reportElement x="0" y="0" width="3450" height="36" uuid="681f40ba-f396-4017-b93c-6927f8467e4a"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="11"/>

</textElement>

<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>

</textField>

</band>

</pageHeader>

<columnHeader>

<band height="30" splitType="Stretch">

<staticText>

<reportElement mode="Opaque" x="0" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="a0caee4c-d38f-43f5-8ec4-5a694f8fc7fa"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Deal ID]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="150" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="b648f91a-33c4-43ad-8d76-090bcc2e4564"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Case ID]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="300" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="5dae1afb-629b-4edc-aa6a-e9a2b1f95f83"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Client Name]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="450" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="ad2a6c63-1c23-4a4b-b5fc-2e611d5bbe89"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[business Name]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="600" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="13a97385-c5fa-4d0a-b222-da8736db326e"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Case Status]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="750" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="413d5feb-5e47-4dc8-8b3d-7a7a6e51025e"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Funded Date]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="900" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="853bc6d1-bb42-478d-bf59-4a905f32d8de"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Funded Amount]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1050" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="3bca143c-84c8-429d-ab9e-3843cc1d6710"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Factor Rate]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1200" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="3a559b5b-4bce-434f-a4e8-9bd76ed0170e"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Term]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1350" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="a0168cba-faeb-4da4-ac0e-dfb324201969"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Lender Name]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1500" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="0ba635e4-6e75-48cf-9657-6f2ad612195a"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[FRSA Uploaded]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1650" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="017ae46d-48b6-42aa-94c1-148599fecbe1"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Renewal]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1800" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="6f6c1673-80ce-4125-8d63-45b1d49a4f87"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[b2C Borrower Fee %]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="1950" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="8c9a799f-147a-482f-b136-cebd9dcb9502"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[b2C Borrower Fee]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="2100" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="ae99d74a-b5e6-4529-90ed-cbf99e43c44b"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[b2C Lender Fee %]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="2250" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="c0ead956-0bf1-4362-a62a-db7ca18eafde"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[b2C Lender Fee]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="2400" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="d57b6097-4784-4317-bf71-9aec0574de7b"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Total Fees Recieved]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="2550" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="3640b2f5-260c-4026-89b5-7adb5bdf1248"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Referral Partner]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="2700" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="2d48d90a-1b7b-40d5-b4a2-5280dfc5afbf"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Referral Partner's %]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="2850" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="4543205a-b8d5-4f51-bea2-5043a81bb3ba"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Fess Payable to others]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="3000" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="1626e9ea-bc95-48ac-a7fc-fe07173a11ff"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Commissionable Fees]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="3150" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="3d3500e0-d4ee-4f75-842c-796a6061d405"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Case Notes]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="3300" y="0" width="150" height="30" forecolor="#993300" backcolor="#FFFFCC" uuid="71e380a7-54af-4239-ba08-647b97c645af"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Case Manager Name]]></text>

</staticText>

</band>

</columnHeader>

<detail>

<band height="30" splitType="Stretch">

<textField pattern="##########" isBlankWhenNull="true">

<reportElement x="0" y="0" width="150" height="30" uuid="f8c9ab35-6c72-459f-a6aa-5f4aed91a669"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Deal_ID}]]></textFieldExpression>

</textField>

<textField pattern="##########" isBlankWhenNull="true">

<reportElement x="150" y="0" width="150" height="30" uuid="e8fa4d64-b57c-4ec4-976a-efeba4c7ea08"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Case ID}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="300" y="0" width="150" height="30" uuid="820f98e8-8b06-402c-a37b-24c035e810b0"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Client Name}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="450" y="0" width="150" height="30" uuid="2118d408-2b43-4fdb-af54-9ba6f236a1f7"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Business Name}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="600" y="0" width="150" height="30" uuid="d6556825-3069-4005-97bd-c2dc407766ab"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Case Status}]]></textFieldExpression>

</textField>

<textField pattern="M/d/yy" isBlankWhenNull="true">

<reportElement x="750" y="0" width="150" height="30" uuid="165feceb-98a5-4e86-a336-eda09c842b4f"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Funded Date}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="900" y="0" width="150" height="30" uuid="f7c79e45-09d7-4b0d-b89d-87af6d9a556b"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Funded Amount}]]></textFieldExpression>

</textField>

<textField pattern="###.##" isBlankWhenNull="true">

<reportElement x="1050" y="0" width="150" height="30" uuid="3ca2907b-ad5e-4d34-bd21-339500aa7a27"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Factor Rate}]]></textFieldExpression>

</textField>

<textField pattern="##########" isBlankWhenNull="true">

<reportElement x="1200" y="0" width="150" height="30" uuid="eab6ff44-e073-4a07-9e01-05ab2cc32beb"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Term}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="1350" y="0" width="150" height="30" uuid="9687a42a-0525-4783-bfa7-e7c3adf1998b"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Lender Name}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="1500" y="0" width="150" height="30" uuid="4515c766-e9e0-485d-ad37-88b67455a77c"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{FRSA Uploaded}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="1650" y="0" width="150" height="30" uuid="e42c816e-61fb-42d2-8725-271a1ab1dcba"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Renewal}]]></textFieldExpression>

</textField>

<textField pattern="###0.##%" isBlankWhenNull="true">

<reportElement x="1800" y="0" width="150" height="30" uuid="c2509563-4929-4c3c-a6cf-aa20e36a2f40"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{B2C Borrower Fee Per}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="1950" y="0" width="150" height="30" uuid="0a9eec5f-2a53-4e19-ab7c-269c97850b5e"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{B2C Borrower Fee}]]></textFieldExpression>

</textField>

<textField pattern="###0.##%" isBlankWhenNull="true">

<reportElement x="2100" y="0" width="150" height="30" uuid="4f1454b9-227d-43da-aec4-66098e32e951"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{B2C Lender Fee Per}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="2250" y="0" width="150" height="30" uuid="61f3ecaf-404e-450b-90cf-ffb75c0e4dd6"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{B2C Lender Fee}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="2400" y="0" width="150" height="30" uuid="56aa0626-33c6-4c71-9154-25afffa0cdae"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Total Fees Recieved}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="2550" y="0" width="150" height="30" uuid="0bbf4f0a-7a14-4a51-bbef-4733f07f3419"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Referral Partner}]]></textFieldExpression>

</textField>

<textField pattern="###0.##%" isBlankWhenNull="true">

<reportElement x="2700" y="0" width="150" height="30" uuid="6e34a246-1799-42c1-8575-ac06a985414f"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Referral Partner's Per}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="2850" y="0" width="150" height="30" uuid="2be031f5-e848-4f84-bf97-1f8889c88ac5"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Fess Payable to others}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="3000" y="0" width="150" height="30" uuid="2bfbdd6f-2ac1-41d9-a4a1-49c704e31963"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Commissionable Fees}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="3150" y="0" width="150" height="30" uuid="5fc3008a-eedc-440f-8f55-e912fe4809be"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Case Notes}]]></textFieldExpression>

</textField>

<textField isBlankWhenNull="true">

<reportElement x="3300" y="0" width="150" height="30" uuid="83a4fe3c-5348-4360-bf71-082c3fc74cd9"/>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle"/>

<textFieldExpression><![CDATA[$F{Case Manager Name}]]></textFieldExpression>

</textField>

</band>

</detail>

<columnFooter>

<band height="30" splitType="Stretch">

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="3000" y="0" width="150" height="30" forecolor="#CC9900" uuid="271f2992-63ab-4995-ab53-fa8e7ee6ee9e">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{Commissionable Fees1}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="2850" y="0" width="150" height="30" forecolor="#CC9900" uuid="f09f727c-fee8-47c2-975d-bc575d0737be">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{Fess Payable to others1}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="2400" y="0" width="150" height="30" forecolor="#CC9900" uuid="39543fbe-4510-467e-a707-4541aa3f9ed7">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{Total Fees Recieved1}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="2250" y="0" width="150" height="30" forecolor="#CC9900" uuid="09ebb505-8667-4f53-b84c-8fe1559d6ce2">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{B2C Lender Fee1}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="1950" y="0" width="150" height="30" forecolor="#CC9900" uuid="0d81b890-979a-4dd9-a0dd-8545120bd747">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{B2C Borrower Fee1}]]></textFieldExpression>

</textField>

<textField pattern="$#,##0;$-#,##0" isBlankWhenNull="true">

<reportElement x="900" y="0" width="150" height="30" forecolor="#CC9900" uuid="25fd4d42-89b7-4ed9-ada0-a53aca638afd">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{Funded Amount1}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="0" y="0" width="150" height="30" forecolor="#CC9900" uuid="5f6aab80-6e87-45b6-9283-dfffa611e86d">

<property name="com.jaspersoft.studio.unit.x" value="pixel"/>

<property name="com.jaspersoft.studio.unit.width" value="pixel"/>

</reportElement>

<box>

<topPen lineWidth="0.5"/>

<leftPen lineWidth="0.5"/>

<bottomPen lineWidth="0.5"/>

<rightPen lineWidth="0.5"/>

</box>

<textElement verticalAlignment="Middle">

<font size="12" isBold="true"/>

</textElement>

<text><![CDATA[Total]]></text>

</staticText>

</band>

</columnFooter>

<summary>

<band height="42" splitType="Stretch"/>

</summary>

</jasperReport>

 

Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...