Difference between revisions of "Use iReport"

From IMSMA Wiki
Jump to: navigation, search
(37 intermediate revisions by 7 users not shown)
Line 1: Line 1:
 +
__FORCETOC__
 +
{{TOC right}}
 
{{HowTo's
 
{{HowTo's
|[[HowTo:Start and Configure i-Report|Start and Configure i-Report]]
+
|[[Start and Configure iReport]]
|[[HowTo:Create a Basic i-Report Template|Create a Basic i-Report Template]]
+
|[[Create a Basic iReport Template]]
|[[HowTo:Create i-Report Templates with Subreports|Create i-Report Templates with Subreports]]
+
|[[Modify an iReport Template]]
|[[HowTo:Summarize i-Report Template Data|Summarize i-Report Template Data]]
+
|[[Format an iReport Template]]
 +
|[[Create iReport Templates with Subreports]]
 +
|[[Summarize iReport Template Data]]
 
}}
 
}}
  
==Introduction==
+
==Introduction to iReport==__NOEDITSECTION__
===i-Report===
+
iReport Designer (also known as iReport) is a third-party application that allows you to generate custom-defined reports on IMSMA data. Using iReport, you may define the attributes that are returned by a report and also customise the appearance of the report. Report templates designed in iReport can be imported into {{IMSMANG}} and run by {{IMSMANG}} users to extract data based on search criteria. Reports can be exported to PDF, RTF, XLS, and other formats. iReport Designer version 5.0.1 is included with the {{IMSMANG}} distribution. Using iReport Designer, users create .jrxml iReport templates, a kind of xml report definition, that can be used by {{IMSMANG}} to [[Producing Reports Using IMSMANG|produce a formatted report]].
iReport is a third-party application that allows you to generate custom-defined reports on IMSMA data. Using iReport, you may define the attributes that are returned by a report and also customise the appearance of the report.
 
===How To Use This Manual===
 
