NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
<center>
| width="195pt" | '''iReport'''
| width="195pt" | '''Data export'''
| width="195pt" | '''MINT'''
| width="195pt" | '''Other external reporting tool'''
|-
| align="left" | '''Description'''
| align="left" | Includes printing data entry formsData Entry Forms, summaries Summary items and maps
| align="left" | Includes building iReport templates for more sophisticated reporting as well as exporting data for use in external tools such as Microsoft Excel
| align="left" | Includes exporting data to CSV format for use in Excel as well as cutting and pasting from tables.
| align="left" | Web-based reporting and data analysis tool allowing ad-hoc data exploration, creating dashboards for tracking indicators and creating reports.It is best used with the staging area.
| align="left" | The most complicated kind of reporting where users connect to backend databases using SQL, Crystal Reports, ArcGIS Desktop, etc., to perform queries and generate reports
*Manipulating data using external tools
*Pivot tables and charts based on one item
| align="left" |
*Creating dashboards targeted to specific audiences
*Easiest way to get {{IMSMANG}} data into Excel
*Can manipulate data in common applications
| align="left" |
*Several data sources can be combined or integrated
*Limited customisation of resulting data (formats, conditional display, etc.)
*Not ideal for incorporating multiple reports together within a larger report
| align="left" |
*An decent internet connectivity needs to be available
|}
</center>
[[Image:MINT in context graph.png|center|700px|''The different reporting options in context'']]
<div align="center">
''The different reporting options in context''
</div>
==Basic Reporting==__NOEDITSECTION__
{{IMSMANG}} provides several reporting options that allow users to produce basic reports directly from {{IMSMANG}}. These include printing data entry forms Data Entry Forms entered into the system, maps from the main navigation window and item summariesSummary items. Any of these reports can be sent directly to a printer or to an intermediate format such as rich text format (.RTF) or portable document format (.PDF) for transmitting in electronic format or for further editing.
{{IMSMANG}} also includes a Map Layout manager that allows users to define map layouts and print high-quality maps with {{IMSMANG}} data. Information managers can define map layout templates that include scale bars, annotations and legends or use more sophisticated tools like ArcGIS Desktop to prepare more complicated map layouts for displaying {{IMSMANG}} data.
===iReports===__NOEDITSECTION__
{{HowTo's
|[[Use i-Report iReport | Use i-ReportiReport]]
}}
With the iReport tool, information managers have access to an entire suite of report generation functions. iReport provides the ability to design report templates from the desired data elements; add page layout and formatting information including images, colours and text; and import the reports into {{IMSMANG}} for data entry personnel to run. Information managers can also design complex reports to summarise data using sum, count, average, subreports and other statistical reporting functions similar to packages such as Crystal Reports. Being fully integrated into {{IMSMANG}}, iReport can be translated into any language supported by the system. Using this approach, only information managers are presented with the complexity of designing reports while traditional users simply have to select a report (and any preceding search) and run it.
*data quality: number and list of land with incorrect status
Because iReport templates are initiated with a search, they provide a scalable reporting solution that allows one template to be developed for many reports. For example, a report template that shows number a list of land and size of land by province with associated ordnance details can produce different reports depending on the search parameters.
[[Image:AdminGuide_ReportUsingNoSearchParameters.png|center|500px|''Report Example Using No Search Parameters'']]
</div>
In the first example, no search parameter is applied and all data in {{IMSMANG}} is used in the report. But by adding a search parameter, for example, limiting this to land whose status is OpenWorked on, a different report is generated.
[[Image:AdminGuide_ReportUsingSearchParameters.png|center|500px|''Report Example Using a Search Parameter'']]
</div>
Moreover, if the land is further limited to a specific type, another report is generated, using again the same template. This way, information managers can build templates and searches to fulfill multiple reporting needs.
Reports created with iReport can be printed directly within {{IMSMANG}} or saved to an intermediate format such as .RTF, .PDF or .XLS for electronic transmission or additional editing or inclusion in other reports. iReport supports the inclusion of charts, images and headers and footers, and it acts as a complete reporting package.
==Reporting Tools provided for IMSMA==__NOEDITSECTION__
===lightMINTMINT===__NOEDITSECTION__The Mine Action Intelligence Tool (MINT) is available as of {{IMSMANG}} version 6.0. It is a web-based tool for reporting, data analysis and indicator tracking. As such, it allows users to create and view digital dashboards, perform ad-hoc data analysis online in a very intuitive way, create reports and charts online, and upload reports created in a report designer tool. MINT is available on a web server managed by GICHD. Each organisation/programme/country can however manage its own space, create roles and users, manage data sources and data domains, etc. MINT is the most advanced and complete reporting solution provided for IMSMA. It is recommended to connect MINT to the [[IMSMA Staging Area]]. A more detailed description, instructions, how-to pages etc. are available on the [[MINT|MINT pages of this WIKI]].
</div>
==External Reporting Tools==__NOEDITSECTION__
{{IMSMANG}} also allows information managers to connect advanced reporting tools such as Crystal Reports or ArcGIS Desktop directly to its relational database for highly advanced report generation. With this capability, information managers can use custom reporting solutions to connect with {{IMSMANG}}, allowing for complete control of {{IMSMANG}} outputs. Or, managers can modify existing reporting solutions to connect to {{IMSMANG}}, which leverages technology already implemented in the programme and limits the need for retraining.
{{note|Using When using external reporting tools is a complex activity requiring an advanced understanding we recommend to connect to the '''[[IMSMA Staging Area | Staging area]]''' instead of SQL, reporting tools and the {{IMSMANG}} database. It does require knowledge about the IMSMA data model. Contact contact your [[Information Management Team | GICHD IM advisor]] if you have questions.}}
===Connecting other External Reporting Tools===__NOEDITSECTION__
The process for connecting external reporting tools is essentially the same for all tools. External tools connect to the {{IMSMANG}} relational database via an ODBC connection. Information managers establish this connection by installing the ODBC driver for PGSQL. When this is complete, information managers can connect any ODBC-compliant tool to the {{IMSMANG}} database, including reporting tools, other database packages and SQL management tools. Examples include:
{| class="wikitable"! scope="col" | Reporting tools || scope="col" | Database packages || scope="col" | SQL management tools|-*| Crystal Reports|| Microsoft Access || PGSQL Query Browser*|-| ArcGIS Desktop*iReport*Microsoft Excel Database packages *Microsoft Access*|| OpenOffice Base|| Navicat|-*| iReport || Microsoft SQL Server*Oracle|| TOAD SQL management tools*PGSQL Query Browser|-*Navicat*TOAD | Microsoft Excel || Oracle || Heidi SQL*Heidi SQL|}
When connecting an external reporting tool to {{IMSMANG}}, it is recommended that information managers build database views within the database to do any necessary data transformations. While it is possible to directly import or connect {{IMSMANG}} database tables in external tools and perform transformations within the external tools, the recommended method is to do transformations within the {{IMSMANG}} database using database views and then import the resulting views into the external tools.
}}
{{NavBox Getting started with IMSMANG Administration}}
[[Category:VIE]]
