There are three steps to creating and adding a subreport:
1. | Create a report – Create a parent or master report that will contain the subreport. |
2. | Create a subreport – Create and compile a subreport. Optionally create a dynamic connection to filter the records of the subreport based on the parent’s data. |
3. | Add the subreport to the parent report – Insert a subreport element and specify the following: |
• | The data adapter or data source for the subreport. |
• | The location of the subreport's compiled Jasper file. |
• | An optional parameters map (it can be empty) to set the report parameters used in the dynamic connection. |
Subreports
A subreport is simply a report composed of its own JRXML source and compiled in a Jasper file. Generally speaking, creating a subreport is very similar to creating any other report. The margins of a subreport are usually set to zero for subreports because a subreport is meant to be a portion of a page, not an entire document. The horizontal dimension of the subreport should be as large as the element into which it is placed in the parent report.
Subreport Elements
You add a subreport to a report by dragging the Subreport element from the palette. At design time the element is rendered as a rectangle with the dimensions specified in the subreport.
The Subreport element does not need to be the same size as the subreport. 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. However, we recommend that you set the dimensions of the Subreport element to the dimensions of the subreport to best visualize the layout of the final report. |
Properties of a Subreport Element
When a subreport element is selected in the master report, the following properties are available on the Subreport tab of the Properties view:
Property | Description |
---|---|
Run To Bottom | When true, the subreport element will consume the entire vertical space available on the report page. |
Overflow Type | When not specified, the subreport will stretch to accommodate the content. |
Expression | (Required) Expression that can be used to load the Jasper object to use when filling the subreport portion of the document. Evaluated at run time to retrieve the Jasper object for the subreport. See The Expression Property for more information. |
Using Cache | Specifies whether the subreport's report object is kept in memory or reloaded each time it's used. It is common for a subreport element to be printed more than once (or once for each record in the main dataset). The cache works only if the subreport expression type is String, because that string is used as key for the cache. |
Connection Expression or Datasource Expression | At run time, returns a JDBC connection or a JRDataSource used to fill in the subreport. Only one of these expression types can be used. If there is no connection or data source expression, no data is passed to the subreport. This option is useful at times. In this case, the subreport should have the document property When No Data Type set to something like All Sections, No Detail or No Data Section. |
Parameters Map Expression | Optional expression used to produce a java.util.Map object at run time. The expression must contain a set of coupled names/objects that are passed to the subreport to set a value for its parameters. |
Edit Return Values | Allows you to define how to store values in local variables calculated or processed in the subreport (such as totals and record count). |
Edit Parameters | Allows you to define name/expression pairs used to dynamically set a value for the subreport parameters. |
The following properties must be set to link the subreport to the parent report:
• | Expression – Retrieves the Jasper object that implements the subreport. |
• | Connection Expression or Datasource Expression – Defines how to feed the object with data. |
• | Parameters – Sets the values of the subreport parameters. |
The Expression Property
The subreport expression specifies the location of the Jasper file used to generate the subreport.
If the expression is a string (java.lang.String), JasperReports assumes that the subreport must be loaded from a Jasper file and tries to locate the file in the same way that resources are located, as follows:
1. | The string is at first interpreted as a URL. |
2. | In case of failure (a MalformedURLException), the string is interpreted as a physical path to a file. This is the most common case. |
3. | If the file does not exist, the string is interpreted as a resource located in the classpath. |
This means that using an expression of type String means you are in some way trying to specify a file path. Optionally, you can put your Jasper file in the classpath and refer to it as a resource, using an expression something like "subreport.jasper".
You can't use a relative path to locate the subreport file; that is, if you have a report in c:myreportmain_report.jasper, you cannot refer to a subreport using an expression like ..mysubreportsmysubreport.jasper. This is because JasperReports does not keep in memory the original location of the Jasper file that it’s working with. This makes perfect sense, considering that a Jasper object is not necessarily loaded from a physical file. |
To simplify report design when loading a subreport from the file system, do one of the following:
• | Place the subreport file in a directory that is in the classpath. This permits you to use very simple subreport expressions, such as a string containing just the name of the subreport file (that is, “subreport.jasper”). 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. |
• | Parametrize the Jasper file location and create on-the-fly the real absolute path of the file to load. This can be achieved with a parameter containing the parent directory of the subreport (let’s call it SUBREPORT_DIRECTORY) and an expression like this: |
$P{SUBREPORT_DIRECTORY} + "subreport.jasper"
One advantage of this approach is that you can use the Jasper files’ local directory as the default value for the SUBREPORT_DIRECTORY parameter. The developer who will integrate JasperReports in his applications can set a different value for that location just by passing a different value for the SUBREPORT_DIRECTORY parameter.
Specifying the Data Source
For JasperReports to retrieve data and fill the subreport, you have to set the subreport data source. The following options are available:
• | 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. The JDBC connection is passed to the subreport to execute it. |
• | Use another connection – Select this to specify a different JDBC data adapter for the subreport. |
• | Use a JRDataSource expression – Select this to use a JRDataSource object to fill the subreport. |
JDBC connections make using subreports simple enough. A connection expression must identify a java.sql.Connection object (ready to be used, so a connection to the database is already opened). Typically, we’ll run the SQL query using the same database connection as the parent report; the connection can be referenced with the REPORT_CONNECTION built-in parameter. 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.
Using a different data source is sometimes necessary when a connection like JDBC is not being used; it is more complicated but extremely powerful. It requires writing a data source expression that returns a JRDataSource instance that you then use to fill the subreport. 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. If the parent report is executed using a data source, this data source is stored in the REPORT_DATASOURCE built-in parameter. On the other hand, the REPORT_DATASOURCE should never be used to feed a subreport; a data source is a consumable object that is usable for feeding a report only once. Therefore, the parameter technique is not suitable when every record of the master report has its own subreport (unless there is only one record in the master report). When we discuss data sources this will be more clear and you will see how this problem is easily solved with custom data sources. You will also see how to create subreports using different type of connections and data sources.
Subreport Parameters
One 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). For example, let’s say you have in the master report a set of customers, and you want to show additional information about them, such as their contact info. The subreports will use the customer ID to get the contact info. The customer ID should be passed to the subreport as a parameter, and its value changes for each record in the master report.
Related datasets in master and subreport |
To pass parameters from the master report to a subreport, you create a set of parameter name/object pairs that feed the parameters map of the subreport. To do this, click the Edit Parameters button on the Subreport tab of the Properties view to open the Subreport Parameters dialog.
When a report is invoked from a program (using one of the fillReport methods, for instance), a parameters map is passed to set a value for its parameters. A similar approach is used to set a value for subreport parameters. With subreports you don’t have to define a map (even, if possible, specifying a Parameters Map Expression). The report engine will take care of that for you. |
Subreport Parameters dialog |
To configure a parameter you want to pass to the subreport, click Add in the Subreport Parameters dialog to open the Parameter Configuration Dialog box, which lets you set the following:
• | Name – Name of the parameter. A parameter must have the same name in the master report and the subreport. Parameter names are case-sensitive. |
If you make an error typing the name or the inserted parameter has not been defined, no error is thrown. In most cases, the report will fail silently. |
• | ValueExpression – JasperReports expression for the parameter. To create or edit an expression, click |
As cited below, you have the option of directly providing a parameters map to be used with the subreport; the Parameters Map Expression allows you to define an expression, the result of which must be a java.util.Map object. It is possible, for example, to prepare a map designed for the subreport in your application, pass it to the master report using a parameter, then use that parameter as an expression (for example, $P{myMap}) to pass the map to the subreport. It is also possible to pass to the subreport the same parameters map that was provided to the parent by using the built-in parameter REPORT_PARAMETERS_MAP. In this case the expression looks like this:
$P{REPORT_PARAMETERS_MAP}
Since the subreport parameters can be used in conjunction with this map, you could even use it to pass common parameters, such as the username of the user executing the report.
Recommended Comments
There are no comments to display.