Sub-Report Example

ktrinad · August 31, 2006

By: Darren - darren2003

Sub-Report Example

2003-02-28 04:45

Did anyone can post sub-report example to here? becoz I still do not understand the detail setting in sub-report, thank you!

By: Giulio Toffoli - gt78

RE: Sub-Report Example

2003-02-28 06:16

This post is material that I have sended more than two weeks ago to Shailesh Kadam to write a subreport tutorial...

This is not a tutorial, but a stating point that can help you...

Giulio

__________________________________________-

Instructions:

What I send to you:

1. master_example.xml (the master report)

2. subreport_example.xml (the subreport)

Note the parameter named SUBREPORT_FILE_NAME in master_example.xml: the expression is the name of the subreport file.

This is the trick that use iReport to find your self the subreport. (the name SUBREPORT_FILE_NAME is only evocative bat you

can change it...)

Also the step that you must fallow to create a subreport....

In the master document:

1. Create a parameter in wich store the file name (fully qualified by path, i.e. c:mypathtosubreport.jasper)

called i.e. SUBREPORT_FILE_NAME.

2. Add a subreport element.

3. Set in the tab named subreport1 in the element properties dialog for the subreport element added to the document

this values:

a) set Connection/Datasource Expression to "Use connectiopn Expression"

b) set as expression the built in barameter: $P{REPORT_CONNECTION}

4. Set in the tab named subreport2 in the element properties dialog for the subreport element added to the document

this values:

a) set Subreport Expression Class to class java.lang.String

b) set Subreport Expression to $P{SUBREPORT_FILE_NAME}

c) add a new subreport parameter (right click on the subreport parameters list to open the contextual menu)

- Set ADDRESSID as subreport parameters name

- Set a field of the local document as value for this parameter (in your case, we are linking addresses [master_example]

with documents totals è´¡ble documents] where addressid in documents is equal to the id of the address record.)

We have finished with the master.

Go to setting subreport_example.

1. Create a parameter (that will recive the ID value of the parent) named ADDRESSID (the type must be Integer due to the

ID value in the parent is a integer).

2. Adjust report query writing something like SELECT * FROM DOCUMENT WHERE ADDRESSID = $P{ADDRESSID}

3. Compile only the file due to create a file jasper, that will used by the master report.

Now, return to the master report, compile it and create the pdf. Remember to leave blank the query field in the compiler form.

I'm missing database connection config: they are the parameters to use creating a connection to the HSQL database

shipped with jasperreports...(you must use iR 0.0.8)

DATABASE=

DRIVER=org.hsqldb.jdbcDriver

NAME=JR_SampleDB

PASSWORD=

SAVE=false

URL=jdbc:hsqldb:C:\Documenti\progetti\iReport\jasperreports-0.4.5-project\JasperReports\demo\hsqldb/test

USERNAME=sa

You have to replace

C:\Documenti\progetti\iReport\jasperreports-0.4.5-project\JasperReports\demo\

with your path to the hsqldb directory...

We have finished. In the zip you will find the pdf generated. In this mail I have underlined to you only the most relevant

steps, I have not speak about reading fields form db, etc.. that are argoments that I assume already clear...

Good Look

Giulio

_____ MASTER_EXAMPLE.XML

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="Untitled_report_1"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="535"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

</parameter>

<queryString><![CDATA[

select * from address

]]></queryString>

</variable>

<title>

<reportElement

mode="Transparent"

x="61"

y="5"

width="412"

height="29"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Opaque"

x="0"

y="34"

width="534"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</line>

<reportElement

mode="Opaque"

x="0"

y="3"

width="534"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</line>

</band>

</title>

</band>

</pageHeader>

<reportElement

mode="Opaque"

x="0"

y="0"

width="535"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</line>

</band>

</columnHeader>

<reportElement

mode="Transparent"

x="1"

y="9"

width="535"

height="97"

forecolor="#808080"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="93"

y="17"

width="429"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="10"

y="17"

width="83"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="93"

y="34"

width="429"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="10"

y="34"

width="83"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="93"

y="51"

width="429"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="10"

y="51"

width="83"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="93"

y="68"

width="429"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="10"

y="68"

width="83"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="93"

y="85"

width="429"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="10"

y="85"

width="83"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Opaque"

x="-1"

y="108"

width="535"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<subreportParameterExpression><![CDATA[

$F{ID}

]]></subreportParameterExpression>

</subreportParameter>

<connectionExpression><![CDATA[

$P{REPORT_CONNECTION}

]]></connectionExpression>

<subreportExpression class="java.lang.String"><![CDATA[

$P{SUBREPORT_FILE_NAME}

]]></subreportExpression>

</subreport>

<reportElement

mode="Opaque"

x="0"

y="127"

width="534"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="Float"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</line>

<reportElement

mode="Opaque"

x="10"

y="1"

width="54"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

</band>

</detail>

</band>

</columnFooter>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="325"

y="4"

width="174"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" > <reportElement

mode="Transparent"

x="499"

y="4"

width="36"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Opaque"

x="1"

y="3"

width="535"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</line>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="1"

y="6"

width="209"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

_____SUBREPORT_EXAMPLE.XML________

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="SRWGCantieriProroghe"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="535"

pageHeight="782"

columnWidth="516"

columnSpacing="0"

leftMargin="0"

rightMargin="0"

topMargin="0"

bottomMargin="0"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<queryString><![CDATA[

SELECT * FROM DOCUMENT WHERE ADDRESSID = $P{ADDRESSID}

]]></queryString>

<title>

<reportElement

mode="Opaque"

x="0"

y="18"

width="535"

height="14"

