Combining Multiple Sub Reports into One Main Report

john.wendt · April 5, 2016

Hello,

I am trying to combine multiple stand-alone sub-reports into one main report. I was following this one as an example http://community.jaspersoft.com/questions/847522/how-create-one-master-report-multiple-independent-subreports. The only difference between the two subreports is the filter expression. They both run fine stand alone. I am using Jaspersoft Studio 6.1.1 with a csv dataset

I can only get one of my subreports to show any data. What am I missing?

Thanks in advance,

John

**MAIN REPORT**

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

<![CDATA[sELECT top 1 AS DUMMY

FROM DUAL]]>

</queryString>

</background>

<title>

</title>

</pageHeader>

</columnHeader>

</subreport>

</band>

</subreport>

</band>

</detail>

</columnFooter>

</pageFooter>

</summary>

</jasperReport>

*SUB 1 Report**

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

<![CDATA[]]>

</queryString>

</variable>

</variable>

</variable>

</group>

</textField>

</textField>

</textField>

</band>

</groupHeader>

</groupFooter>

</group>

</background>

<title>

</title>

</pageHeader>

</columnHeader>

</detail>

</columnFooter>

</pageFooter>

</summary>

</jasperReport>

**SUB 2 Report**

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

<![CDATA[]]>

</queryString>

</variable>

</variable>

</variable>

</group>

</textField>

</textField>

</textField>

</band>

</groupHeader>

</groupFooter>

</group>

</background>

<title>

</title>

</pageHeader>

</columnHeader>

</detail>

</columnFooter>

</pageFooter>

</summary>

</jasperReport>

MiditecReportDev · April 5, 2016

I can only guess at the moment (as I'm at work and can't check the tutorial to compare it to what you have) but can you check the following points?

- If you use SQL in your subreports make sure that needed parameters are set to be forwarded by the master report.

- If you don't need any data besides parameters inside your subreports make sure to put an "SELECT *" statement in your subreports query (doesn't do anything but is needed to fill the subreport - don't ask me why).

- Please look up the error messages the Studio is giving to you - they may not look like much but some times there is actually helpful information in there.

- In your master report select the subreports and go to "Appearance" Tab, set a back color and set transparency off (if it already is off, turn it on and off again, sometimes it does not work otherwise). When you did this print the report again and look if both colored areas are visible or just one of them - that way you can see if they are both generated but empty or not even generated at all (which you would see because there will be no colored area for that report).

- In your master report select the subreports and go to "Dataset" Tab and make sure "When no Data Type" is set to "All Sections No Detail" - that way you should get a subreport generated even without any data - see if that changes anything.

javier.ggi90 · April 5, 2016

The way Jasper handles data sources in reports makes it so that it is used and consumed so you have to "rewind" it to use it again.

You can look at it as a table (lets assume it has 5 lines):

The first subreport runs and uses the datasource's information up to the fifth line.
The second subreport tries to access the the data source and reads it but it is already on the fifth line so it assumes the source is empty.

I do not really remember how to solve this (specific instructions) but I do remember passing some instructions into the "Data Source Expression" property of the subreport.

An example of something I did for a JSON datasource is passing this value into the previously mentioned property: "$P{REPORT_DATA_SOURCE}.subDataSource()".

Hope I at least point you into the right direction. Cheers,

Javier

john.wendt · April 7, 2016

Thanks this at least help me understand why it works the way it does. I gave up on this idea and tried posting my exact problem to see if there is a simpler way. If you have a second, would you mind taking in look at my actual use case posted here? Thanks again!

http://community.jaspersoft.com/questions/989111/skipping-row-grouping-functionality

Sign In

Combining Multiple Sub Reports into One Main Report

Recommended Posts

john.wendt

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

MiditecReportDev

Link to comment

Share on other sites

javier.ggi90

Link to comment

Share on other sites

john.wendt

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore