[How to get total sum within the same date]

Just Create a variable and place it in first column

variable is $F{Field_Name}+1500 for integer/douible/long values.

[Where do I have to initialize REPORT_PARAMETER_MAP and their 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

[Remove dublicate value]

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

[Remove dublicate value]

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.

 

[Remove dublicate value]

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-%';

[Remove dublicate value]

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

[Dynamic timestamp parameter]

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

[Dynamic timestamp parameter]

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

[Count if it contains string="1 Week"]

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

[Count if it contains string="1 Week"]

Resolved Thanks 

 

[How to configure a data adapter for Oracle]

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

Thanks

Pawan

[Count if it contains string="1 Week"]

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 

[Timestamp Manipulation possible?]

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

[Report not splitting]

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 

[no Pagination does not work for subreport]

Issue is resolved by using Report Book.

Thanks

Pawan

[Report Book creating multiple reports.]

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

[Subreport which contains a JasperReports Server Report]

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

[Subreport which contains a JasperReports Server Report]

yes you can.

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

Thanks

Pawan

[Brackets around $P!(UICFILTER2)) clause]

can you please post your query.

As you $P,$X is the different format paramter used for different purpose.

Thanks

Pawan

[Videos or practical examples on doing math with variables in Jaspersoft Studio]

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

[no Pagination does not work for subreport]

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

 

[no Pagination does not work for subreport]

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

 

[no Pagination does not work for subreport]

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  

[Subreports / Pagination]

Hi, 

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

Thanks

[no Pagination does not work for subreport]

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