forecolor="#C0C0C0"

backcolor="#D6D6D6"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<reportElement

mode="Transparent"

x="5"

y="19"

width="65"

height="13"

forecolor="#3C5ADC"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Transparent"

x="0"

y="7"

width="535"

height="11"

forecolor="#A0A0A0"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<reportElement

mode="Transparent"

x="0"

y="18"

width="535"

height="14"

forecolor="#A0A0A0"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<reportElement

mode="Opaque"

x="36"

y="2"

width="85"

height="14"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

</band>

</title>

</band>

</pageHeader>

</band>

</columnHeader>

<reportElement

mode="Opaque"

x="0"

y="0"

width="535"

height="14"

forecolor="#808080"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</rectangle>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="4"

y="0"

width="116"

height="13"

forecolor="#000000"

backcolor="#FFFFFF"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</summary>

</jasperReport>

By: Darren - darren2003

RE: Sub-Report Example

2003-02-28 21:04

Sorry, Giulio, I follow your instruction and test the example in iReport0.06, but I get some error which is shown as following :

dori.jasper.engine.JRException: Could not load object from location : D:ChungJasperReportiReport-0.06subreport_example.jasper <-----my sub-report

at dori.jasper.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:234)

at dori.jasper.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:297)

at dori.jasper.engine.fill.JRFillBand.evaluate(JRFillBand.java:359)

at dori.jasper.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1022)

at dori.jasper.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:269)

at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:421)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:143)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:348)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:288)

at IReportCompiler.main(IReportCompiler.java:154)

**Moreover, I want to know how did I compile the sub-report file before I compile the main report

Thank you! Giulio

By: Giulio Toffoli - gt78

RE: Sub-Report Example

2003-03-01 00:54

1. You should download iReport 0.0.8 and then download the lastest patched version from cvs repository

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/ireport/iReport/iReport.exe

2. You must first compile the subreport example report. In this way

subreport_example.jasper is created (about the error, I think that you don't have compiled the subreport before launching the master report...)

Giulio

By: Darren - darren2003

RE: Sub-Report Example

2003-03-02 18:03

Giulio, I've compiled the subreport before, and the jasper file is also created yet, but the above error is displayed. Have any setting of database connection and query before compile? Thank you!

By: Giulio Toffoli - gt78

RE: Sub-Report Example

2003-03-03 01:37

1. Test if the subreport run succesfully (you must provide a valid query, i.e. without the portion with parameters, like xxx = $P{XXX}.

2. If the subreport run succesfully, check that the file D:ChungJasperReportiReport-0.06subreport_example.jasper exists.

You should not recive this exception (Could not load object from location) if the file really exist at this location.

Giulio

By: Darren - darren2003

RE: Sub-Report Example

2003-03-03 01:57

I already compile the subreport successfully, and I also find the jasper exists, but I started to compile the master report will display the above error ( I leave blank the query field in the compiler form and my connection in the compiler form is "no connection"), is it right? Giulio

By: Giulio Toffoli - gt78

RE: Sub-Report Example

2003-03-03 02:02

No, you should specify a connection, but leave the field of the query blank.

But, this is not the cause of your problem.

D:ChungJasperReportiReport-0.06subreport_example.jasper

Are you sure that the name is "iReport-0.06"?

I think that the name is "iReport-0.0.6" (please note the dot before the number 6.

If this is the root of your problem I go at your home and I kill it!!!!!!

Giulio

By: Darren - darren2003

RE: Sub-Report Example

2003-03-03 02:08

Sorry!Sorry!Sorry!Sorry!, Giulio

you are right, is that problem (I miss the dot), I'll go to die (don't kill me)

But I specify a connection, I have another error, this will shown as following :

org.gjt.mm.mysql.jdbc2.NotImplemented

at org.gjt.mm.mysql.jdbc2.ResultSet.getStatement(ResultSet.java:1979)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381)

at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:380)

at java.lang.Thread.run(Thread.java:536)

NESTED BY :

dori.jasper.engine.JRException: Error closing ResultSet or Statement for report data source : SRWGCantieriProroghe

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:390)

at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:380)

at java.lang.Thread.run(Thread.java:536)

Caused by: org.gjt.mm.mysql.jdbc2.NotImplemented

at org.gjt.mm.mysql.jdbc2.ResultSet.getStatement(ResultSet.java:1979)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381)

... 2 more

Thank you, Giulio!

By: Giulio Toffoli - gt78

RE: Sub-Report Example

2003-03-03 02:20

Yes, this could be a bug in jasperreports 0.4.5 (but I'm not sure). The problem was discovered in MS SQLServer and not in MySQL but I think that the cause could be the same.

Workarounds:

1. apply this patch and recompile jsaperreports:

http://sourceforge.net/tracker/index.php?func=detail&aid=681655&group_id=36382&atid=416705

2. use a prior version of jasperreports

3. Give me your email. I'll post you an already patched version of jasperreports.jar.

Giulio

By: Darren - darren2003

RE: Sub-Report Example

2003-03-03 02:24

My e-mail address : darren@logicsystem.com.hk

Thank you, Giulio!!!

By: ramesh - rbkannan

RE: Sub-Report Example

2003-06-16 22:12

hi Giulio,

can you also forward the patched version to me, as i'm having the same problems.

my email id is rbkannan@yahoo.com

thanks.

Ramesh

By: Giulio Toffoli - gt78

RE: Sub-Report Example

2003-06-17 01:11

The jasperreports.jar shipped with iReport 0.1.0 and in 0.2.0 is already patched.

Giulio

Sign In

Sub-Report Example

Recommended Posts

ktrinad

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore