Difference between revisions of "Use iReport"
From IMSMA Wiki
| Line 1: | Line 1: | ||
| + | __FORCETOC__ | ||
| + | {{TOC right}} | ||
{{HowTo's | {{HowTo's | ||
|[[Start and Configure i-Report|Start and Configure i-Report]] | |[[Start and Configure i-Report|Start and Configure i-Report]] | ||
| Line 13: | Line 15: | ||
*'''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. | *'''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. | ||
*'''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. | *'''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''': 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''': 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{paramtername}''''' (e.g. '''''$P{ParentGuid}''''') |
| − | *Bands | + | *'''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: |
| − | + | {| class="wikitable" | |
| − | + | |- | |
| + | ! 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. | ||
| + | |||
| + | {{Note | All field, variable, and parameter references in {{IMSMANG}} are case-sensitive}} | ||
==Sample Reports==__NOEDITSECTION__ | ==Sample Reports==__NOEDITSECTION__ | ||
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. | 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. | ||
{{NavBox HowTo Standardizing Data Analysis and Information Reporting}} | {{NavBox HowTo Standardizing Data Analysis and Information Reporting}} | ||
Revision as of 16:34, 16 September 2013
| How To |
|---|
Introduction to iReport
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.
iReport Basics
iReport uses standard reporting terms to refer to the basic building blocks of a 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.
- 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{paramtername} (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.
 |
All field, variable, and parameter references in IMSMANG are case-sensitive |
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.
| ||||||||||
