Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JasperReports: is it possible to use multiple data sources, or if not, to use collections in parameters?

It seems that the reporting idiom is that a report consist of a single list of items, with some additional data (parameters). Are there ways to include several unrelated lists in a report, or would this go against the idiom to such an extent that a different tool should rather be used to generate the output?

Suppose, for instance, you have a list of Persons that lives in a Building, with names, phone numbers and so on. This list would be the main datasource. Additionally, on the same report you want to show various other information about that Building, such as address, number of floors and so on. The number of items in this information might vary between Buildings, so that you cannot simply put it into static parameters, but would need a map or a list. This is of course a contrieved example, but should serve to illustrate the problem.

In short: can you use several unrelated lists in a report?

like image 249
Knut Arne Vedaa Avatar asked Mar 11 '10 14:03

Knut Arne Vedaa


People also ask

How do I run multiple queries in JasperReports?

It is possible to use execute multiple queries from a single report by using a subDataset and datasetRun . The behaviour is like having one or more subreports embedded into a single report file. Subdatasets can have parameters, fields, variables and groups just like a report can.

What is the use of JasperReports in Java?

JasperReports is a Java reporting tool used to write content to the printer, onto the screen, or into a variety of files like PDF, XLS, RTF, CSV, XML, HTML, ODT, and TXT.

How do you add multiple detail bands in Jasper report?

Multiple "Detail" bands is not possible. You can add "Group Bands" before and after the Detail band though. The Detail Band is the one with the Product Line, Name, Amount ... etc. The Group surrounding the Detail, containing the Branch is one level upper group.


1 Answers

I think what you want is a Subreport within your report.

A Subreport can have a different datasource than the main report.

Here is a tutorial on how to create one.

like image 134
Gordon Avatar answered Sep 27 '22 23:09

Gordon