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?
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With