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

0

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

ni.raval29's picture
Joined: Jul 23 2017 - 11:54pm
Last seen: 2 years 3 months ago

1 Answer:

0

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-jas... .

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

Attachments: 
AttachmentSize
Package icon export_dual_xml_data_source.zip10.54 KB
rpeguet's picture
6912
Joined: Mar 8 2011 - 2:06am
Last seen: 4 weeks 1 day ago
Feedback