Create iReport Templates with Subreports - Revision history

Alnaucler at 19:32, 20 February 2020

2020-02-20T19:32:19Z

← Older revision		Revision as of 21:32, 20 February 2020
Line 220:		Line 220:
	\|}		\|}
	{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}		{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}
	[[Category:~~VIE~~]]		[[Category:NAA]]

Alnaucler: Alnaucler moved page Create i-Report Templates with Subreports to Create iReport Templates with Subreports: Consistent spelling

2015-08-24T15:47:56Z

Alnaucler moved page Create i-Report Templates with Subreports to Create iReport Templates with Subreports: Consistent spelling

← Older revision	Revision as of 17:47, 24 August 2015
(No difference)

Alnaucler at 15:47, 24 August 2015

2015-08-24T15:47:43Z

← Older revision		Revision as of 17:47, 24 August 2015
Line 18:		Line 18:
	*Determine the relationship between the primary data and the secondary data. How did they get reconciled to one another? How are they linked?		*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~~ Template]] section.		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 iReport Template]] section.

	====Step 2 – Add Subreport to the Main report====__NOEDITSECTION__		====Step 2 – Add Subreport to the Main report====__NOEDITSECTION__

Evinek at 11:25, 9 April 2014

2014-04-09T11:25:24Z

← Older revision		Revision as of 13:25, 9 April 2014
Line 106:		Line 106:

	===Link relationship 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		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.		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.
Line 122:		Line 122:

	*Step 1: Create a main report for an object with geospatial info		*Step 1: Create a main report for an object with geospatial info
	*Step 2: Create a GeospatialInfo subreport on the main report		*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		*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		Step 1: Create a main report for an object with geospatial info
Line 141:		Line 141:
	geospatialinfoguid IN $P{parametername}		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 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__		===Other subreport relationships===__NOEDITSECTION__

Evinek at 12:08, 8 April 2014

2014-04-08T12:08:12Z

← Older revision		Revision as of 14:08, 8 April 2014
Line 64:		Line 64:
	# Save the subreport.		# Save the subreport.

	====Step 5 – ~~Add~~ Subreport ~~Parameter~~ to Main Report====__NOEDITSECTION__		====Step 5 – Link the Subreport to the Main Report====__NOEDITSECTION__
	~~We created a parameter on~~ the subreport ~~to connect to~~ the ~~main report in Step 3, now we need~~ to ~~create a parameter on~~ the ~~main report as well~~. Below is the instructions to ~~create~~ the ~~parameter you need for the main report~~:		Now that both the main and the subreport are ready, the only thing that remains to be done is linking the two together. Below are the instructions to link the two reports:
	# Make sure you are at the ~~Main~~ report by selecting the name of the main report from the tabs at the top of the iReport Designer canvas pane.		# Make sure you are at the 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.		# 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>		#: [[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.		# 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>		#: [[Image:IReport_SubReportProperties.png\|center\|200px\|''Subreport properties'']]<div align="center">''Subreport properties''</div>
	# '''Add''' a parameter and ~~give it a~~ name (e.g. ''ItemGUID'')		# '''Add''' a parameter and 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>		#: [[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.		# 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>		#: [[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.		# 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__		==Kinds of Subreports==__NOEDITSECTION__

Evinek at 11:53, 8 April 2014

2014-04-08T11:53:35Z

Evinek at 11:44, 8 April 2014

2014-04-08T11:44:49Z

Evinek at 11:42, 8 April 2014

2014-04-08T11:42:30Z

Evinek at 11:40, 8 April 2014

2014-04-08T11:40:40Z

← Older revision		Revision as of 13:40, 8 April 2014
Line 1:		Line 1:
	{{TOC right}}		{{TOC right}}
	==Creating Subreports==__NOEDITSECTION__		==Creating Subreports==__NOEDITSECTION__
	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 ~~Items~~ that are associated to the target IMSMA ~~Item~~. Generally a subreport is used in a situation where you have one or more sets of data relating to a single IMSMA item. A common use case would be a Location report with multiple details bands of different IMSMA items (Land, Activity, Accident, Victim, Education, and QM).		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 items that are associated to the target IMSMA item. Generally a subreport is used in a situation where you have one or more sets of data relating to a single IMSMA item. A common use case would be a Location report with multiple details bands of different IMSMA items (Land, Activity, Accident, Victim, Education, and QM).

	Regardless of what IMSMA data you’re including in your report and ~~sub-reports~~, there are 5 basic steps to create a report with subreports:		Regardless of what IMSMA data you’re including in your report and subreports, there are 5 basic steps to create a report with subreports:
	:Step 1 – Create the ~~Main~~ report		:Step 1 – Create the main report
	:Step 2 – Add ~~Sub-report~~ to the ~~Main~~ report		:Step 2 – Add a subreport to the main report
	:Step 3 – Add ~~Parameter~~ to the ~~Subreport~~		:Step 3 – Add a parameter to the subreport
	:Step 4 – Define ~~Report Query~~ for the ~~Subreport~~		:Step 4 – Define the report query for the subreport
	:Step 5 – Add ~~Subreport Parameter~~ to the ~~Main~~ report		:Step 5 – Add subreport parameter to the main report

	====Step 1 – Create the Main Report====__NOEDITSECTION__		====Step 1 – Create the Main Report====__NOEDITSECTION__

	Before creating the main report, you will need to determine what data to be included on your report. For example, if you are creating a report about Land with all the Progress Report data, then the target IMSMA item for your main report should be Land and the target data for your ~~sub-report~~ should be Activity assuming that Progress Reports are entered into the system as Activity. Below is a list of questions and things to be considered when designing a report.		Before creating the main report, you will need to determine what data should be included in your report. For example, if you are creating a report about Land with all the Progress Report data, then the target IMSMA item for your main report should be Land and the target data for your subreport should be Activity assuming that Progress Reports are entered into the system as Activity. Below is a list of questions and things to be considered when designing a report.
	*What are all the data to be included on the report?		*What are all the data to be included on the report?
	*What is the target IMSMA ~~Item~~ for the ~~Main~~ report? This is the primary data of your report.		*What is the target IMSMA item for the main report? This is the primary data of your report.
	*What is the target IMSMA ~~Item~~ for the ~~sub-reports~~? This is the secondary data of your report.		*What is the target IMSMA item for the subreports? This is the secondary data of your report.
	*Determine the relationship between the primary data and the secondary data. How did they get reconciled to one another? How are they linked?		*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 Template]] section.		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 Template]] section.

	====Step 2 – Add Subreport to the Main report====__NOEDITSECTION__		====Step 2 – Add Subreport to the Main report====__NOEDITSECTION__

Evinek at 12:00, 7 April 2014

2014-04-07T12:00:24Z

← Older revision		Revision as of 14:00, 7 April 2014
Line 218:		Line 218:
	\|}		\|}
	{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}		{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}
			[[Category:VIE]]

← Older revision		Revision as of 13:53, 8 April 2014
Line 49:		Line 49:
	# From the Report Inspector, '''right click''' on the '''Parameter''' tree and choose '''Add Parameter'''.		# From the Report Inspector, '''right click''' on the '''Parameter''' tree and choose '''Add Parameter'''.
	#: [[Image:IReport AddParameter1.png\|center\|250px\|''Add Parameter'']]		#: [[Image:IReport AddParameter1.png\|center\|250px\|''Add Parameter'']]
	# In the '''Properties''' pane, enter a parameter name (e.g. ItemGUID} and edit any other properties. Normally it is not required to edit anything other than the name.		# In the '''Properties''' pane, enter a parameter name (e.g. ItemGUID} and edit any other properties. Normally it is not required to edit anything other than the name, you might however want to deselect the '''Use as a prompt''' option.
	#: [[Image:IReport AddParameter2.png\|center\|250px\|''Add Parameter'']]		#: [[Image:IReport AddParameter2.png\|center\|250px\|''Add Parameter'']]
	# Once the parameter is added it will be available in the '''Report Inspector''' and can be referenced as ''$P{parametername}''. For example:		# Once the parameter is added it will be available in the '''Report Inspector''' and can be referenced as ''$P{parametername}''. For example:
Line 56:		Line 56:
	====Step 4 – Define Report Query for Subreport====__NOEDITSECTION__		====Step 4 – Define Report Query for Subreport====__NOEDITSECTION__

	The next step is to create a report query for the subreport you just created in Step 3 to define how the IMSMA item on the main report is related to the IMSMA item on the subreport. Typically the subreport ~~Report Query~~ will receive the guid from the main report via the parameter created in Step 4 and then use it to limit items in the subreport to those linked to the main report. Below is the instructions on how to define the ~~Report Query~~:		The next step is to create a report query for the subreport you just created in Step 2 to define how the IMSMA item on the main report is related to the IMSMA item on the subreport. Typically the subreport report query will receive the guid from the main report via the parameter created in Step 3 and then use it to limit items in the subreport to those linked to the main report. Below is the instructions on how to define the report query:

	# Open the [[Modify an iReport Template#Using Report Query filters\|~~Report Query~~ window]].		# Open the [[Modify an iReport Template#Using Report Query filters\|report query window]].
	# From the ~~Report~~ query window, select '''ImsmaQuery''' from the ~~Query~~ language list.		# From the report query window, select '''ImsmaQuery''' from the query language list.
	# Enter a ~~Report Query~~ filter using the parameter defined above to limit the objects according to the main report object. The most common ~~Report Query~~ filter would be to filter to only linked objects. For example '''''links.toGuid="$P{ItemGUID}"'''''. In this step, the Report Query tells the subreport to return only rows that are linked to the guid of ~~the~~ the item in the main report via the link table. Other combinations of ~~Report Query~~ filters can be used on subreports beyond the link table. These are documented in the [[#Example Subreport Relationships\|Possible Subreport Relationships]] section below.		# Enter a report query filter using the parameter defined above to limit the objects according to the main report object. The most common report query filter would be to filter to only linked objects. For example '''''links.toGuid="$P{ItemGUID}"'''''. In this step, the Report Query tells the subreport to return only rows that are linked to the guid of the item in the main report via the link table. Other combinations of report query filters can be used on subreports beyond the link table. These are documented in the [[#Example Subreport Relationships\|Possible Subreport Relationships]] section below.
	# Click '''OK'''. The ~~Report~~ query window closes.		# Click '''OK'''. The report query window closes.
	# Save the subreport.		# Save the subreport.

	====Step 5 – Add Subreport Parameter to Main Report====__NOEDITSECTION__		====Step 5 – Add Subreport Parameter to Main Report====__NOEDITSECTION__
	We created a parameter on the subreport to connect to the main report in Step 3, now we need to create a parameter on the main report as well. Below is the instructions to create the parameter you need for the ~~Main~~ report:		We created a parameter on the subreport to connect to the main report in Step 3, now we need to create a parameter on the main report as well. Below is the instructions to create the parameter you need for the main report:
	# Make sure you are at the Main report by selecting the name of the main report from the tabs at the top of the iReport Designer canvas pane.		# Make sure you are at the 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.		# Select the subreport box within the main report.

← Older revision		Revision as of 13:44, 8 April 2014
Line 45:		Line 45:
	====Step 3 – Add Parameter to Subreport====__NOEDITSECTION__		====Step 3 – Add Parameter to Subreport====__NOEDITSECTION__

	To connect a subreport to the ~~Main~~ report, we next need to create a parameter for passing the identification (guid) of the primary IMSMA ~~Item~~ between the subreport and the main report. In the '''Report Inspector''' on the subreport, [[Modify an iReport Template#Adding a Parameter to an iReport Template\|add a Parameter]] to hold the guid of the IMSMA ~~Item~~ on the main report. It is recommended to add a fairly generic parameter name such as ''ItemGUID'' so that the subreport can be more easily re-used.		To connect a subreport to the main report, we next need to create a parameter for passing the identification (guid) of the primary IMSMA item between the subreport and the main report. In the '''Report Inspector''' on the subreport, [[Modify an iReport Template#Adding a Parameter to an iReport Template\|add a Parameter]] to hold the guid of the IMSMA item on the main report. It is recommended to add a fairly generic parameter name such as ''ItemGUID'' so that the subreport can be more easily re-used.

	# From the Report Inspector, '''right click''' on the '''Parameter''' tree and choose '''Add Parameter'''.		# From the Report Inspector, '''right click''' on the '''Parameter''' tree and choose '''Add Parameter'''.
Line 56:		Line 56:
	====Step 4 – Define Report Query for Subreport====__NOEDITSECTION__		====Step 4 – Define Report Query for Subreport====__NOEDITSECTION__

	The next step is to create a report query for the subreport you just created in Step 3 to define how the IMSMA item on the ~~Main~~ report is related to the IMSMA item on the subreport. Typically the subreport Report Query will receive the guid from the main report via the parameter created in Step 4 and then use it to limit items in the subreport to those linked to the main report. Below is the instructions on how to define the Report Query:		The next step is to create a report query for the subreport you just created in Step 3 to define how the IMSMA item on the main report is related to the IMSMA item on the subreport. Typically the subreport Report Query will receive the guid from the main report via the parameter created in Step 4 and then use it to limit items in the subreport to those linked to the main report. Below is the instructions on how to define the Report Query:

	# Open the [[Modify an iReport Template#Using Report Query filters\|Report Query window]].		# Open the [[Modify an iReport Template#Using Report Query filters\|Report Query window]].
Line 65:		Line 65:

	====Step 5 – Add Subreport Parameter to Main Report====__NOEDITSECTION__		====Step 5 – Add Subreport Parameter to Main Report====__NOEDITSECTION__
	We created a parameter on the subreport to connect to the ~~Main~~ report in Step 3, now we need to create a parameter on the ~~Main~~ report as well. Below is the instructions to create the parameter you need for the Main report:		We created a parameter on the subreport to connect to the main report in Step 3, now we need to create a parameter on the main report as well. Below is the instructions to create the parameter you need for the Main report:
	# Make sure you are at the Main report by selecting the name of the ~~Main~~ report from the tabs at the top of the iReport Designer canvas pane.		# Make sure you are at the 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.		# 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>		#: [[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.		# On the '''Properties''' pane for the Subreport, select the '''Parameter''' selector.

← Older revision		Revision as of 13:42, 8 April 2014
Line 27:		Line 27:
	#:[[Image:IReportSubReportPalette.png\|center\|300px\|''Subreport Palette'']]<div align="center">''Subreport Palette''</div>		#:[[Image:IReportSubReportPalette.png\|center\|300px\|''Subreport Palette'']]<div align="center">''Subreport Palette''</div>
	# Release the button and the window below displays.		# Release the button and the window below displays.
	#:[[Image:IReportSubReport1.png\|center\|500px\|''Add ~~Sub-report~~ to the Main report'']]		#:[[Image:IReportSubReport1.png\|center\|500px\|''Add Subreport to the Main report'']]
	# Click '''Next''' to define a new ~~sub-report~~ unless you have an existing report that you would like to use for ~~sub-report~~.		# Click '''Next''' to define a new subreport unless you have an existing report that you would like to use for subreport.
	# Select the desired iReport Template to apply (Blank is recommended).		# Select the desired iReport Template to apply (Blank is recommended).
	#:[[Image:IReportSubReport2.png\|center\|500px\|''Select the desired iReport Template'']]		#:[[Image:IReportSubReport2.png\|center\|500px\|''Select the desired iReport Template'']]
	# Select from the '''Connection/Data Source''' list. This should be the IMSMA item determined as the secondary data of your report. For example, if you are creating a report about Land with Progress Reports, then “Hazard Reduction” should be the data source for the ~~sub-report~~. Click Next.		# Select from the '''Connection/Data Source''' list. This should be the IMSMA item determined as the secondary data of your report. For example, if you are creating a report about Land with Progress Reports, then “Hazard Reduction” should be the data source for the subreport. Click Next.
	#:[[Image:IReportSubReport3.png\|center\|500px\|''Select the desired datasource'']]		#:[[Image:IReportSubReport3.png\|center\|500px\|''Select the desired datasource'']]
	# Select the attributes to be included in your ~~sub-report~~. Click '''Next'''.		# Select the attributes to be included in your subreport. Click '''Next'''.
	#:[[Image:IReportSubReport4.png\|center\|500px\|''Select the desired fields for the subreport'']]		#:[[Image:IReportSubReport4.png\|center\|500px\|''Select the desired fields for the subreport'']]
	# Select the fields to group by. This step is not required. Click '''Next'''.		# Select the fields to group by. This step is not required. Click '''Next'''.
	#:[[Image:Subreport_Group_by.png\|center\|500px\|''Select the fields to group by'']]		#:[[Image:Subreport_Group_by.png\|center\|500px\|''Select the fields to group by'']]
	# Enter a name for the ~~sub-report~~ or use the default. Choose '''Next'''.		# Enter a name for the subreport or use the default. Choose '''Next'''.
	#:[[Image:IReportSubReport5.png\|center\|500px\|''Enter a name for the subreport'']]		#:[[Image:IReportSubReport5.png\|center\|500px\|''Enter a name for the subreport'']]
	# Select '''Use the same connection used to fill master report'''. Click Finish.		# Select '''Use the same connection used to fill master report'''. Click Finish.
	#:[[Image:IReportSubReport6.png\|center\|500px\|''Use same connection'']]		#:[[Image:IReportSubReport6.png\|center\|500px\|''Use same connection'']]
	# The ~~sub-report~~ displays.		# The subreport displays.

	====Step 3 – Add Parameter to Subreport====__NOEDITSECTION__		====Step 3 – Add Parameter to Subreport====__NOEDITSECTION__
Line 65:		Line 65:

	====Step 5 – Add Subreport Parameter to Main Report====__NOEDITSECTION__		====Step 5 – Add Subreport Parameter to Main Report====__NOEDITSECTION__
	We created a parameter on the ~~sub-report~~ to connect to the Main report in Step 3, now we need to create a parameter on the Main report as well. Below is the instructions to create the parameter you need for the Main report:		We created a parameter on the subreport to connect to the Main report in Step 3, now we need to create a parameter on the Main report as well. Below is the instructions to create the parameter you need for the Main report:
	# Make sure you are at the Main report by selecting the name of the Main report from the tabs at the top of the iReport Designer canvas pane.		# Make sure you are at the 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.		# Select the subreport box within the Main report.
Line 106:		Line 106:
	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		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

	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 ~~sub-report~~ would return the records for the particular item that is linked to the primary item. The key difference is the query used in the ~~sub-report~~.		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.

	To create a subreport using the link relationship:		To create a subreport using the link relationship: