A tutorial on using subreports in Jaspersoft’s iReport Designer; example runs several queries each mapping to a different subreport. Feeds · Video. This site. A subreport is a report within a report; thus, providing a way to generate a report that includes data on the target IMSMA item as well as data on other IMSMA. There are a few steps to adding a subreport to iReport. I will do my best to step by step explain. STEPS: 1) Make blank report with the values that will be used as.

Author: Kazikazahn Garg
Country: Mayotte
Language: English (Spanish)
Genre: Photos
Published (Last): 12 August 2012
Pages: 226
PDF File Size: 7.16 Mb
ePub File Size: 14.72 Mb
ISBN: 338-4-87501-264-9
Downloads: 32669
Price: Free* [*Free Regsitration Required]
Uploader: Fenrilkis

How to add subReports in iReport | Jaspersoft Community

This makes perfect sense, considering that a Jasper object is not necessarily loaded from a physical file. Use the same connection used to fill the master report — Select this to use the same JDBC data adapter for the master report and the subreport. It must be clear that if we pass a JDBC connection to the subreport, it is because we defined an SQL query in the subreport, a query that will be used to fill it.

How to add subreport using ireports? The following properties must be set to link the subreport to the parent report: In this way the database connection will be passed to the subreport to let it execute its SQL query.

That’s why we need to create such kind of report. Using a different data source is sometimes necessary when a connection like JDBC is not being used; it is more complicated but extremely powerful.


If you make an error typing the name or the inserted parameter has not been defined, no error is thrown. Generally speaking, creating a subreport is very similar to creating any other report. Jaspersoft Studio always includes the classpath of the directory of the report that is running, so all the subreport Jasper files can be found easily if they are located in the same directory. Depending on what you want to achieve, you can pass the data source that will feed the subreport through a parameter, or you can define the data source dynamically every time it is required.

Sign up or log in Sign up using Google. We must decide on one of them and stick to it. This feature allows incorporating a report within another report, that is, one report can be a subreport of another.

This time the query will be:.

Below is the instructions on how to define the report query:. Now, let’s update our existing DataBean file.

How to add subReports in iReport

The report engine will take care of that for you. Required Expression that can be used to load jreport Jasper object to use when filling the subreport portion of the document.

You can’t use a relative path to locate the subreport file; subrfport is, if you have a report in c: The intent of the subreport is to bring data from a different but related datasource into the main report.

Email Required, but never shown. Subrrport 1 – 1: Jun 15 – You can use fields, parameters, and variables. The key difference is the query used in the subreport. The cache works only if the subreport expression type is Stringbecause that string is used as key for the cache. Now, all our files are ready, let’s compile and execute them using our regular ANT build process.


The subreport would return the records for the particular item that is linked to the primary item. You can think of the Subreport element as a place holder defining the position of the top-left corner to which the subreport is aligned.

Expression — Retrieves the Jasper object that implements the subreport. A first subreport will be used to select the email addresses of each person and render the orange portion. Double click to open and hit add. Create a subreport — Create and compile subreprt subreport.

Create iReport Templates with Subreports

This option is useful at times. The Expression Property The subreport expression specifies the location of the Jasper file used to generate the subreport.

Set it to the field ID. I will do my best to step by step explain. This element has a class attribute. Oreport of the most common uses of subreport parameters is to pass the key of a record printed in the parent report in order to execute a query in the subreport through which you can extract the records referred to report headers and lines.