sapna.singh Posted March 7, 2017 Share Posted March 7, 2017 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 andschedule 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 More sharing options...
hozawa Posted March 8, 2017 Share Posted March 8, 2017 Well, the first thing you should do is attach a sample report and a sample output and JasperReports Server version as well as your environment. Link to comment Share on other sites More sharing options...
sapna.singh Posted March 8, 2017 Author Share Posted March 8, 2017 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 More sharing options...
sapna.singh Posted March 17, 2017 Author Share Posted March 17, 2017 Please help. It's urgent. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now