pawankumar.singh

Just Create a variable and place it in first column variable is $F{Field_Name}+1500 for integer/douible/long values.

can you please elaborate the issue. As it seems like you are not able to map the parameter of main report to subreports. If this is right then no worrry use belwo steps to achive your goal 1. when you are using the subreport element the it ask to create/select the report then just select the report from workspace 2. Click next then it ask for report connection then select same datasource as main report 3. Then if your subreport have parameter then listed over there after clicking next. over there you can check what different parameter you have and work accordingly. 4. If you have already created the subreport then you need to Right click on subreport element then go to show properties --> in right hand side you are able to see subreport section over there you can add or delete the parameter listed or used. Hope this Help! pawan

Just Found the Solution for that is to use group band.

Yes tried but as you saw in the image what i have uploaded over ther one column for which value is not repeated. What i want is just remove the whole line if first column value is repeated.

Query what we uses: select d.ref_num,d.sym as Type,d.analyst,d.descr,d.last_mod_date,a.severity,c.location_uuid,a.type as Request,b.last_name as Assignee,a.status, 3 To_timestamp(to_char(to_date('01-01-1970 05:30:00' , 'DD-MM-YYYY HH24:MI:SS')+a.open_date/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') as Open_Date 4 from 5 call_req a JOIN 6 (select a.ref_num,e.sym as category, 7 To_timestamp(to_char(to_date('01-01-1970 05:30:00' , 'DD-MM-YYYY HH24:MI:SS')+a.last_mod_dt/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') as last_mod_date, 8 d.sym,c.last_name as Analyst,to_char(b.description) as Descr 9 from call_req a,act_log b,ca_contact c,act_type d,prob_ctg e 10 where a.persid=b.call_req_id and b.type=d.code and b.analyst=c.contact_uuid and a.category=e.persid and b.time_stamp=(select max( DISTINCT act_log.time_stamp) from act_log where act_log.call_req_id=a.persid) and a.status not like 'CL') d 11 ON a.ref_num=d.ref_num 12 JOIN ca_contact b ON a.assignee=b.contact_uuid 13 JOIN ca_contact c ON a.customer=c.contact_uuid 14 where d.category LIKE 'Finacle.%' OR d.category LIKE 'FO-%';

Hi, In our report rows were repeated. can any tell how to remove the row from report using particular field as we tried different thing like: 1. Using Distinct in query 2.Using Lag function 3.using lead function 4. Tried with variable as well. PLease help it is uregent. Problem is attched. help is appreciated and Thanks in advance! Regards Pawan

Thanks, Man, I resolved the issue by using report book. What I have done is: 1. Create the Abstract Book Report 2. Call the main report in which i need to put the dynamic value in Abstract book 3. Run the query a simple query like (select add_months(current_timestamp,-1) as date_time from dual;) that return a date (today date subtract 1 month) that vlaue stores in the field. 4. And then just pass that value in Subreport as static parameter in $P{Today} and get the result. Regards Pawan

Hi Folks, we want to pass the dynamic timestamp in jasper reports like from $P{today}-Month/Weeks/Days in our oracle queries in jasper studio. currently, we are using static parameters in our query but now we want to schedule the reports and need to pass dynamic dates in reports. can anyone assist us for the same. Help is appreciated and Thanks in Advance. Thanks Pawan

new java.lang.Integer($F{WEEKS}.equals("1 Week" )? 1 : 0 ) use this and set calculation to sum

Resolved Thanks

Make sure you are able to telnet oracle database and try to login to database using sqlplus Thanks Pawan

Hi Guys, I need help to count the strings value that it how many times occurs in fields. I tried with using variable but no luck formate of my vairable is $F{Weeks}=="1 Week" and calculation is set to count/sum but it always return 0 value to variable. Help is appreciated ! Thanks In advance :) Thanks Pawan

use this function at SQL level to_timestamp(to_char(to_date('01-01-1970 <Time what want to add>' , 'DD-MM-YYYY HH24:MI:SS')+open_date/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') as per you requirment add you time in below format like below 5:30:00 in my it works hope it will help! Thanks Pawan

If you want report split then it is better option to use abstract book report over there you can easily split your reports. Thanks Pawan

Issue is resolved by using Report Book. Thanks Pawan

Can you please tell how you control it to master report tthe issue. As i have same issue.

Pardon Man, You use tag of jasper studio thats why i was thinking you are using jasper studio. At jasper levevl i have to check. BTW why are you using jasper server to make Reports instead of jasper studio? Thanks

yes you can. you can use subreport element in japser studio to achive your requirement. Thanks Pawan

can you please post your query. As you $P,$X is the different format paramter used for different purpose. Thanks Pawan

when you are creating variable then you can do First you just create variable and provide value class name like if you want to divide it by 3 then your field must be class of double/integer/long. After that you are able to divide by 3. eg. $V{CORN1_MEASURE}.doubleValue()/3 try this. Hope this will help. Pawan

Below are the JRXML for Master reports <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown --> <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"?> <!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown --> <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> <font size="18" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="12" isBold="true"/> </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"> <font size="24"/> </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

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

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

Hi, when we place all the subreports in summary band then overlapping of data is occuring. Thanks

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