How to use the same REPORT_COUNT in multiple tables incrementing it?

user_4388228 0
Viewed 1793

I'm using iReport 5.6 to generate reports for my JavaApp, I have three datasets where as bellow :

dataset1 query

SELECT * FROM players s WHERE s.role = 1

dataset2 query

SELECT * FROM players s WHERE s.role = 2

dataset3 query

SELECT * FROM players s WHERE s.role = 3

then I have created 3 Detail bands where I have put :

  • Detail 1 contains table1 that uses dataset1 : in this table I defined the headers that are the same for the other tables (2 and 3)

  • Detail 2 contains table2 that uses dataset2

  • Detail 3 contains table3 that uses dataset3

What I can't do is to add a count column using the $V{REPORT_COUNT} jasper variable for the three table that doesn't refresh the counting as seen in the picture below I want this counting to continue the incrementation.

jasper-reports
1 Answers

To achieve this you can use the possibility to specify returnValue from datasetRun (table) and then pass this to next datasetRun (table) as a datasetParameter

In example we will pass as returnValue the $V{REPORT_COUNT} (of the table) to a variabile in main report $V{currentRecordCnt}, the currentRecordCnt we will then pass to next datasetRun (table 2) and use this to increment a variabile in 2 dataset

<variable name="accRecordCnt" class="java.lang.Integer">
    <variableExpression><![CDATA[$P{currentRecordCnt}+$V{REPORT_COUNT}]]></variableExpression>
</variable>

We then pass the accRecordCnt back to main report's currentRecordCnt and repeat same for table 3.

Full jrxml example

<?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="AccuSum" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="85a44d77-bc70-4059-a88a-60aca0ef6bf0">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
    <subDataset name="Dataset1" uuid="5a00c263-2028-4446-948e-d614136ec5d7">
        <queryString>
            <![CDATA[]]>
        </queryString>
    </subDataset>
    <subDataset name="Dataset2" uuid="3ff8e779-2e60-403c-81f8-1d20fd04fc78">
        <parameter name="currentRecordCnt" class="java.lang.Integer"/>
        <queryString>
            <![CDATA[]]>
        </queryString>
        <variable name="accRecordCnt" class="java.lang.Integer">
            <variableExpression><![CDATA[$P{currentRecordCnt}+$V{REPORT_COUNT}]]></variableExpression>
        </variable>
    </subDataset>
    <subDataset name="Dataset3" uuid="3ff8e779-2e60-403c-81f8-1d20fd04fc78">
        <parameter name="currentRecordCnt" class="java.lang.Integer"/>
        <queryString>
            <![CDATA[]]>
        </queryString>
        <variable name="accRecordCnt" class="java.lang.Integer">
            <variableExpression><![CDATA[$P{currentRecordCnt}+$V{REPORT_COUNT}]]></variableExpression>
        </variable>
    </subDataset>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <variable name="currentRecordCnt" class="java.lang.Integer"/>
    <detail>
        <band height="54" splitType="Stretch">
            <componentElement>
                <reportElement x="0" y="10" width="540" height="30" uuid="c46d16ff-7b32-4481-8d89-0435f34f7b32">
                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                </reportElement>
                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                    <datasetRun subDataset="Dataset1" uuid="6b893feb-3e07-4393-ae4d-30b64e3dbaf5">
                        <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource(5)]]></dataSourceExpression>
                        <returnValue fromVariable="REPORT_COUNT" toVariable="currentRecordCnt"/>
                    </datasetRun>
                    <jr:column width="160" uuid="3b6f8589-0c6d-4709-a8cd-6cf642fd4ec9">
                        <jr:detailCell height="30">
                            <textField>
                                <reportElement x="0" y="0" width="160" height="30" uuid="a04fcd2b-e179-4fdb-8eac-31da14721c9a"/>
                                <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
                            </textField>
                        </jr:detailCell>
                    </jr:column>
                </jr:table>
            </componentElement>
        </band>
        <band height="50">
            <componentElement>
                <reportElement x="0" y="10" width="540" height="30" uuid="6866e777-15b8-49a7-b00f-3ce3593c16c0">
                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                </reportElement>
                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                    <datasetRun subDataset="Dataset2" uuid="f71b2649-27c0-4a30-bb68-8bc7c8a26100">
                        <datasetParameter name="currentRecordCnt">
                            <datasetParameterExpression><![CDATA[$V{currentRecordCnt}]]></datasetParameterExpression>
                        </datasetParameter>
                        <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource(5)]]></dataSourceExpression>
                        <returnValue fromVariable="accRecordCnt" toVariable="currentRecordCnt"/>
                    </datasetRun>
                    <jr:column width="160" uuid="6e116b9f-cf9f-4a27-9e9a-892263482caf">
                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
                        <jr:detailCell height="30">
                            <textField>
                                <reportElement x="0" y="0" width="160" height="30" uuid="8cb085f1-5155-4b17-9304-c3bb616ac965"/>
                                <textFieldExpression><![CDATA[$V{accRecordCnt}]]></textFieldExpression>
                            </textField>
                        </jr:detailCell>
                    </jr:column>
                </jr:table>
            </componentElement>
        </band>
        <band height="50">
            <componentElement>
                <reportElement x="0" y="10" width="540" height="30" uuid="338527a7-5c7e-419d-ac85-658ac2d30655">
                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                </reportElement>
                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
                    <datasetRun subDataset="Dataset3" uuid="8c00ef2e-d328-42a8-8ba5-12bfde8225c0">
                        <datasetParameter name="currentRecordCnt">
                            <datasetParameterExpression><![CDATA[$V{currentRecordCnt}]]></datasetParameterExpression>
                        </datasetParameter>
                        <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource(5)]]></dataSourceExpression>
                    </datasetRun>
                    <jr:column width="160" uuid="7e28ae8d-b64b-42fa-a5eb-4213198d1341">
                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
                        <jr:detailCell height="30">
                            <textField>
                                <reportElement x="0" y="0" width="160" height="30" uuid="05900214-f740-4742-bae3-f4a97aed073e"/>
                                <textFieldExpression><![CDATA[$V{accRecordCnt}]]></textFieldExpression>
                            </textField>
                        </jr:detailCell>
                    </jr:column>
                </jr:table>
            </componentElement>
        </band>
    </detail>
</jasperReport>

Output (with 1 empty record)

result

user_52923020
Related