How to use more than two different object and show into IReport

[ni.raval29]

Hello everyone,

I want to use more than two different object and show data into iReport. then is it possible to use more than two object or obect with showing relationship on data.

Please tell me how to write json query to relationship or filtering more then two object.

I want to show report which field belong to more than 2 table. didn't find any query to showing that type of data.

Please help me.

Note :- we use Json Database like pouchdb - couchdb. and json data print on Ireport through jasper server.

 

Thanks

[Raphaël Peguet]

You will need to use specific data adapters for each dataset and sub-datasets.

In Jaspersoft Studio you will define the Default Data Adapter property and in JasperReports Server this will need to be setup as described in this article http://community.jaspersoft.com/wiki/how-deploy-and-use-data-adapter-jasperreports-server-v56 .

Note that the article talks about an XML data source but it would be the same for JSON data sources or any other data sources.

To build your JSON query I would recommend this article http://goessner.net/articles/JsonPath/ 

I attach a sample that can be imported in your JRS

I hope this helps

[Raphaël Peguet]

Hi ni.raval29,

I see you removed your upvote, is there anything else I can help with with your JSON query?

Please mark this answer as Best answer if it helps and please post a new question should this not work any longer with the newest releases.

Thank you,