How to insert fields from different dataset in the same report?

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hi all, 
in Jaspersoft Studio I need to define different dataset (different query) in same report. Then I would like to insert the fields from all the dataset in the report. 
If I define a subdataset JasperSoft doesn't let me insert its fields in the report. 
A subreport is not a solution for me because I have to insert fields from differente database table in the same report band. 
How can I do it? 

An example: 
I need to generate a pdf  whit data from 2 queries:

- the first query with the data of the document

- A second one that get the values for the labels. These values are stored in a database table created by an ERP procedure.
 

 Thanks a lot!

paolo.robustellini's picture
Joined: Jun 15 2018 - 7:06am
Last seen: 3 days 21 hours ago

1 Answer:

You should be able to use the list to show it as field and blend it in. List can have different dataset.

mbamania's picture
Joined: May 18 2020 - 7:28am
Last seen: 4 months 1 hour ago
Feedback
randomness