Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="subReportDemo" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
- <property name="ireport.zoom" value="1.0"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="0"/>
- <import value="ledger.account.*"/>
- <style name="table">
- <box>
- <pen lineWidth="1.0" lineColor="#000000"/>
- </box>
- </style>
- <style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
- <box>
- <pen lineWidth="0.5" lineColor="#000000"/>
- </box>
- </style>
- <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
- <box>
- <pen lineWidth="0.5" lineColor="#000000"/>
- </box>
- </style>
- <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
- <box>
- <pen lineWidth="0.5" lineColor="#000000"/>
- </box>
- </style>
- <subDataset name="Table Dataset 1"/>
- <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
- <defaultValueExpression><![CDATA["F:\\workspace\\ExtraCare\\src\\helper\\"]]></defaultValueExpression>
- </parameter>
- <parameter name="openingBalance" class="java.lang.String"/>
- <parameter name="closingBalance" class="java.lang.String"/>
- <parameter name="openingBalanceSymbol" class="java.lang.String"/>
- <parameter name="closingBalanceSymbol" class="java.lang.String"/>
- <field name="vDate" class="java.lang.String"/>
- <field name="vNo" class="java.lang.String"/>
- <field name="debitAmount" class="java.lang.Double"/>
- <field name="creditAmount" class="java.lang.Double"/>
- <field name="currentBalance" class="java.lang.Double"/>
- <field name="currentBalanceSymbol" class="java.lang.String"/>
- <field name="subReportName" class="java.lang.String"/>
- <field name="parti" class="java.util.List"/>
- <field name="discount" class="java.lang.Double"/>
- <field name="roundOff" class="java.lang.Double"/>
- <field name="roundOffSymbol" class="java.lang.String"/>
- <field name="salesman" class="java.lang.String"/>
- <field name="kasar" class="java.lang.Double"/>
- <variable name="creditLineTotal" class="java.lang.String"/>
- <variable name="debitLineTotal" class="java.lang.String"/>
- <variable name="balanceLineTotal" class="java.lang.String"/>
- <variable name="balanceLineTotalSymbol" class="java.lang.String"/>
- <variable name="caretPosition" class="java.lang.Integer" resetType="Column">
- <variableExpression><![CDATA[$F{vDate}.lastIndexOf("-")]]></variableExpression>
- </variable>
- <background>
- <band splitType="Stretch"/>
- </background>
- <title>
- <band height="79" splitType="Stretch"/>
- </title>
- <pageHeader>
- <band height="27" splitType="Stretch">
- <frame>
- <reportElement x="3" y="0" width="552" height="24"/>
- <image>
- <reportElement x="2" y="0" width="20" height="18"/>
- <imageExpression class="java.lang.String"><![CDATA["F:\\workspace\\ExtraCare\\WebRoot\\images\\userinfo.gif"]]></imageExpression>
- </image>
- <textField>
- <reportElement x="29" y="0" width="520" height="20"/>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$P{openingBalance}]]></textFieldExpression>
- </textField>
- <line>
- <reportElement x="3" y="21" width="546" height="3"/>
- </line>
- </frame>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="20" splitType="Stretch">
- <frame>
- <reportElement x="0" y="0" width="802" height="20"/>
- <staticText>
- <reportElement x="626" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Credit]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="0" width="44" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Date]]></text>
- </staticText>
- <staticText>
- <reportElement x="44" y="0" width="73" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Number]]></text>
- </staticText>
- <staticText>
- <reportElement x="117" y="0" width="431" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Particulars]]></text>
- </staticText>
- <staticText>
- <reportElement x="548" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Debit]]></text>
- </staticText>
- <staticText>
- <reportElement x="704" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Balance]]></text>
- </staticText>
- </frame>
- <staticText>
- <reportElement x="782" y="0" width="20" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[]]></text>
- </staticText>
- </band>
- </columnHeader>
- <detail>
- <band height="20" splitType="Stretch">
- <frame>
- <reportElement x="0" y="0" width="802" height="20"/>
- <subreport isUsingCache="true" runToBottom="false">
- <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="117" y="0" width="430" height="20" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true">
- <printWhenExpression><![CDATA[$F{subReportName}.equals( "subReportDemo_subreport1.jasper" )]]></printWhenExpression>
- </reportElement>
- <subreportParameter name="salesman">
- <subreportParameterExpression><![CDATA[$F{salesman}]]></subreportParameterExpression>
- </subreportParameter>
- <subreportParameter name="kasar">
- <subreportParameterExpression><![CDATA[$F{kasar}]]></subreportParameterExpression>
- </subreportParameter>
- <subreportParameter name="roundoff">
- <subreportParameterExpression><![CDATA[$F{roundOff}]]></subreportParameterExpression>
- </subreportParameter>
- <subreportParameter name="roundoffSymbol">
- <subreportParameterExpression><![CDATA[$F{roundOffSymbol}]]></subreportParameterExpression>
- </subreportParameter>
- <subreportParameter name="discount">
- <subreportParameterExpression><![CDATA[$F{discount}]]></subreportParameterExpression>
- </subreportParameter>
- <dataSourceExpression><![CDATA[$F{subReportName}.equals( "subReportDemo_subreport1.jasper" ) ? new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{parti}) : new JREmptyDataSource()]]></dataSourceExpression>
- <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "/subReportDemo_subreport1.jasper"]]></subreportExpression>
- </subreport>
- <textField isBlankWhenNull="true">
- <reportElement stretchType="RelativeToTallestObject" x="44" y="0" width="73" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{vNo}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement stretchType="RelativeToTallestObject" x="626" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.Double"><![CDATA[$F{creditAmount}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" isBlankWhenNull="true">
- <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="44" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.String"><![CDATA[($F{vDate}.substring(0,$V{caretPosition}.intValue()+1) +
- $F{vDate}.substring(($V{caretPosition}.intValue()+3),$F{vDate}.length()))]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement stretchType="RelativeToTallestObject" x="548" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.Double"><![CDATA[$F{debitAmount}]]></textFieldExpression>
- </textField>
- <subreport runToBottom="false">
- <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="117" y="0" width="430" height="20" isRemoveLineWhenBlank="true">
- <printWhenExpression><![CDATA[$F{subReportName}.equals( "paymentSuReport.jasper" )]]></printWhenExpression>
- </reportElement>
- <subreportParameter name="kasar">
- <subreportParameterExpression><![CDATA[$F{kasar}]]></subreportParameterExpression>
- </subreportParameter>
- <dataSourceExpression><![CDATA[$F{subReportName}.equals( "paymentSuReport.jasper" ) ? new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{parti}) : new JREmptyDataSource()]]></dataSourceExpression>
- <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "\\paymentSuReport.jasper"]]></subreportExpression>
- </subreport>
- <subreport>
- <reportElement x="117" y="0" width="430" height="20" isRemoveLineWhenBlank="true">
- <printWhenExpression><![CDATA[$F{subReportName}.equals( "cashSubReport.jasper" )]]></printWhenExpression>
- </reportElement>
- <dataSourceExpression><![CDATA[$F{subReportName}.equals( "cashSubReport.jasper" ) ? new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{parti}) : new JREmptyDataSource()]]></dataSourceExpression>
- <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "/cashSubReport.jasper"]]></subreportExpression>
- </subreport>
- <frame>
- <reportElement x="117" y="0" width="431" height="20"/>
- <box>
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- </frame>
- </frame>
- <textField isBlankWhenNull="true">
- <reportElement stretchType="RelativeToTallestObject" x="782" y="0" width="20" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.String"><![CDATA[$F{currentBalanceSymbol}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement stretchType="RelativeToTallestObject" x="704" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement verticalAlignment="Middle"/>
- <textFieldExpression class="java.lang.Double"><![CDATA[$F{currentBalance}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <columnFooter>
- <band height="20" splitType="Stretch">
- <frame>
- <reportElement x="0" y="0" width="802" height="20"/>
- <box>
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <staticText>
- <reportElement x="0" y="0" width="367" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <text><![CDATA[Total]]></text>
- </staticText>
- <textField isBlankWhenNull="true">
- <reportElement x="547" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{debitLineTotal}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="626" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{creditLineTotal}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="704" y="0" width="78" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{balanceLineTotal}]]></textFieldExpression>
- </textField>
- <textField isBlankWhenNull="true">
- <reportElement x="782" y="0" width="20" height="20"/>
- <box leftPadding="1">
- <pen lineWidth="1.0"/>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement/>
- <textFieldExpression class="java.lang.String"><![CDATA[$V{balanceLineTotalSymbol}]]></textFieldExpression>
- </textField>
- </frame>
- </band>
- </columnFooter>
- <pageFooter>
- <band height="54" splitType="Stretch"/>
- </pageFooter>
- <summary>
- <band height="42" splitType="Stretch"/>
- </summary>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement