no Pagination does not work for subreport

pawankumar.singh · November 15, 2019

Hi Experts,

As we are trying to make a master report which contains 5 subreoprt. And, our all subreports working fine independently. However, when we call to Master report using subreport element it creates muliple pages. According to logic when we using 5 subreoprts Reports there must be only 5 pages as we uses pagination property in all subreports. can any one suggest how to achive all the 5 subreports in 5 different pages.

Thanks

Pawan Kumar Singh

C-Box · November 15, 2019

You could create a (dummy)group per each subReport with a static groupexpression "Sr1", "Sr2", "Sr3"... and so on with the flag "StartOnNewPage" to let each SubReport start on a new Page. Then put your SubReport into the groupheader bands instead of the detail (where you have probably placed it now)

Not tried, but should actually work. Otherwise a PageBreakElement after each of the first 4 consecutive SubReports in detail band could also help ;-) (but if the last subreport doesn't render any data, you will have an empty page probably, that isn't wanted, correct - also if some between won't render data)

Alternativly you can pass a "hidden" SubReportParameter "DoPageBreakBecauseOfMasterCall" with value Boolean.TRUE" to each SubReport and in each SubReport you place a PageBreak Element into the Summary with PrintWhenExpression $P{DoPageBreakBecauseOfMasterCall}.

So many ways are leading to Rome ;-)

hth + regards

C-Box

pawankumar.singh · November 16, 2019

Thanks, Man. And I Appreciate it for your help.

Can you please share an example for the Alternative option as above are not working in my case as I am new to jasper.

Thanks

pawankumar.singh · November 16, 2019

Problem is, my 2 subreports have a huge number of rows that overflow to multiple pages when we try to execute the report. Individually the same report working fine. I just want to know how to control the overflow of data.

Regards

pawankumar.singh · November 16, 2019

Below are the JRXML for Master reports

<?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="Excel Active Request LHO" pageWidth="1595" pageHeight="5000" columnWidth="1555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b44435ef-bf9b-4c2c-97c8-46e9f55837ba">
 <property name="com.jaspersoft.studio.data.defaultdataadapter" value="SDM"/>
 <property name="net.sf.jasperreports.page.break.no.pagination" value="apply"/>
 <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/>
 <property name="net.sf.jasperreports.export.xls.sheet.names.sheet1" value="Summary"/>
 <property name="net.sf.jasperreports.export.xls.sheet.names.sheet2" value="TeamWise Details"/>
 <property name="net.sf.jasperreports.export.xls.sheet.names.sheet3" value="Analyst Details"/>
 <property name="net.sf.jasperreports.export.xls.sheet.names.sheet6" value="Rating Details"/>
 <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="com.jaspersoft.studio.data.sql.tables" value=""/>
 <parameter name="StartDate" class="java.sql.Timestamp"/>
 <parameter name="EndDate" class="java.sql.Timestamp"/>
 <parameter name="Location" class="java.util.Collection"/>
 <queryString>
 <![CDATA[sELECT
b.z_l_code
FROM analyst_call a
JOIN ca_location b
ON a.location_uuid=b.location_uuid
JOIN ca_resource_department c
ON a.department=c.id
JOIN durr d
ON a.id=d.id
FULL OUTER JOIN suv_req_data_last e
ON a.id=e.object_id
JOIN ca_organization f ON a.admin_organization_uuid=f.organization_uuid
WHERE
c.name='ITSS LHO'
and
a.opendate BETWEEN $P{StartDate} and $P{EndDate}
and
$X{IN,location_name,Location}

GROUP BY
b.location_name,
b.z_l_code

order by b.location_name desc]]>
 </queryString>
 <field name="Z_L_CODE" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="Z_L_CODE"/>
 </field>
 <group name="Summary" isStartNewPage="true">
 <groupExpression><![CDATA["S1"]]></groupExpression>
 <groupHeader>
 <band height="236">
 <subreport>
 <reportElement x="-20" y="10" width="1555" height="200" uuid="a9d9f81a-b0e1-461f-9b02-74745bc7f5a4">
 <property name="net.sf.jasperreports.export.xls.break.after.row" value="true"/>
 </reportElement>
 <subreportParameter name="StartDate">
 <subreportParameterExpression><![CDATA[$P{StartDate}]]></subreportParameterExpression>
 </subreportParameter>
 <subreportParameter name="EndDate">
 <subreportParameterExpression><![CDATA[$P{EndDate}]]></subreportParameterExpression>
 </subreportParameter>
 <subreportParameter name="Location">
 <subreportParameterExpression><![CDATA[$P{Location}]]></subreportParameterExpression>
 </subreportParameter>
 <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 <subreportExpression><![CDATA["Summary_LHO_Details.jasper"]]></subreportExpression>
 </subreport>
 <break>
 <reportElement x="0" y="220" width="1555" height="1" uuid="cd144f1c-991e-4ec2-b674-3bb6fa713d12"/>
 </break>
 </band>
 </groupHeader>
 <groupFooter>
 <band height="50"/>
 </groupFooter>
 </group>
 <group name="Ratings">
 <groupExpression><![CDATA["S4"]]></groupExpression>
 <groupHeader>
 <band height="4881">
 <subreport>
 <reportElement x="0" y="13" width="1555" height="4847" uuid="6bf946ea-445c-45b7-8c73-bc2c8d36e22a"/>
 <subreportParameter name="StartDate">
 <subreportParameterExpression><![CDATA[$P{StartDate}]]></subreportParameterExpression>
 </subreportParameter>
 <subreportParameter name="EndDate">
 <subreportParameterExpression><![CDATA[$P{EndDate}]]></subreportParameterExpression>
 </subreportParameter>
 <subreportParameter name="Location">
 <subreportParameterExpression><![CDATA[$P{Location}]]></subreportParameterExpression>
 </subreportParameter>
 <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
 <subreportExpression><![CDATA["Ratings Details LHO.jasper"]]></subreportExpression>
 </subreport>
 <break>
 <reportElement x="0" y="4866" width="1555" height="1" uuid="735691e8-e2aa-4b42-ac01-ffc7f6f9d835"/>
 </break>
 </band>
 </groupHeader>
 <groupFooter>
 <band height="50"/>
 </groupFooter>
 </group>
 <background>
 <band splitType="Stretch"/>
 </background>
 <title>
 <band height="79" splitType="Stretch"/>
 </title>
 <summary>
 <band height="42" splitType="Stretch"/>
 </summary>
</jasperReport>

And Sub report whoes data is overflowing

<?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="Ratings Details LHO" pageWidth="1595" pageHeight="5000" columnWidth="1555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="c18d123e-2188-4619-aeef-97caccb1a29b">
 <property name="com.jaspersoft.studio.data.defaultdataadapter" value="SDM"/>
 <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="com.jaspersoft.studio.data.sql.tables" value=""/>
 <parameter name="StartDate" class="java.sql.Timestamp"/>
 <parameter name="EndDate" class="java.sql.Timestamp"/>
 <parameter name="Location" class="java.util.Collection"/>
 <queryString>
 <![CDATA[select
a.ref_num,
a.userid,
a.analyst,
c.txt,
c.nx_comment,
c.date1,
c.sequence,
c.rating_provider,
d.location_name
from
survey_call a join ca_location d on a.location_uuid=d.location_uuid,
group_name b,
suv_req_data_last c
where
a.id=b.id
and
$X{IN,d.location_name,Location}
and
a.id=c.object_id
and
c.date1 BETWEEN $P{StartDate} AND $P{EndDate}
ORDER BY d.location_name]]>
 </queryString>
 <field name="REF_NUM" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="REF_NUM"/>
 </field>
 <field name="USERID" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="USERID"/>
 </field>
 <field name="ANALYST" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="ANALYST"/>
 </field>
 <field name="TXT" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="TXT"/>
 </field>
 <field name="NX_COMMENT" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="NX_COMMENT"/>
 </field>
 <field name="DATE1" class="java.sql.Timestamp">
 <property name="com.jaspersoft.studio.field.label" value="DATE1"/>
 </field>
 <field name="SEQUENCE" class="java.math.BigDecimal">
 <property name="com.jaspersoft.studio.field.label" value="SEQUENCE"/>
 </field>
 <field name="RATING_PROVIDER" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="RATING_PROVIDER"/>
 </field>
 <field name="LOCATION_NAME" class="java.lang.String">
 <property name="com.jaspersoft.studio.field.label" value="LOCATION_NAME"/>
 </field>
 <group name="Rating">
 <groupExpression><![CDATA[$F{LOCATION_NAME}]]></groupExpression>
 <groupHeader>
 <band height="116">
 <textField>
 <reportElement mode="Opaque" x="25" y="3" width="630" height="67" forecolor="#F51BE6" uuid="bec2a681-fc33-4f6d-a42a-3a91813516b9"/>
 <textElement>
 
 </textElement>
 <textFieldExpression><![CDATA[$F{LOCATION_NAME}]]></textFieldExpression>
 </textField>
 <staticText>
 <reportElement mode="Opaque" x="0" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="9cf09d7a-a62f-473a-ae5c-ee17ab0d32ff">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5273bd69-b2f8-4f49-9ded-21869c0b488e"/>
 </reportElement>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
 <pen lineColor="#FFFFFF"/>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Analyst]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="100" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="856cb988-4520-4407-8044-85f1b7af2895">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cef5a9f5-84b0-48a8-9cb1-1aef90f277f8"/>
 </reportElement>
 <box>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[AnalystID]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="200" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="607ccd09-ec68-4479-a80b-fd75f41b7e84">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64b6c4f-6fba-468f-a6b5-90ef393a35ca"/>
 </reportElement>
 <box>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Request]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="300" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="6b674f0e-4a33-4f5b-9eaa-5367fdd7fefc">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4fc659bd-81b7-4e69-99cf-1dc3e08aa489"/>
 </reportElement>
 <box>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Rating]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="400" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="a03bea1f-3809-4fb3-a2fd-401343c4af12">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9e470ac1-277b-432d-92d4-48b4190513da"/>
 </reportElement>
 <box>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Rating Time]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="500" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="0ad91eb4-d9fd-436f-afb2-bff19eeab07a">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f856ccb7-a388-457c-9eb4-be3f6b6e483d"/>
 </reportElement>
 <box>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Rating Provider]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="600" y="70" width="100" height="46" forecolor="#FFFFFF" backcolor="#6647ED" uuid="1fb7a217-6782-4e01-b63a-6fe73ec753b0">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a6c0d570-4fdb-44a9-9af0-0cb018d462dd"/>
 </reportElement>
 <box>
 <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
 </box>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Comment]]></text>
 </staticText>
 </band>
 </groupHeader>
 <groupFooter>
 <band height="50"/>
 </groupFooter>
 </group>
 <background>
 <band splitType="Stretch"/>
 </background>
 <title>
 <band height="80" splitType="Stretch">
 <staticText>
 <reportElement x="0" y="40" width="710" height="40" uuid="6e0f44f3-5d8e-47c7-907b-15f19cd633a3"/>
 <textElement textAlignment="Center" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Rating Details]]></text>
 </staticText>
 </band>
 </title>
 <detail>
 <band height="40" splitType="Stretch">
 <textField>
 <reportElement x="0" y="0" width="100" height="40" uuid="ca37161c-fe4c-4b84-a12b-b746123f70d0">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5273bd69-b2f8-4f49-9ded-21869c0b488e"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[$F{ANALYST}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="100" y="0" width="100" height="40" uuid="a574f5b9-d1e8-45f0-b20f-b231371a9524">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cef5a9f5-84b0-48a8-9cb1-1aef90f277f8"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[$F{USERID}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="200" y="0" width="100" height="40" uuid="cb994457-db69-4e4e-8bfd-dd7169b08c43">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c64b6c4f-6fba-468f-a6b5-90ef393a35ca"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[$F{REF_NUM}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="300" y="0" width="100" height="40" uuid="b2457c4d-4332-4f70-b87e-6c053f75fd58">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4fc659bd-81b7-4e69-99cf-1dc3e08aa489"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[($F{SEQUENCE})+" | "+$F{TXT}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="400" y="0" width="100" height="40" uuid="16ba1472-4ff2-4efd-bf4f-e6f456848579">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9e470ac1-277b-432d-92d4-48b4190513da"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[$F{DATE1}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="500" y="0" width="100" height="40" uuid="d7f6347b-6a65-45f0-944a-8e2fc0d9af09">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f856ccb7-a388-457c-9eb4-be3f6b6e483d"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[$F{RATING_PROVIDER}]]></textFieldExpression>
 </textField>
 <textField>
 <reportElement x="600" y="0" width="100" height="40" uuid="f710384e-be0e-4b09-a9e1-c793d3deac1e">
 <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a6c0d570-4fdb-44a9-9af0-0cb018d462dd"/>
 <property name="net.sf.jasperreports.style.isBlankWhenNull" value="true"/>
 </reportElement>
 <box>
 <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"/>
 <textFieldExpression><![CDATA[$F{NX_COMMENT}]]></textFieldExpression>
 </textField>
 </band>
 </detail>
 <summary>
 <band height="42" splitType="Stretch"/>
 </summary>
</jasperReport>

If i have done anything wrong please correct me.

Thanks

pawankumar.singh · November 20, 2019

Issue is resolved by using Report Book.

Thanks

Pawan

Sign In

no Pagination does not work for subreport

Recommended Posts

pawankumar.singh

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

C-Box

Link to comment

Share on other sites

pawankumar.singh

Link to comment

Share on other sites

pawankumar.singh

Link to comment

Share on other sites

pawankumar.singh

Link to comment

Share on other sites

pawankumar.singh

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore