NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{TOC right}}===Sub-Report=Creating Subreports==__NOEDITSECTION__<p>Sub-A subreport is a report is reports within a report; thus, providing a way to generate a report that includes data on the target IMSMA Item item as well as data on other IMSMA Items items that are associated to the target IMSMA Itemitem. Generally a sub-report 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).</p><p>Regardless of what IMSMA data you’re including in your report and sub-reports, there are 6 basic steps to create a report with sub-reports:</p>
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 main report:Step 2 – Add Sub-report a subreport to the Main main report:Step 3 – Add Parameter a parameter to the Sub-reportsubreport:Step 4 – Define Report Query the report query for the Sub-reportsubreport:Step 5 – Add Sub-report Parameter subreport parameter to the Main main report:Step 6 – Repeat Step 2-5 for additional Sub-reports
*What are all the data to be included on the report?
*What is the target IMSMA Item item for the Main main report? This is the primary data of your report.*What is the target IMSMA Item item for the sub-reportssubreports? 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?
# On the main report, from the '''Palette''' pane, select '''Subreport''' and drag it to the desired band on the iReport template (normally this is the '''Detail''' band).#:[[Image:IReportSubReportPalette.png|center|300px|''Subreport Palette'']]<div align="center">''Subreport Palette''<p/div>Sub-# Release the button and the window below displays.#:[[Image:IReportSubReport1.png|center|500px|''Add Subreport to the Main report is reports within '']]# Click '''Next''' to define a new subreport unless you have an existing reportthat you would like to use for subreport.# Select the desired iReport Template to apply (Blank is recommended).#:[[Image:IReportSubReport2.png|center|500px|''Select the desired iReport Template'']]# Select from the '''Connection/Data Source''' list. As mentioned earlier, a sub-report This should be created with the IMSMA Item 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 reportsubreport. Click Next.#:[[Image:IReportSubReport3.png|center|500px|''Select the desired datasource'']]# Select the attributes to be included in your subreport. Below Click '''Next'''.#:[[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'''.#:[[Image:Subreport_Group_by.png|center|500px|''Select the instructions fields to create group by'']]# Enter a name for the subreport or use the default. Choose '''Next'''.#:[[Image:IReportSubReport5.png|center|500px|''Enter a sub-name for the subreport'']] # Select '''Use the same connection used to fill master report'''. Click Finish. #:[[Image:</p>IReportSubReport6.png|center|500px|''Use same connection'']] # The subreport displays.
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, [[Image:iRepBandScreen.pngModify an iReport Template#Adding a Parameter to an iReport Template|center|500pxadd 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.
====Step 5 – Link the Subreport to the Main Report====__NOEDITSECTION__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.# Select the subreport box within the main report.#: [[Image:IReportSubReportSelection.png|center|500px|''Select the Subreport on the main report'']]<ol typediv align="a" start="2center">''Select the Subreport on the main report''<li/div>Click # On the '''Properties''' pane for the Subreport, select the '''NewParameter''' buttonselector.#: [[Image:IReport_SubReportProperties.png|center|200px|''Subreport properties'']]<div align="center">''Subreport properties''</lidiv>:The # '''Add/modify ''' a parameter and type '''exactly the name of the subreport parameter window displayscreated in step 3''' (e.g.''ItemGUID'')#: [[Image:IReport_SubReportParameter.png|center|200px|''Add a parameter'']]<lidiv align="center">From the ''Add/modify a parameter window:''</lidiv>*Enter “# For the '''value expression''object_guid', select the appropriate field to include in the parameter. '''Normally this is '” for the '$F{guid}''Parameter Name''' where but other choices are available.#: [[Image:IReport_SubReportParameter2.png|center|200px|''object_guidSelect the appropriate field'' is ]]<div align="center">''Select the suggested parameter name field to include in the Column D of the Table - Required Parameters for Sub-report below.parameter''</div>*# Click the '''OK''' button. <li>Close the and close Subreport Parameters window that displays the list of all parameters.</li></ol>
==Kinds of Subreports==Step 4 – Define Report Query for Sub-report====__NOEDITSECTION__There are three main kinds of relationships in IMSMA on which subreports can be generated from IMSMA data. These are:*Location relationship*Link relationship*Geospatial relationship*Other relationship
[[Image:iRep10iRep14.png|center|500px|''Figure 10. Define Report Query for Sub-reportlocation_guid example'']]
<div align="center">
''Figure 10. Define Report Query for Sub-reportlocation_guid example''
</div>
====Step 5 – Add Subreport Parameter to Main Report=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.
===Geospatial relationships=Step 6 – Repeat Step 2-5 ==__NOEDITSECTION__In addition to Location and Link relationships, many objects in IMSMA can store geospatial/geographic information (i.e. point/polygon information). This relationship with the geospatial data can be modeled in a report/subreport relationship for additional sub-reportsany item that has geospatial information associated with it.====To include point/polygon information on an object's main report, follow 3 basic steps:
|-
| [[File:Note.jpg Activity | 40px]] || Be sure to select the highest country structure level for Group 1, followed by the next highest country structure level for Group 2, and so on. |}Activity Device
|-
| [[File:Note.jpg Land | 40px]] || Although there are no requirements for the parameter name, you should enter a name that is easy to remember and meaningful (for example, ''location'' or ''location_guid''). Make note of this parameter name since it will used in a later step.|} <ol start="4"><ol type="a" start="2"><li>Click the '''OK''' button.</li><li>Close the window that displays the list of all parameters.</li></ol></ol> ====Part 4. Create a query in the sub-report to associate the guid to the location report==== {| class="wikitable"Land Device
|-
| [[File:Note.jpg Accident | 40px]] || The next part of the process for creating a report on locations and its associated items is to create a query that defines how the location and associated item are related in the IMSMA database. |} <ol><li>From the '''Data''' menu, select '''Report Query'''.</li>:The Report query window displays. <li>From the Report query window:</li><ol type="a"><li>Select ''ImsmaQuery'' from the '''Query language''' list.</li><li>In the field below the Query language list, enter location.guid = "$P{''ParameterName''}"</li>where ''ParameterName'' is the name of the parameter that you created for the location guid.</ol></ol> [[Image:iRep20.png|center|500px|''Figure 20. Query for report on locations and associated items'']]<div align="center">''Figure 20. Query for report on locations and associated items''</div> <ol start="3"><ol type="a" start="3"><li>Click the '''OK''' button.</li>:The Report query window closes. </ol><li>Click the [[Image:iRepCompile.png]] button to compile the sub-report.</li></ol> ====Part 5. Add parameters to the location sub-report==== {| class="wikitable"Accident Device
|-
| [[File:Note.jpg Assistance | 40px]] || The next part of the process for creating a report on locations and its associated items is to update the location report to include the parameter that will be used to associate the location record to item records. |} <ol><li>Display the location report by doing one of the following:</li>*From the '''Window''' menu, select the name of the location report. *Close the sub-report. *Bring the location report to the foreground by double-clicking the location report name that is displayed in the Files pane. <li>Double-click the sub-report box within the report.</li>:A window displays four tabs (Common, Sub-report, Sub-report (Other), and All). <li>From the window:</li><ol type="a"><li>Select the Sub-report (Other) tab.</li><li>Click the '''Add''' button.</li>:The Add/modify parameter window displays. </ol><li>From the Add/modify parameter window:</li><ol type="a"><li>In the '''Sub-report Parameter Name''' field, enter the parameter name that you used for the location.</li></ol></ol> {| class="wikitable"Assistance Given
|-
| [[File:Note.jpg Task | 40px]] || This is the parameter that you created previously. Work Item
|}
</center>
===Example Subreport Relationships=Part 6. Compile and execute the location report==__NOEDITSECTION__{| class="wikitable"| align="center" style= <ol><li>Ensure that the "background:#f0f0f0;"|'''Main Report'Location'' data source is selected from the list.</li><li>Click the [[Image| align="center" style="background:iRepCompile.png]] button to compile the report.</li>#f0f0f0;"|'''Subreport can be'''<li>Click the [[Image| align="center" style="background:iRepRun.png]] button #f0f0f0;"|'''Value to execute the report.</li>:The report results displays. </ol> ==Items with Data Subsets==Certain items have subsets of data that are contained within them. For example, an education may have education details such as the education type, total audience, and percentage of women and men. The education details data requires the education Pass to exist. Table 3. Parent/child relationships lists the items and the data subsets that depend on them. <center>Subreport'''{| classalign="wikitablecenter" widthstyle="600background:#f0f0f0;"|'''Report Query'''
|-
| align="center" colspanLocation||Any Item with a Location||location guid||location.guid ="2$P{ItemGUID}" | '''Table 3. Parent/child relationships'''
|-
| width="150pt" Any linked item||Any linked Item||Item guid (e.g. Land guid)| '''Parent item'''| widthlinks.toGuid="450pt$P{ItemGUID}" | '''Child item(s) which require the parent item'''
|-
| Activity || Impact surveyor IntervieweeOrganisationQuestionVegetation removal||Activity guid||hazreduc.guid = "$P{ItemGUID}"
|-
| Location Interviewee|| AccidentLandActivityEducationQMVictimQuestion||interviewee guid||interviewee.guid = “$P{ItemGUID}”
|-
| Education Task|| Education detailsWork Item||Task guid||task.guid = "$P{ItemGUID}"
|-
| Victim Any Item with Geospatial information||GeospatialInfo||geoSpatialInfos| Received Education|guid IN $P{GeospatialInfoList}</center> The process for creating a report on a parent item and its children is similar to the process for creating a report on locations and their associated items. The key difference is that the main report will contain the attributes of the parent item. The sub-report will contain the attributes for the child item. For example, if you were trying to create a report of educations and their associated education details, the main report would contain the attributes for education and the sub-report would contain the attributes for education details. ====Part 1. Create a report with attributes for a parent item====The first part of creating a report on a parent and its child items is to create a report which includes the attributes from the parent item you would like to include.<ol><li>Ensure that the IMSMA server is started.</li><li>From the '''File''' menu, select '''Report Wizard'''.</li><li>From the '''Connection/Data Sources''' list, select the data source for the parent item.</li></ol> {| class="wikitable"
|-
| [[File:Note.jpg Geospatial Info| 40px]] |GeoPoint| Table 3. Parent/child relationships lists the items which may be selected as the parent item for a report. |} <ol><li>Click the '''Next''' button.</li>:The iReport Wizard, Step 2 window displays a list of attributes for the selected item.<li>Select the attributes you would like to include for the parent item.</li><li>Click the '''Next''' button.</li>:The window displays a list of the attributes that you have selected.<li>Click the '''Next''' button.</li>:The iReport Wizard, Step 3 window displays to allow you to group the report results.<li>Because the report results for this exercise will not need to be grouped, click the '''Next''' button.</li>:The iReport Wizard, Step 4 window displays to allow you to select the report layout.<li>Select a layout option.</li><li>Click the '''Next''' button.</li>:The iReport Wizard, Step 5 window displays. <li>Click the '''Finish''' button.</li><li>Save the report.</li></ol> ====Part 2. Create a sub-report for the child item====The next part of the process for creating a report on a parent and its child items requires you to create a sub-report within the parent item report. <ol><li>Expand the detail section of the report by doing the following:</li><ol typeGeospatialInfo guid||geospatialInfoGuid ="a"><li>From the '''View''' menu, select '''Bands'''.</li><li>From the left pane, select ''detail''.</li><li>In the '''Band Height''' field that is in the right pane, increase the height of the detail section. At a minimum you will want to double the height.</li><li>Click the '''Apply''' button.</li>:The height of the band increases based on the value that you entered. </ol></ol> $P{| class="wikitableItemGUID}"
|-
| [[File:Note.jpg Any item with devices| 40px]] |Item Device (e.g. AccidentDevice)| You may also expand the height of the detail band by dragging the line that separates the detail section of the report and the page footer section down.|} <ol start="2"><li>Click the [[Image:iRepCompileItem guid (e.png]] button to add a sub-reportg.</li>:The cursor changes to a crosshairAccident guid)||accident. <li>Click the detail section of the report.</li><li>While holding down the mouse button, drag the cursor to form the rectangle which will contain the sub-report.</li><li>Release the mouse button.</li>:The window to create a new report or use an existing one displays. <li>From the window:</li><ol typeguid ="a"><li>Select the ''Create a new report'' option.</li><li>Click the '''Next''' button.</li>:The How fill the sub-report screen displays.</ol><li>From the window:</li><ol type="a"><li>Select the data source for the child item from the '''Connection/Data Source''' list.</li><li>Click the '''Next''' button.</li>:The window to select the attributes to include in the report displays. </ol><li>From the window:</li><ol type="a"><li>Select the attributes that you would like to include in the report.</li><li>Click the '''Next''' button.</li>:The window to select a layout displays.</ol><li>From the window to select a layout:</li><ol type="a"><li>Select the layout option.</li><li>Click the '''Next''' button.</li>:The window to specify the sub-report expression displays. </ol><li>From the window to specify the sub-report expression:</li><ol type="a$P{ItemGUID}"><li>Enter a name for the sub-reporthazard.</li><li>Click the '''Finish''' button.</li>:The sub-report displays.</ol></ol> ====Part 3. Add parameters to the sub-report====The next part of the process for creating a report on a parent and its child items is to define parameters that will be used for passing the parent item guid between the sub-report and main report. <ol><li>From the '''View''' menu, select '''Parameters'''.</li>:The window displays the parameters. <li>Click the '''New''' button.</li>:The Add/modify parameter window displays. <li>From the Add/modify parameter window:</li><ol type="a"><li>In the '''Parameter Name''' field, enter a name for the parameter that will be used to identify the guid for the parent item.</li></ol></ol> $P{| class="wikitableItemGUID}"
|-
| [[File:Note.jpg MRE| 40px]] |MREDetail| Although there are no requirements for the parameter name, you should enter a name that is easy to remember and meaningful. Make note of this parameter name since it will used in a later step.|} <ol start="4"><ol type="a" start="2"><li>Click the OK button.</li></ol><li>Close the window that displays the list of all parameters.</li></ol> ====Part 4. Create a query in the sub-report to associate the MRE guid to the parent item report====The next part of the process for creating a report on locations and its associated items is to create a query that defines how the location and associated item are related in the IMSMA database. <ol><li>From the '''Data''' menu, select '''Report Query'''.</li>:The Report query window displays. <li>From the Report query window:</li><ol type="a"><li>Select ''ImsmaQuery'' from the '''Query language''' list.</li><li>In the field below the Query language list, enter ''ParentItem''||mre.guid = "$P{''ParameterName''ItemGUID}"</li>where ''ParentItem'' is the default value expression for the parent item and ''ParameterName'' is the name of the parameter that you created for the parent item guid.<li>Click the '''OK''' button.</li>:The Report query window closes. <li>Click the [[Image:iRepCompile.png]] button to compile the sub-report.</li></ol></ol> ====Part 5. Add parameters to the parent report====The next part of the process for creating a report on a parent and its child items is to update the parent report to include the guid attribute and parameters that will be used to associate the parent item to the child item. <ol><li>Display the parent item report by doing one of the following:</li>*From the Window menu, select the name of the report. *Close the sub-report. *Bring the parent item report to the foreground by double-clicking the report name that is displayed in the Files pane. <li>Double-click the sub-report box within the report.</li>:A window displays four tabs (Common, Sub-report, Sub-report (Other), and All). <li>From the window:</li><ol type="a"><li>Select the Sub-report (Other) tab.</li><li>Click the Add button.</li>:The Add/modify parameter window displays. </ol><li>From the Add/modify parameter window:</li><ol type="a"><li>In the Sub-report Parameter Name field, enter the parameter name that you used for the parent item guid.</li></ol></ol> {| class="wikitable"
|-
| [[File:Note.jpg Victim| 40px]] |Needs Assessment| This is the parameter that you created in step previously. |} <ol start="5"><ol type="a" start="2"><li>In the '''Default Value Expression''' field, enter ''$F{victim guid}''.</li><li>Click the '''OK''' button.</li></ol><li>Close the window with the four tabs.</li></ol> ====Part 6. Compile and execute the parent item report====<ol><li>Ensure that the data source for the parent item is selected from the list.</li><li>Click the [[Image:iRepCompile.png]] button to compile the report.</li><li>Click the [[Image:iRepRun.png]] button to execute the report.</li>:The report results displays.</ol> ==Reports on Linked Items==Part 4 of this training module discussed direct relationships—relationships where the parent item must exist in order for the child item to exist. In this part of the training, you will learn about linked relationships. Linked relationships are optional relationships which may exist between items. Unlike direct relationships that are enforced during the IMSMA reconciliation process, links are optional. Accidents, lands, activities, educations, and QMs 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. [[Image:iRep21.png|center|500px|''Figure 21victim. Direct relationships vs. Links'']]<div alignguid="center">''Figure 21. Direct relationships vs. Links''</div> 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 direct 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. If you would like to report on different items that linked to the item in the main report, you may create a new sub-report for each linked item. For example, to create a report of lands and the accidents and activities that are linked to those lands, you would create the main report on lands. This report would then contain a sub-report to list linked accidents, and another sub-report to list linked activities. ====Part 1. Create a report with attributes for a primary item==== The first part of creating a report on linked items is to create a report which includes the attributes from the primary item for which you would like to list linked items. <ol><li>Ensure that the IMSMA server is started.</li><li>From the '''File''' menu, select '''Report Wizard'''.</li><li>From the '''Connection/Data Sources''' list, select the data source for the primary item.</li></ol> $P{| class="wikitableItemGUID}"
|-
| [[File:Note.jpg Victim||Cause| 40px]] |victim guid| Table 3. Parent/child relationships lists the items which may be selected as the primary item for a report. |} <ol start="4"><li>Click the '''Next''' button.</li>:The iReport Wizard, Step 2 window displays a list of attributes for the selected item.<li>Select the attributes you would like to include for the primary item.</li><li>Click the '''Next''' button.</li>:The window displays a list of the attributes that you have selected.<li>Click the '''Next''' button.</li>:The iReport Wizard, Step 3 window displays to allow you to group the report results.<li>Because the report results for this exercise will not need to be grouped, click the '''Next''' button.</li>:The iReport Wizard, Step 4 window displays to allow you to select the report layout.<li>Select a layout option.</li><li>Click the '''Next''' button.</li>:The iReport Wizard, Step 5 window displays. <li>Click the '''Finish''' button.</li><li>Save the report by doing one of the following:</li>*Click the [[Image:iRepSave.png]] icon. *From the File menu, select '''Save'''. ::The Save report window displays.<li>Enter a name for the report in the File name field.</li><li>Click the '''Save''' button.</li></ol> ====Part 2. Create a sub-report for the linked item====The next part of the process for creating a report on linked items requires you to create a sub-report for the item to which the primary item is linked. <ol><li>Expand the detail section of the report.</li><li>Click the [[Image:iRepBand.png]] button to add a sub-report.</li>:The cursor changes to a crosshair. <li>Click the detail section of the report.</li><li>While holding down the mouse button, drag the cursor to form the rectangle which will contain the sub-report. </li><li>Release the mouse button.</li>:The window to create a new report or use an existing one displaysvictim. <li>From the window:</li><ol type="a"><li>Select the ''Create a new report'' option.</li><li>Click the '''Next''' button.</li>:The How fill the sub-report screen displays.</ol><li>From the window:</li><ol type="a"><li>Select the data source for the child item from the '''Connection/Data Source''' list.</li><li>Click the '''Next''' button.</li>:The window to select the attributes to include in the report displays. </ol><li>From the window:</li><ol type="a"><li>Select the attributes that you would like to include in the report.</li><li>Click the '''Next''' button.</li>:The window to select a layout displays.</ol><li>From the window to select a layout:</li><ol type="a"><li>Select the layout option.</li><li>Click the '''Next''' button.</li>:The window to specify the sub-report expression displays. </ol><li>From the window to specify the sub-report expression:</li><ol type="a"><li>Enter a name for the sub-report.</li><li>Click the '''Finish''' button.</li>:The sub-report displays. </ol></ol> ====Part 3. Add the parameters to the sub-report====The next part of the process for creating a report on linked items is to define parameters that will be used for passing the guid of the primary item between the sub-report and main report. <ol><li>Click the '''New''' button.</li>:The Add/modify parameter window displays. <li>From the Add/modify parameter window:</li><ol type="a"><li>In the '''Parameter Name''' field, enter a name for the parameter that will be used to identify the guid for the primary item.</li></ol></ol> $P{| class="wikitableItemGUID}"
|-
| [[File:Note.jpg Assistance|| 40px]] Assistance Given|| Although there are no requirements for the parameter name, you should enter a name that is easy to remember and meaningfulvictimAssistance. Make note of this parameter name since it will used in a later step.guid||} <ol start="3"><ol type="a" start="2"><li>Click the '''OK''' button.</li></ol><li>Close the window that displays the list of all parameters.</li></ol> ====Part 4victimAssistance. Create a query in the sub-report to associate the guid to the primary report item====The next part of the process for creating a report on linked items is to create a query that defines how the primary item and the linked item are related in the IMSMA database. <ol><li>From the '''Data''' menu, select '''Report Query'''.</li>:The Report query window displays. <li>From the Report query window:</li><ol type="a"><li>Select ''ImsmaQuery'' from the '''Query language''' list.</li></ol></ol> $P{| class="wikitableItemGUID}"
|-
| [[File:Note.jpg Task| 40px]] |Objective| The following query is different from the query used when creating a report on items with data subsets. |} <ol start="3"><ol type="a" start="2"><li>In the field below the Query language SQL Field list, enter links.toGuid = "of Objectives||guid IN ($P{''ParameterName''SQLList}"</li>where ''ParameterName'' is the name of the parameter that you created for the parent item guid.<li>Click the '''OK''' button.</li>:The Report query window closes. </ol><li>Ensure that the Query Executor data source is selected from the list.</li><li>Click the button to compile the sub-report.</li></ol> ====Part 5. Add attributes and parameters to the main report====The next part of the process for creating a report on linked items is to update the main report to include the guid attribute and parameters that will be used to associate the primary item to the linked item. <ol><li>Display the main report by doing one of the following:</li>*From the '''Window''' menu, select the name of the report. *Close the sub-report. *Bring the primary item report to the foreground by double-clicking the report name that is displayed in the Files pane. <li>Double-click the sub-report box within the report.</li>:A window displays four tabs (Common, Sub-report, Sub-report (Other), and All). <li>From the window:</li><ol type="a"><li>Select the Sub-report (Other) tab.</li><li>Click the '''Add''' button.</li>:The Add/modify parameter window displays.</ol><li>From the Add/modify parameter window:</li><ol type="a"><li>In the '''Sub-report Parameter Name''' field, enter the parameter name that you used for the primary report item guid.</li></ol></ol> {| class="wikitable"
|-
| [[File:Note.jpg Work Item| 40px]] |Linked Items (Activity, Education, QM, Assistance)| This is the parameter that you created previously. |SQL Field list of Items||guid IN ($P{SQLList})
|}