NoPublic, bureaucrat, administrator
6,632
edits
Changes
m
Alnaucler moved page Create i-Report Templates with Subreports to Create iReport Templates with Subreports: Consistent spelling
*Determine the relationship between the primary data and the secondary data. How did they get reconciled to one another? How are they linked?
The main report should be created with the IMSMA item determined to be the primary data of your report. The main report is just a basic report and can be created using the steps provided in the [[Create a Basic i-Report iReport Template]] section.
====Step 2 – Add Subreport to the Main report====__NOEDITSECTION__
# Save the subreport.
====Step 5 – Add Link the Subreport Parameter to the Main Report====__NOEDITSECTION__We created a parameter on Now that both the main and the subreport to connect to are ready, the main report in Step 3, now we need only thing that remains to create a parameter on be done is linking the main report as welltwo together. Below is are the instructions to create link the parameter you need for the main reporttwo reports:# Make sure you are at the Main main report by selecting the name of the main report from the tabs at the top of the iReport Designer canvas pane.
# Select the subreport box within the main report.
#: [[Image:IReportSubReportSelection.png|center|500px|''Select the Subreport on the main report'']]<div align="center">''Select the Subreport on the main report''</div>
# On the '''Properties''' pane for the Subreport, select the '''Parameter''' selector.
#: [[Image:IReport_SubReportProperties.png|center|200px|''Subreport properties'']]<div align="center">''Subreport properties''</div>
# '''Add''' a parameter and give it a type '''exactly the name of the subreport parameter created in step 3''' (e.g. ''ItemGUID'')
#: [[Image:IReport_SubReportParameter.png|center|200px|''Add a parameter'']]<div align="center">''Add a parameter''</div>
# For the '''value expression''', select the appropriate field to include in the parameter. '''Normally this is ''$F{guid}''''' but other choices are available.
#: [[Image:IReport_SubReportParameter2.png|center|200px|''Select the appropriate field'']]<div align="center">''Select the field to include in the parameter''</div>
# Click '''OK''' and close Subreport Parameters window.
You are now ready to run your main report. Running (i.e. previewing) the main report will automatically run the subreport(s) as well, and the data from the main as well as from the subreport(s) will be included in the output.
==Kinds of Subreports==__NOEDITSECTION__
===Link relationship subreports===__NOEDITSECTION__
In addition to the Location relationship, the main items in {{IMSMANG}} can also be linked with one another during the reconciliation process. This is how, for example, Activities are linked with Land in the {{IMSMANG}} database. Accidents, land, activities, educations, assistances, QMs, and victims may be related to one another via ''links''. For example, a victim may be associated to an accident in a particular land. If these relationships are known, IMSMA users may define these links while reconciling the Data Entry Form. This special relationship can also be modeled in iReport using a report and subreport (s).
The process for creating a report on an item and its linked items is similar to the process for creating a report on items with a Location relationship. The item in the main report is the primary item for which you would like to find linked items. The subreport would return the records for the particular item that is linked to the primary item. The key difference is the query used in the subreport.
*Step 1: Create a main report for an object with geospatial info
*Step 2: Create a GeospatialInfo subreport on the main report, i.e. a report using the GeospatialInfo datasource*Step 3: Create a Geopoint subreport on the GeospatialInfo report, i.e. a report using the Geopoint datasource
Step 1: Create a main report for an object with geospatial info
geospatialinfoguid IN $P{parametername}
This has the effect of limiting the Geospatial records to only those records whose guid is linked to the geospatialinfo of the main report. This is an example of nested reports, i.e. a main report, a subreport, and a sub-subreport.
===Other subreport relationships===__NOEDITSECTION__