This guide provides information for using iReport with IMSMA. It provides the steps for configuring and using iReport to report on IMSMA data. It is not intended to serve as a complete guide for using iReport. For detailed information on using iReport, refer to the iReport help or documentation.
 
  
===Conventions===
+
{{note|iReport does not support Java 8.}}
<u>Table 1</u> lists the conventions used in the manual.
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 1. Conventions'''
 
|-
 
| width="100pt" | '''Convention'''
 
| align="center" width="400pt" | '''Meaning'''
 
|-
 
| ''Bold'' || Indicates menu, button, icon, or list names.
 
|-
 
| ''[Bold in brackets]'' || Indicates a keyboard key.
 
|-
 
| ''Italics'' || Indicates text that should be typed exactly as it is shown in the user manual into a field. Italicized text is also used to note options that may be selected from a list.
 
|-
 
| [[Image:Note.jpg|40px]] || Indicates a tip for using IMSMA.
 
|-
 
| [[Image:Warning.jpg|40px]] || Indicates steps for completing a task.
 
|-
 
| [[Image:MobilePen.png|40px]] || Indicates an error that you might encounter.
 
|}
 
</center>
 
 
 
==Sample Reports==
 
IMSMA includes several iReport sample reports. These reports may be used as is or used as a reference to create your reports. The sample reports are installed in the \iReports\IMSMA reports directory of your IMSMA installation directory.
 
 
 
=== Article 7: Form A===
 
The ''Article 7: Form A'' report returns the total area size of all reductions that are being reported on, the total area size of all Lands that have been linked to the reported reductions, and a count of all victims that have been linked to the reported reductions. If a search definition is associated with the report, the search definition name will be displayed in the report title.
 
 
 
[[Image:fig41SampleReport.png|center|500px|''Figure 41. Sample report - Article 7 form A'']]
 
<div align="center">
 
''Figure 41. Sample report - Article 7 form A''
 
</div>
 
 
 
====Table 6====
 
{| class="wikitable"
 
|-
 
| File name || Article 7 Form A.jrxml
 
|-
 
| Data source|| Activity
 
|-
 
| Variables 
 
|| Sum of Activity area size
 
Sum of total Land area size
 
Sum of victim counts
 
|-
 
| Derived fields
 
|| ActivityLinkedLandAreaSize (Total Land Area Size)
 
HazreducLinkedVictimCount (Victim Count)
 
|-
 
| Sub-reports|| None
 
|}
 
 
 
===Article 7: Form C===
 
The ''Article 7: Form C'' report returns a crosstab by district and Land with the number of Lands by Land type.
 
 
 
[[Image:Article 7FormC.png|center|500px|''Figure 42. Sample report- Article 7-form C'']]
 
<div align="center">
 
''Figure 42. Sample report – Article 7 form C''
 
</div>
 
 
 
====Table 7====
 
{| class="wikitable"
 
|-
 
| File name|| Article 7 Form C.jrxml
 
|-
 
| Data source|| Land
 
|-
 
| Variables|| REPORT_COUNT (built-in iReport variable)
 
|-
 
| Derived fields|| None
 
|-
 
| Sub-reports|| None
 
|}
 
 
 
==Bar Chart Sample==
 
The ''Bar Chart'' sample report returns the metal contamination level of Lands and area size. The report includes a bar chart which summarizes the total area size of Lands by their metal contamination level.
 
 
 
[[Image:BarChartSample.png|center|500px|''Figure 43.'' ''Sample report- Bar chart'' '']]
 
 
 
====Table 8====
 
{| class="wikitable"
 
|-
 
| File name|| Bar Chart Sample.jrxml
 
|-
 
| Data source|| Land
 
|-
 
| Variable
 
|| Sum of area size
 
Count of metal contamination level
 
|-
 
| Derived fields|| None
 
|-
 
| Sub-reports|| None
 
|}
 
 
 
==Clearance by Year and District==
 
The Clearance by Year and District report returns the total area cleared, hours spent, devices, and number of positive samples grouped by year and district.
 
  
[[Image:Clearance Operaitons by Year and District.png|center|500px|''Figure 44. Sample report-Clearance by year and district'']]
+
==iReport Basics==__NOEDITSECTION__
 
+
iReport uses standard reporting terms to refer to the basic building blocks of report templates.
====Table 9====
+
===Data Sources===__NOEDITSECTION__
{| class="wikitable"
+
Data sources in iReport refer to the connection between the report template and the {{IMSMANG}} database. Each iReport template will have one data source. Data sources in iReport generally refer to items in {{IMSMANG}} such as Land, Activity, Education, Accident, Victim, etc. Available data sources include:
 +
{| class="wikitable" style="margin: 1em auto 1em auto;"
 +
|+Available Data Sources
 
|-
 
|-
| File Name|| Clearance by Year and District Sample.jrxml
+
| Accident Device ||MRE 
 
|-
 
|-
| Data source|| Activity
+
| Accident ||MRE Detail
 
|-
 
|-
| Variables|| Count variables for all the derived fields
+
| Assistance Classification ||Needs Assessment Classification
 
|-
 
|-
| Derived fields
+
| Cause Classification ||Ordnance
|| One derived field for each device sub-category (i.e., Anti-Tank, Anti-Vehicle, etc.,) created by using parameterized derived field com.fgm.imsma.ext.report.OrdnanceWithSubCategoryExists, passing in the device subcategory imsma enum.
 
 
|-
 
|-
| Sub-reports|| None
+
| Field Report ||Organisation
|}
 
 
 
==Lands by Ordnance Type==
 
The Lands by Ordnance Type report shows summary data based on the full set of Ordnance Types present.  This report groups Lands based on the full list of Ordnance SubCategories that are found on the Land.  The report displays the name of the search in the report title.
 
 
 
[[Image:MRE audience.png|center|500px|''Figure 45.'' ''Sample report- Land by ordnance type'']]
 
 
 
====Table 10====
 
{| class="wikitable"
 
 
|-
 
|-
| File name || Lands by Ordnance Type.jrxml
+
| Gazetteer ||Place
 
|-
 
|-
| Data source|| Land
+
| Geopoint ||QM
 
|-
 
|-
| Variables
+
| Geospatialinfo ||Question
|| Count of Lands for each ordnance sub-category
 
Sum of area size,
 
Average of area size
 
 
|-
 
|-
| Derived fields || LandOrdnanceSubCategoryList (Ordnance SubCategory List)
+
| Hazard ||Received MRE
 
|-
 
|-
| Sub-reports|| None
+
| Hazard Device ||Task
|}
 
 
 
==Education Audience Totals by Age==
 
The Education Audience Totals by Age report lists the different age categories of Education audiences and the total number of male, female, and unknown gender in each age category.
 
 
 
[[Image:MRE audience.png|center|500px|''Figure 46.'' ''Sample report- Education audience totals by age'']]
 
 
 
====Table 11====
 
{| class="wikitable"
 
 
|-
 
|-
| File name  || Education Audience by Age.jrxml
+
| Hazard Reduction ||Victim
 
|-
 
|-
| Data source|| Education Details
+
| Hazard Reduction Device ||Victim Assistance
 
|-
 
|-
| Variables
+
| Impact Survey ||Victim Assistance Assistance
|| Sums of each gender (derived fields) by group and report
 
Sum of total audience by group and report
 
Count of number of events (Education Details) by group and report
 
 
|-
 
|-
| Derived Fields
+
| Interviewee ||Victim Cause
|| EducationDetailMaleAudience (Total Male Audience)
 
EducationDetailFemaleAudience (Total Female Audience)
 
EducationDetailUnknownAudience (Total Unknown Audience)
 
 
|-
 
|-
| Sub-reports|| None
+
| Link ||Victim Needs Assessment
|}
 
 
 
==Pie Chart Sample==
 
The Pie Chart sample report returns the metal contamination level of Lands and area size. The report includes a pie chart which summarizes the total area size of Lands by their metal contamination level.
 
 
 
[[Image:Pie Chart.png|center|500px|''Figure 47.'' ''Sample report- Pie chart'']]
 
 
 
====Table 12====
 
{| class="wikitable"
 
|-
 
| File name || Pie Chart Sample.jrxml
 
|-
 
| Data source || Land
 
 
|-
 
|-
| Variables
+
| Location ||Work Item
|| Sum of area size
 
Count of metal contamination level
 
  
|-
 
| Derived fields || None
 
|-
 
| Sub-reports|| None
 
 
|}
 
|}
  
==Accident Victim Summary Report==
+
The iReport datasource management and selection window can be found just below the menu bar in iReport Designer.
The Accident Victim Summary report lists accidents and the victims that are linked to them. In this example, the victim data is linked to the accident and returned via a sub-report. For this type of report, compile the sub-report (Sub-reports\Summary_AccidentVictim_sub-report0.jrxml) before attempting to run the main report.
+
[[Image:IReport Datasources Window.png|center|500px|''Datasource selection window'']]
 
 
Set the SUB-REPORT_DIR parameter to .\Sub-reports\.
 
[[Image:Accident Victim.png|center|500px|''Figure 48.'' ''Sample report- Accident victim summary'']]
 
 
 
====Table 13====
 
{| class="wikitable"
 
|-
 
| File name|| Summary_AccidentVictim.jrxml
 
|-
 
| Data source
 
|| Accident
 
Query executor (used by victim sub-report)
 
|-
 
| Variables
 
|| Sum of area size
 
Count of metal contamination level
 
|-
 
| Derived fields|| None
 
|-
 
| Sub-reports|| Sub-reports\Summary_AccidentVictim_sub-report0.jrxml
 
|}
 
 
 
==Land Summary Report==
 
File: Summary_Land.jrxml
 
Data source: Land
 
 
 
[[Image:Hazard Summary.png|center|500px|''Figure 49.'' ''Sample report- Land summary'']]
 
 
 
===Activity Summary Report===
 
File: Summary_Hazreduc.jrxml
 
Data source: Activity
 
[[Image:Hazard Reduction.png|center|500px|''Figure 50.'' ''Sample report- Activity summary'']]
 
 
 
===Location Summary Report===
 
File: Summary_Location.jrxml
 
Data source: Location
 
[[Image:Location Summary.png|center|500px|''Figure 51.'' ''Sample report- Location summary'']]
 
 
 
==Education Summary Report==
 
For this type of report, compile the sub-report (Sub-reports\Summary_Education_sub-report1.jrxml) before attempting to run the main report.
 
 
 
Set the SUB-REPORT_DIR parameter to .\Sub-reports\.
 
[[Image:MRE Summary.png|center|500px|''Figure 52.'' ''Sample report- Education summary'']]
 
 
 
====Table 15====
 
{| class="wikitable"
 
|-
 
| File name|| Summary_Education.jrxml
 
|-
 
| Data source
 
|| Education
 
Query executor (used by the sub-report)
 
|-
 
| Derived fields|| None
 
|-
 
| Sub-reports|| Sub-reports\Summary_Education_sub-report1.jrxml
 
|}
 
 
 
===Organisation List Report===
 
File: Summary_Organisation.jrxml
 
Data source: Organisation
 
 
 
[[Image:Organisation List Report.png|center|500px|''Figure 53.'' ''Sample report- Organisation list'']]
 
 
 
===Place List Report===
 
File: Summary_Place.jrxml
 
Data source: Place
 
[[Image:Place List Report.png|center|500px|''Figure 54.'' ''Sample report- Place list'']]
 
 
 
===Quality Control Summary Report===
 
File: Summary_QA.jrxml
 
Data source: Qa
 
[[Image:Quality Control Summary Report.png|center|500px|''Figure 55.'' ''Sample report- Quality control summary'']]
 
 
 
==Appendix A: IMSMA Database==
 
===Overview===
 
The IMSMA database contains tables for IMSMA’s base data (country structures, explosive, ordnance, organisations, and places), locations, and the locations’ associated accidents, Lands, Activities, Educations, QMs, and victims.  
 
 
 
[[Image:fig56iR_Appndx.png|center|500px|''Figure 56. Conceptual database model'']]
 
 
<div align="center">
 
<div align="center">
''Figure 56. Conceptual database model''
+
''iReport Datasource Selection Window''
 
</div>
 
</div>
  
Within each country structure are zero or more locations. For example, a particular province may have multiple locations within it while another province has no locations. Each location may have zero or more items such as accidents, Lands, Activities, Educations, QMs, or victims associated with them. These accidents, Lands, Activities, Educations, QMs, or victims are added to the IMSMA database via data entry forms.
+
===Fields===__NOEDITSECTION__
 
+
Fields in iReport refer to individual IMSMA data elements that are available from a data source. Fields are denoted in iReport using the following syntax '''''$F{fieldname}''''' (e.g. '''''$F{guid}'''''). Each data source contains a list of available fields.
IMSMA items may have either a direct or a linked relationship to other items. Direct relationships occur when one item requires the other item to exist. For example, an accident, Land, Activity, Education, QM, or victim has a direct relationship to the location to which it is associated. The accident, Land, Activity, Education, QM, or victim cannot exist unless it is associated with a location. This direct relationship is enforced in IMSMA via the reconciliation process. Direct relationships also exist when subsets of data are contained within an item. 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 to exist. Table 15. Direct relationships between items lists the items and the data subsets that depend on them.
+
===Variables===__NOEDITSECTION__
 
+
Variables in iReport are created within the iReport template to manipulate or calculate data. Using variables, users can create calculations such as sums, counts, averages, or other totals. Variables are denoted in iReport using the following syntax '''''$V{variablename}''''' (e.g. '''''$V{SumAreaSize}'''''). Variables can use field and/or parameter data.
<center>
+
===Parameters===__NOEDITSECTION__
{| class="wikitable" width="500"
+
Parameters in iReport are used to accept and transfer external information, such as information from another report. Parameters are denoted in iReport using the following syntax '''''$P{parametername}''''' (e.g. '''''$P{ParentGuid}''''')
|-
+
===Bands===__NOEDITSECTION__
| align="center" colspan="2" | '''Table 15. Direct relationships between items'''
+
Bands are used in iReport to specify areas on the resulting report. Each band acts differently in a report. The most used bands in iReport are:
|-
+
{| class="wikitable" style="margin: 1em auto 1em auto;"
| width="100pt" | '''Parent item'''
 
| align="center" width="400pt" | '''Child item(s) which require the parent item'''
 
|-
 
| Activity || Impact survey
 
Interviewee
 
Organisation
 
Question
 
Vegetation removal
 
|-
 
| Location || Accident
 
Land
 
Activity
 
Education
 
QA
 
Victim
 
|-
 
| Education || Education details
 
|-
 
| Victim || Received Education
 
|}
 
</center>
 
 
 
Linked relationships are optional relationships which may exist between items. Accidents, Lands, Activities, Educations, 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.  
 
 
 
===Guids===
 
All records in IMSMA have a guid. A guid is a unique value that identifies the record in the IMSMA database. Because the guid is lengthy and comprised of alphanumeric characters, it is typically not a useful value to display in a report. However, the guid is necessary in determining which item records have a direct relationship, and in determining what links exists between item records.
 
 
 
All accidents, Lands, Activities, Educations, QMs, and victims are associated with a single location. The information about the location to which an item record is associated is stored in the location_guid field of the item table and corresponds to the location_guid of the location to which it is associated ([[:Image:fig57iR_Appndx.png|Figure 57]]). 
 
 
 
[[Image:fig57iR_Appndx.png|center|500px|''Figure 57. location_guid'']]
 
<div align="center">
 
''Figure 57. location_guid''
 
</div>
 
 
 
The location_guid field in the item table contains the guid of the location to which the item record is associated. [[:Image:fig58iR_Appndx.png|Figure 58]] shows an example of a location and the accident and Land that are associated to the location. Notice that the location_guid value (1234-1234) in the accident and Land are identical to the location_guid of the location.  
 
 
 
[[Image:fig58iR_Appndx.png|center|500px|''Figure 58. location_guid example'']]
 
<div align="center">
 
''Figure 58. location_guid example''
 
</div>
 
 
 
When you create a report on a location and its associated items, you will need to use location.guid = "$P{'''LocationParamName'''}" in the query of the sub-report where '''LocationParamName''' is the name of the parameter that you created for the location ([[:Image:fig59iR_Appndx.png|Figure 59]]).
 
 
 
[[Image:fig59iR_Appndx.png|center|500px|''Figure 59. Sub-report query for location and associated items'']]
 
<div align="center">
 
''Figure 59. Sub-report query for location and associated items''
 
</div>
 
 
 
IMSMA allows users to define relationships between item records of differing types. For example, an accident may be related to a particular Land. These relationships are referred to as links. The link table contains the links that have been defined between item records. The link table contains the guid of the item from which the link was established (from_guid) and the guid to which the link is being established (to_guid). [[:Image:fig60iR_Appndx.png|Figure 60]] shows an example of a link that was created from an accident to a Land. These links are stored in the link table.
 
 
 
[[Image:fig60iR_Appndx.png|center|500px|''Figure 60. Link table example'']]
 
<div align="center">
 
''Figure 60. Link table example''
 
</div>
 
 
 
When you create a report that includes linked items, you will need to use links.toGuid = "$P{'''PrimaryParamName'''} in the query of the sub-report where '''PrimaryParamName''' is the name of the parameter that you created for the primary report item ([[:Image:fig61iR_Appndx.png|Figure 61]]).
 
 
 
[[Image:fig61iR_Appndx.png|center|500px|''Figure 61. Sub-report query for linked items'']]
 
<div align="center">
 
''Figure 61. Sub-report query for linked items''
 
</div>
 
 
 
==Appendix B. Data Source Fields==
 
The following sections list the various data sources that are available in iReport and the fields within them.
 
 
 
Need to add derived fields to this list
 
 
 
===Accident===
 
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.  
 
 
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Accident fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Accident Description || Text
 
|-
 
| Accident ID || Varchar(50)
 
|-
 
| Area Marked || Varchar(38)
 
|-
 
| Area Officer || Varchar(50)
 
|-
 
| Clearance In Progress? || Varchar(38)
 
|-
 
| Confirmed || Varchar(38)
 
|-
 
| Data Gathered By || Varchar(25)
 
|-
 
| Date of Accident || Datetime
 
|-
 
| Description of ref area ||
 
|-
 
| Distance From Nearest Town || Text
 
|-
 
| Distance From City ||
 
|-
 
| Equipment Damage || Float
 
|-
 
| Guid || Varchar(38)
 
|-
 
| Inquiry Report Reference || Text
 
|-
 
| Lat/Long ||
 
|-
 
| Linked Victim Name(s) || A derived field that returns A comma separated list of the names (first and last) of all victims that are linked to the accident.
 
|-
 
| Location ID || Varchar(38)
 
|-
 
| Mine Action Activity Type || Varchar(38)
 
|-
 
| Municipality || Varchar(125)
 
|-
 
| Number of Linked Victims || A derived field that returns the number of victims that are linked to the accident.
 
|-
 
| Number of Persons Involved || Int(10)
 
|-
 
| Property Damage || Float
 
|-
 
| Reliability of Information || Varchar(38)
 
|-
 
| Reliability of Source || Varchar(38)
 
|-
 
| Source || Varchar(50)
 
|-
 
| Type of Accident || Varchar(38)
 
|-
 
| Type of Area || Varchar(38)
 
|-
 
| Type of Hazardous Area || Varchar(38)
 
|-
 
| Unknown Device || Varchar(38)
 
|-
 
| Was Mine/UXO Marked? || Varchar(38)
 
|}
 
</center>
 
 
 
===Land===
 
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.
 
 
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 16. Land fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Agricultural Fields Blocked || Varchar(38)
 
|-
 
| Anti-lift Fitted || Varchar(38)
 
|-
 
| Area Size || Float
 
|-
 
| Azimuth || Float
 
|-
 
| Best Route To Land || Text
 
|-
 
| Blocked Roads || Varchar(38)
 
|-
 
| Blocked Water Access || Varchar(38)
 
|-
 
| Booby Trapped || Varchar(38)
 
|-
 
| Calculated Size ||
 
|-
 
| Clearance Difficulty || Varchar(38)
 
|-
 
| Comments || Text
 
|-
 
| Condition of Mines/UXO || Varchar(38)
 
|-
 
| Confirmed || Varchar(38)
 
|-
 
| Contamination Type ||
 
|-
 
| Coordinates Visually Verified ||
 
|-
 
| Dev Proj Contact TC ||
 
|-
 
| Dev Proj Funded TC ||
 
|-
 
| Development Project Planned in Area || Varchar(38)
 
|-
 
| Device Classification || Varchar(38)
 
|-
 
| Direction from City ||
 
|-
 
| Distance From Nearest Town || Float
 
|-
 
| Drainage Features ||
 
|-
 
| Estimated Clearance Completion || Varchar(50)
 
|-
 
| Estimated Length || Float
 
|-
 
| Estimated Width || Float
 
|-
 
| Fighting In Area || Varchar(38)
 
|-
 
| Fixed TC ||
 
|-
 
| Ground Profile ||
 
|-
 
| Guid || Varchar(38)
 
|-
 
| Land Description || Text
 
|-
 
| Land ID || Varchar(50)
 
|-
 
| Land Name || Varchar(125)
 
|-
 
| Identifier ||
 
|-
 
| Identifying Person Contact ||
 
|-
 
| Identifying Person Name ||
 
|-
 
| Information Source || Varchar(38)
 
|-
 
| Infrastructure Blocked || Varchar(38)
 
|-
 
| Intended Land Use || Varchar(38)
 
|-
 
| Intended Land Use Date || Date
 
|-
 
| Lat/Long ||
 
|-
 
| Linked Activity IDs || A derived field that returns a comma separated list of the local IDs of all Activities that are linked to the Land.
 
|-
 
| Location ID || Varchar(38)
 
|-
 
| Major Impacts || Text
 
|-
 
| Map Coordinate System TC ||
 
|-
 
| Marking Type ||
 
|-
 
| Measured From View Point ||
 
|-
 
| Medical Facility Level 1 || Text
 
|-
 
| Medical Facility Level 2 || Text
 
|-
 
| Medical Facility Level 3 || Varchar(38)
 
|-
 
| Medical Facility Level 4 || Varchar(38)
 
|-
 
| Medivac || Varchar(38)
 
|-
 
| Metal Contamination Level || Varchar(38)
 
|-
 
| Metal Content Level || Varchar(38)
 
|-
 
| Mine Action Area Type ||
 
 
|-
 
|-
| Municipality ||
+
! Band Name !! Use
 
|-
 
|-
| Number Of Affected Communities || Int(10)
+
| Title || Displayed once at the beginning of the report
 
|-
 
|-
| Ordnance SubCategory List || A derived field that returns "-" separated list of all sub-categories of ordnance that are present in the Land.
+
| Column or Group Header || Displayed at the top of each page or section
 
|-
 
|-
| Other Vital Point Text ||
+
| Detail || Displayed once for each data row returned by the report. Most often data elements will exist in this band.
 
|-
 
|-
| Planned Clearance Total Area || A derived field that returns the total area size of all clearances that are linked to the Land. "Clearance" is defined as a Activity where the type is set to  "Clearance", "Road Clearance" or "Battle Area Clearance"
+
| Summary || Displayed once at the end of the report. Useful for charts, crosstabs, and totals.
|-
 
| Priority || Varchar(38)
 
|-
 
| Reason for Depth || Text
 
|-
 
| Recommended Clearance Depth || Float
 
|-
 
| Recommended Number Of Demining Teams || Int(10)
 
|-
 
| Reliability of Information  || Varchar(38)
 
|-
 
| Reliability of Source || Varchar(38)
 
|-
 
| Road Alternative Text ||
 
|-
 
| Road To Other Text ||
 
|-
 
| Road Usable For || Varchar(38)
 
|-
 
| Seasonal Consideration || Text
 
|-
 
| Slope || Varchar(38)
 
|-
 
| Soil Type ||
 
|-
 
| Status || Varchar(38)
 
|-
 
| Suitable for ||
 
|-
 
| Terrain Category || Varchar(38)
 
|-
 
| Terrain/Locale Information || Text
 
|-
 
| Time to Travel to Level 1 || Time
 
|-
 
| Time to Travel to Level 2 || Time
 
|-
 
| Time to Travel to Level 3 || Time
 
|-
 
| Time to Travel to Level 4 || Time
 
|-
 
| Travel Time to Medivac || Time
 
|-
 
| Type of Area || Varchar(38)
 
|-
 
| Type of Blocked Agriculture ||
 
|-
 
| Type of Hazardous Area || Varchar(38)
 
|-
 
| Type of Infrastructure Blocked ||
 
|-
 
| Type Of Mechanical Device ||
 
|-
 
| Type of Non-Agricultural Areas Blocked ||
 
|-
 
| Type of Roads Blocked ||
 
|-
 
| Type of Water Blocked ||
 
|-
 
| Unknown Device ||
 
|-
 
| Vegetation ||
 
|-
 
| Vegetation Density || Varchar(38)
 
|-
 
| Vegetation Removed By || Varchar(38)
 
|-
 
| Walk Time ||
 
 
|}
 
|}
</center>
 
  
===Activity===
+
===Groups===__NOEDITSECTION__
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.  
+
Groups in iReport are used to display records with one or more common values together on a report. For example, Land with the same value for "Province" could be grouped together in a report. Groups can be added in the iReport Wizard or after a report has been created.
 +
===Subreports===__NOEDITSECTION__
 +
Subreports are used in iReport to include more than one data source in a report. For example, to include information about Activities performed on a particular Land, you would include an Activity subreport in the Land report.
 +
===Crosstabs, Charts, and Formatting Elements===__NOEDITSECTION__
 +
In addition to the iReport elements addressed above, additional specialized iReport elements are available to include in iReport templates including Crosstabs, Charts, and additional formatting elements such as lines, rectangles, etc. Crosstabs and chart elements typically belong only in the Summary band of a report while formatting elements including images can be included anywhere within the report template.
  
<center>
+
{{Note | All field, variable, and parameter references in {{IMSMANG}} are case-sensitive}}
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 17. Land fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Anti Lift ||
 
|-
 
| Anti-Lift Fitted ||
 
|-
 
| Area Description ||
 
|-
 
| Area Officer ||
 
|-
 
| Area Officer ||
 
|-
 
| Assumption Prior to Visit ||
 
|-
 
| Best Route to Site ||
 
|-
 
| Booby Trap ||
 
|-
 
| Bobby Trapped ||
 
|-
 
| Comment ||
 
|-
 
| Community Leader ||
 
|-
 
| Confirmed ||
 
|-
 
| Contamination Type ||
 
|-
 
| Cost Per Meter ||
 
|-
 
| Dangerous Area Type ||
 
|-
 
| Depth ||
 
|-
 
| Destruction Method ||
 
|-
 
| Distance from Nearest Town ||
 
|-
 
| Drainage Features ||
 
|-
 
| End Date ||
 
|-
 
| End Period ||
 
|-
 
| Estimated Workday ||
 
|-
 
| Fighting in Area ||
 
|-
 
| Ground Profile ||
 
|-
 
| Guid ||
 
|-
 
| Activity ID ||
 
|-
 
| Activity Name ||
 
|-
 
| Hours Spent ||
 
|-
 
| Intended Land Use ||
 
|-
 
| Interviewer ||
 
|-
 
| Lat/Long ||
 
|-
 
| Length ||
 
|-
 
| Location ID ||
 
|-
 
| Marking ||
 
|-
 
| Marking Method ||
 
|-
 
| Medical Facility Level 1 ||
 
|-
 
| Medical Facility Level 2 ||
 
|-
 
| Medical Facility Level 3 ||
 
|-
 
| Medical Facility Level 4 ||
 
|-
 
| Medivac ||
 
|-
 
| Metal Contamination level ||
 
|-
 
| Mines/UXO Condition ||
 
|-
 
| Monitor ||
 
|-
 
|Municipality ||
 
|-
 
| Number of Teams ||
 
|-
 
| Number of Vehicles ||
 
|-
 
| Operational Notes ||
 
|-
 
| Ordnance SubCategory Exists || A derived field that returns “true” if the Activity contains ordnance data where the sub-category matches the |-
 
Subcategory property. Please note that you must specify a sub-category with this field.
 
|-
 
| Organisation ||
 
|-
 
| Planned End Date ||
 
|-
 
| Planned Start Date || A derived field that returns the number of positive samples for the Activity.
 
|-
 
| Priority Correction ||
 
|-
 
| QM Comments ||
 
|-
 
| Quality Assurance ||
 
|-
 
| Recommendations ||
 
|-
 
| Reduction Method ||
 
|-
 
| Reliability of Information ||
 
|-
 
| Reliability of Source ||
 
|-
 
| Reported Progress Area Size || A derived field that returns the total area size of all "Progress Report" data entry forms that were reconciled to the Activity.
 
|-
 
| Road Usable For ||
 
|-
 
| Size of Area ||
 
|-
 
| Soil Metal Content Level ||
 
|-
 
| Soil Type ||
 
|-
 
| SOP Dog ||
 
|-
 
| SOP Manual ||
 
|-
 
| SOP Mechanical ||
 
|-
 
| SOP Metal Detector ||
 
|-
 
| Start Date ||
 
|-
 
| Start Period ||
 
|-
 
| Status ||
 
|-
 
| Survey MA Guid ||
 
|-
 
| Task Dossier ||
 
|-
 
| Tasked By ||
 
|-
 
| Team ID ||
 
|-
 
| Team Leader ||
 
|-
 
| Team Location ||
 
|-
 
| Terrain Category ||
 
|-
 
| Time to Travel to Level 1 ||
 
|-
 
| Time to Travel to Level 2 ||
 
|-
 
| Time to Travel to Level 3 ||
 
|-
 
| Time to Travel to Level 4 ||
 
|-
 
| Total Land Area Size || A derived field that returns the total area size of all Lands that are linked to the Activity.
 
|-
 
| Travel Time to Medivac ||
 
|-
 
| Type of Activity ||
 
|-
 
| Uncleared Area Size ||
 
|-
 
| Verification Notes ||
 
|-
 
| Victim Count || A derived field that returns the number of victims that are linked to the Activity.
 
|-
 
| Visitor ||
 
|-
 
| Year of Reduction || A derived field that returns a string representation of a date formatted by the user provided format, or "yyyy" if no format is |-
 
provided.  The date is the first of the following fields of the Activity that contains data: Start Date, End Date, Planned Start Date, Planned End Date. An optional date format may be specified.
 
|}
 
</center>
 
 
 
===Impact Survey===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 18. Impact survey fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Accident Cause ||
 
|-
 
| Accident in Area ||
 
|-
 
| Casualty Type ||
 
|-
 
| Economic Base ||
 
|-
 
| Enumerator 1 ||
 
|-
 
| Enumerator 2 ||
 
|-
 
| Expert Type ||
 
|-
 
| Fuel Available ||
 
|-
 
| Guid ||
 
|-
 
| Higher Education ||
 
|-
 
| Higher Education Comments ||
 
|-
 
| Last Conflict Year ||
 
|-
 
| Local Clearance Effects ||
 
|-
 
| Local Clearance Effort ||
 
|-
 
| Major Mine Impacts ||
 
|-
 
| Medical Facility Type ||
 
|-
 
| Military Activity Intensity ||
 
|-
 
| Mine History Comments ||
 
|-
 
| Education Community Centre ||
 
|-
 
| Education Organization Involved ||
 
|-
 
| Education Other ||
 
|-
 
| Education Performing Group ||
 
|-
 
| Education Posters ||
 
|-
 
| Education Radio ||
 
|-
 
| Education Religious Centre ||
 
|-
 
| Education School Presentation ||
 
|-
 
| Education Victim Assistance ||
 
|-
 
| Education within 24 Months ||
 
|-
 
| Number of Households Census ||
 
|-
 
| Number of Households Census Pre-War ||
 
|-
 
| Number of Households Key Informants ||
 
|-
 
| Number of Households Key Informants Pre-War ||
 
|-
 
| Number of Primary Schools ||
 
|-
 
| Number of Secondary Schools ||
 
|-
 
| Number of Victims Injured – Old ||
 
|-
 
| Number of Victims Killed – Old ||
 
|-
 
| Origin of Impact Survey Report ||
 
|-
 
| Piped Water Supply ||
 
|-
 
| Population Census ||
 
|-
 
| Population Census Pre-War ||
 
|-
 
| Primary Interview Language ||
 
|-
 
| Priority ||
 
|-
 
| Recent Marking Survey ||
 
|-
 
| Recent Mine Clearance ||
 
|-
 
| Settlement Established ||
 
|-
 
| Telephone Connection ||
 
|-
 
| Year Mines Last Planted ||
 
|-
 
| Year Mines Problem Began ||
 
|}
 
</center>
 
 
 
===Interviewee===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 19. Interviewee fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Age ||
 
|-
 
| Family Name ||
 
|-
 
| From Date of Service ||
 
|-
 
| Gender ||
 
|-
 
| Given Name ||
 
|-
 
| Guid ||
 
|-
 
| Interviewee Type ||
 
|-
 
| Length of Service ||
 
|-
 
| Location of Service ||
 
|-
 
| Mine Victim ||
 
|-
 
| Movement Member ||
 
|-
 
| Position Rank ||
 
|-
 
| Time in Area ||
 
|-
 
| To Date of Service ||
 
|-
 
| Vocation Type ||
 
|}
 
</center>
 
 
 
===Location===
 
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 20. Location fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Country Structure ||
 
|-
 
| Evacuation Route(s) ||
 
|-
 
| Guid ||
 
|-
 
| Lat/Long ||
 
|-
 
| Linked Land IDs || A derived field that returns a comma separated list of the local IDs of all Lands that are part of the location.
 
|-
 
| Location Description  ||
 
|-
 
| Location ID ||
 
|-
 
| Nearest Medical Facility ||
 
|-
 
| Total Land Area Size || A derived field that returns the total area size of all Lands that are part of the location.
 
|}
 
</center>
 
 
 
===Education===
 
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 21. Education fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Campaign Level
 
|-
 
| Comments ||
 
|-
 
| Confirmed ||
 
|-
 
| Date ||
 
|-
 
| End Date ||
 
|-
 
| Guid ||
 
|-
 
| Lat/Long ||
 
|-
 
|  Location ID ||
 
|-
 
| Mine Action Type ||
 
|-
 
| Education ID ||
 
|-
 
| Municipality ||
 
|-
 
| Organisation ||
 
|-
 
| Period ||
 
|-
 
| Planned End Date ||
 
|-
 
| Planned Start Date ||
 
|-
 
| Project ||
 
|-
 
| Qty ||
 
|-
 
| Reason ||
 
|-
 
| Reliability of Information ||
 
|-
 
| Reliability of Source ||
 
|-
 
| Start Date ||
 
|-
 
| Status ||
 
|-
 
| Supported Activity Type ||
 
|}
 
</center>
 
 
 
===Education Details===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 21. Education fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Campaign Level ||
 
|-
 
| Comments ||
 
|-
 
| Confirmed ||
 
|-
 
| Date ||
 
|-
 
| District ||
 
|-
 
| End Date ||
 
|-
 
| Guid ||
 
|-
 
| Lat/Long ||
 
|-
 
| Mine Action Type ||
 
|-
 
| Education ID ||
 
|-
 
| Municipality ||
 
|-
 
| Organisation ||
 
|-
 
| Period ||
 
|-
 
| Planned End Date ||
 
|-
 
| Planned Start Date ||
 
|-
 
| Project ||
 
|-
 
| Qty ||
 
|-
 
| Reason ||
 
|-
 
| Reliability of Information ||
 
|-
 
| Reliability of Source ||
 
|-
 
| Start Date ||
 
|-
 
| Status ||
 
|-
 
| Supported Activity Type ||
 
|}
 
</center>
 
 
 
===Organisation===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 23. Organisation fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Accreditation Status ||
 
|-
 
| Address ||
 
|-
 
| Category ||
 
|-
 
| Contact Name ||
 
|-
 
| Core Competence ||
 
|-
 
| Country Structure ||
 
|-
 
| Email ||
 
|-
 
| Exists in CMAC ||
 
|-
 
| Fax Number ||
 
|-
 
| Guid ||
 
|-
 
| ID ||
 
|-
 
| Lat/Long ||
 
|-
 
| Local ID ||
 
|-
 
| MAC Guid ||
 
|-
 
| Mobile Phone Number ||
 
|-
 
| Name ||
 
|-
 
| Number of Teams ||
 
|-
 
| Organisation Comment ||
 
|-
 
| Organisation Level ||
 
|-
 
| Other ||
 
|-
 
| Parent ||
 
|-
 
| Phone Number ||
 
|-
 
| Radio ||
 
|-
 
| Short Name ||
 
|-
 
| Specialisation ||
 
|-
 
| Website URL ||
 
|}
 
</center>
 
 
 
===Place===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 24. Place fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Address ||
 
|-
 
| Country Structure ||
 
|-
 
| Description ||
 
|-
 
| Email ||
 
|-
 
| Fax ||
 
|-
 
| Guid ||
 
|-
 
| Homepage ||
 
|-
 
| Lat/Long ||
 
|-
 
| Local ID ||
 
|-
 
| Name ||
 
|-
 
| Telephone ||
 
|-
 
| Type ||
 
|}
 
</center>
 
 
 
===QA===
 
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 25.QA fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Acceptance Date ||
 
|-
 
| Accredited By UNMAO ||
 
|-
 
| Activity Type ||
 
|-
 
| Additional Info ||
 
|-
 
| Adequate Supervision ||
 
|-
 
| Area Size ||
 
|-
 
| Clearance Area Description ||
 
|-
 
| Clearance Depth ||
 
|-
 
| Clearance Equipment Inspected ||
 
|-
 
| Cleared Area Size ||
 
|-
 
| Compliant with NTSG ||
 
|-
 
| Compliant with Org SOP ||
 
|-
 
| Copy To ||
 
|-
 
| Date of Activity ||
 
|-
 
| Debrief Accepted ||
 
|-
 
| Debrief Provided ||
 
|-
 
| Delivery Date ||
 
|-
 
| Documentation ||
 
|-
 
| End Date ||
 
|-
 
| Equipment Stored Properly ||
 
|-
 
| Equipment Suitable ||
 
|-
 
| Evidence Of Test and Evaluation ||
 
|-
 
| Facilities Inspected ||
 
|-
 
| Facilities Suitable ||
 
|-
 
| Guid ||
 
|-
 
| Hours Spent ||
 
|-
 
| Inspector Name ||
 
|-
 
| Internal QA Logs Current ||
 
|-
 
| Lat/Long ||
 
|-
 
| Location ID ||
 
|-
 
| MAC Rep Name ||
 
|-
 
| Mac Rep Position ||
 
|-
 
| MAC Rep Sign Date ||
 
|-
 
| Maintenance Log Current ||
 
|-
 
| Marking ||
 
|-
 
| Nearest City GUID ||
 
|-
 
| Noncompliance Corrected ||
 
|-
 
| Operations Suspended ||
 
|-
 
| Operations Suspended Reason ||
 
|-
 
| Organisation ||
 
|-
 
| Original To ||
 
|-
 
| Personnel Qualified ||
 
|-
 
| Planned End Date ||
 
|-
 
| Planned Start Date ||
 
|-
 
| QM ID ||
 
|-
 
| QM Result Status ||
 
|-
 
| Qualified Medic Avail ||
 
|-
 
| Quality Assurance By ||
 
|-
 
| Responsible Author  ||
 
|-
 
| Responsible Author Sign Date ||
 
|-
 
| Responsible Author Sign Organisation ||
 
|-
 
| Rresults ||
 
|-
 
| Special Monitoring Reason ||
 
|-
 
| Start Date ||
 
|-
 
| Status ||
 
|-
 
| Support Equipment Inspected  ||
 
|-
 
| Task Dossier ||
 
|-
 
| Uncleared Area Description ||
 
|-
 
| Uncleared Area Size ||
 
|-
 
| Visitor Logs Current ||
 
|-
 
| Warning Delivered ||
 
|-
 
| Warning Explained ||
 
|-
 
| Warning Received ||
 
|-
 
| Worksite ||
 
|}
 
</center>
 
 
 
===Question===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 26.Question fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Comments ||
 
|-
 
| Guid ||
 
|-
 
| How Far ||
 
|-
 
| How Often ||
 
|-
 
| Question ||
 
|-
 
| Where ||
 
|}
 
</center>
 
 
 
===Received Education===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 27.Received Education fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Guid ||
 
|-
 
| Education Activity ||
 
|-
 
| Education Activity Class ||
 
|-
 
| Education Activity Other ||
 
|-
 
| Education Frequency ||
 
|}
 
</center>
 
 
 
===Vegetation===
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 29.Vegetation fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Guid ||
 
|-
 
| MVCM Area Desc ||
 
|-
 
| MVCM Area Size ||
 
|-
 
| MVCM Date ||
 
|-
 
| Vegetation Removed By ||
 
|}
 
</center>
 
 
 
===Victim===
 
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.
 
<center>
 
{| class="wikitable" width="500"
 
|-
 
| align="center" colspan="2" | '''Table 30. Location fields'''
 
|-
 
| width="250pt" | '''Field name'''
 
| align="center" width="250pt" | '''Data type'''
 
|-
 
| Activity At Time of Accident ||
 
|-
 
| Activity At Time of Accident Other ||
 
|-
 
| Aaddress ||
 
|-
 
| Age ||
 
|-
 
| Care Type ||
 
|-
 
| Date Of Birth ||
 
|-
 
| Did victim see the object? ||
 
|-
 
| First Medical Facility ||
 
|-
 
| First Name ||
 
|-
 
| Gender ||
 
|-
 
| Guid ||
 
|-
 
| Hospital ||
 
|-
 
| How Often Entered Area? ||
 
|-
 
| Injury ||
 
|-
 
| Kiilled/Injured ||
 
|-
 
| Knew Area Was Dangerous? ||
 
|-
 
| Last Name ||
 
|-
 
| Lat/Long ||
 
|-
 
| Location ID ||
 
|-
 
| Medical Report Reference ||
 
|-
 
| Mine Avoidance Trained ||
 
|-
 
| National Identifier ||
 
|-
 
| Nationality ||
 
|-
 
| Occupation ||
 
|-
 
| Other Organisation ||
 
|-
 
| Protective Equipment ||
 
|-
 
| Rank ||
 
|-
 
| Reason Entered Area ||
 
|-
 
| Skills ||
 
|-
 
| Status ||
 
|-
 
| Time to First Medical Facility ||
 
|-
 
| Time to Hospital ||
 
|-
 
| Victim ID ||
 
|-
 
| Was the PPE effective? ||
 
|-
 
| timeToHospital ||
 
|}
 
</center>
 
  
 
{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}
 
{{NavBox HowTo Standardizing Data Analysis and Information Reporting}}
 +
[[Category:VIE]]

Revision as of 20:00, 4 October 2016

Introduction to iReport

iReport Designer (also known as iReport) is a third-party application that allows you to generate custom-defined reports on IMSMA data. Using iReport, you may define the attributes that are returned by a report and also customise the appearance of the report. Report templates designed in iReport can be imported into IMSMANG and run by IMSMANG users to extract data based on search criteria. Reports can be exported to PDF, RTF, XLS, and other formats. iReport Designer version 5.0.1 is included with the IMSMANG distribution. Using iReport Designer, users create .jrxml iReport templates, a kind of xml report definition, that can be used by IMSMANG to produce a formatted report.

Note.jpg iReport does not support Java 8.

iReport Basics

iReport uses standard reporting terms to refer to the basic building blocks of report templates.

Data Sources

Data sources in iReport refer to the connection between the report template and the IMSMANG database. Each iReport template will have one data source. Data sources in iReport generally refer to items in IMSMANG such as Land, Activity, Education, Accident, Victim, etc. Available data sources include:

Available Data Sources
Accident Device MRE
Accident MRE Detail
Assistance Classification Needs Assessment Classification
Cause Classification Ordnance
Field Report Organisation
Gazetteer Place
Geopoint QM
Geospatialinfo Question
Hazard Received MRE
Hazard Device Task
Hazard Reduction Victim
Hazard Reduction Device Victim Assistance
Impact Survey Victim Assistance Assistance
Interviewee Victim Cause
Link Victim Needs Assessment
Location Work Item

The iReport datasource management and selection window can be found just below the menu bar in iReport Designer.

Datasource selection window

iReport Datasource Selection Window

Fields

Fields in iReport refer to individual IMSMA data elements that are available from a data source. Fields are denoted in iReport using the following syntax $F{fieldname} (e.g. $F{guid}). Each data source contains a list of available fields.

Variables

Variables in iReport are created within the iReport template to manipulate or calculate data. Using variables, users can create calculations such as sums, counts, averages, or other totals. Variables are denoted in iReport using the following syntax $V{variablename} (e.g. $V{SumAreaSize}). Variables can use field and/or parameter data.

Parameters

Parameters in iReport are used to accept and transfer external information, such as information from another report. Parameters are denoted in iReport using the following syntax $P{parametername} (e.g. $P{ParentGuid})

Bands

Bands are used in iReport to specify areas on the resulting report. Each band acts differently in a report. The most used bands in iReport are:

Band Name Use
Title Displayed once at the beginning of the report
Column or Group Header Displayed at the top of each page or section
Detail Displayed once for each data row returned by the report. Most often data elements will exist in this band.
Summary Displayed once at the end of the report. Useful for charts, crosstabs, and totals.

Groups

Groups in iReport are used to display records with one or more common values together on a report. For example, Land with the same value for "Province" could be grouped together in a report. Groups can be added in the iReport Wizard or after a report has been created.

Subreports

Subreports are used in iReport to include more than one data source in a report. For example, to include information about Activities performed on a particular Land, you would include an Activity subreport in the Land report.

Crosstabs, Charts, and Formatting Elements

In addition to the iReport elements addressed above, additional specialized iReport elements are available to include in iReport templates including Crosstabs, Charts, and additional formatting elements such as lines, rectangles, etc. Crosstabs and chart elements typically belong only in the Summary band of a report while formatting elements including images can be included anywhere within the report template.

Note.jpg All field, variable, and parameter references in IMSMANG are case-sensitive