Jasperreports - how to get JSON to populate a subreport

Question

I am trying to get a table to populate with the same data in my main report using Jasper/iReport. How can I get the Json to carry over?

In Edit table datasource I've tried:

((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE})

new ((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE})

$P{REPORT_DATA_SOURCE}

$P{REPORT_CONNECTION}

All of which compile, but none of which actually generate a table. Any ideas? There is no method like cloneDataSource() for JSON so what is the alternative?

My ultimate goal is simple: to pass in JSON data and use it to generate a chart, and then have a table displaying the same information. I have been working for days on this, Jasper is giving me a hard time. Please help!

Polliwog

Answer 1

I was struggling with a similar problem when using sub reports. It seems that the JSON datasource gets consumed by the main report so you need to invoke subDataSource() to get a fresh datasource for your sub reports and maybe for tables, too - haven't tested that yet though...

Data Source Expression: ((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource()

Padova

ah yes that was my problem. i haven't tried it yet will do so now. – Peeples

<dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource()]]></dataSourceExpression> has me all fixed up – Peeples

it is not working for me. I get an error net.sf.jasperreports.engine.data.JsonDataSourc‌​e cannot be resolved or is not a type – Maroney

<dataSourceExpression><![CDATA[$P{REPORT_DATA_SOURCE}.subDataSource()]]></dataSourceExpression> worked for me – Fop

Answer 2

If anyone is using the JasperReports new Book Reports feature (available in version 6+) and you want to use a JsonDataSource, this is the way to pass the json payload to the subreports:

<p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd">
  <subreportParameter name="REPORT_DATA_SOURCE">
    <subreportParameterExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource()]]></subreportParameterExpression>
  </subreportParameter>
  <subreportExpression><![CDATA["PROFILES_cover.jasper"]]></subreportExpression>
</p:subreportPart>

You could also pass a subset of the json payload by providing node location as a parameter of the subDataSource(java.lang.String selectExpression) method. Examples:

.subDataSource("Northwind.Customers")

or

.subDataSource("Northwind.Customers(Country == USA)")

Eugenieeugenio

Answer 3

Just add Data Source Expression in your main report:

<subreport>
    <reportElement x="-6" y="0" width="570" height="59" uuid="ac54a12b-8022-49a1-bc90-90cff664e3a1" />
    <dataSourceExpression>
        <![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("footer")]]>
    </dataSourceExpression>
    <subreportExpression>
        <![CDATA["footer.jrxml"]]>
    </subreportExpression>
</subreport>

Its working for me. Hope it will help.

Chemaram