Changes

__NOEDITSECTION__The primary purpose Two of most important purposes of any an information system must be to are:* ensure high quality of data and* support operational use of the information .One important use of the data is reporting. If it collectsnot possible in an easy way to create reports/statistics which reflect the data correctly the credibility of the data is lost. That’s why {{IMSMANG }} was designed with a robust reporting and analysis component that supports various reporting options. These options include:

{| class="wikitable" width="8001000"

| align="center" colspan="46" | '''Table 15. Comparison of {{IMSMANG }} Reporting Options'''

| width="195pt" | '''External Other external reporting tool'''

| align="left" | Includes printing field reportsData Entry Forms, current views Summary items and maps

| align="left" | *Navigating data in IMSMA^NG {{IMSMANG}}*General summaries of pre-provided data| align="left" | *Lists and summary reports of single items

*Any report where the Charts| align="left" | *Manipulating data is more important than the formattingusing external tools*Pivot tables and charts based on one item| align="left" | *Linking or exporting {{IMSMANG}} data for use in external tools*Building customised reporting tools for {{IMSMANG}} data*Linking data to ArcGIS Desktop, Crystal Reports and other tools

| align="left" | Hazard Reduction |'''Benefits''' | align="left" | NameStart Date*Fast and easy to useEnd Date*Requires little or no trainingType of Activity| align="left" | Organisation*Can limit data using searchesStatus*Can be preformatted and available on a networkOrdnance Found*Backed up and storedHours Spent*Users can simply run these reports as opposed to building themSize of Area*Supports charts| align="left" | MRE |*Easiest way to get {{IMSMANG}} data into Excel*Can manipulate data in common applications| align="left" | Start DateEnd DateOrganisationMRE Detail IDMRE Type% Male% Female*Most powerful and customisable way of accessing data for reportsAudience Number*Can manipulate data in advanced or custom reporting applicationsAudience Age Info*Can be linked with external databases

| align="left" | Accident |'''Challenges''' | align="left" | Date of AccidentAccident Type*Reports are simplistic*Limited to printing and reports provided with the software. No customisation.| align="left" | QM |*Not ideal for incorporating multiple reports together within a larger report| align="left" | Start DateEnd Date*Limited customisation of resulting data (formats, conditional display, etc.)Organisation*Not ideal for incorporating multiple reports together within a larger reportResults| align="left" | *Requires expert level understanding of SQL

 Navigating data in {{IMSMANG General summaries of pre}} also includes a Map Layout manager that allows users to define map layouts and print high-provided quality maps with {{IMSMANG}} data Lists and summary reports of single items Simple cross tabs Monthly progress reports for internal consumption Any report where the data is more important than the formatting  Manipulating data using external tools Pivot tables . Information managers can define map layout templates that include scale bars, annotations and charts based on one item  Linking legends or exporting IMSMANG data for use in external tools Building customised reporting more sophisticated tools like ArcGIS Desktop to prepare more complicated map layouts for displaying {{IMSMANG }} data Linking data to ArcGIS Desktop, Crystal Reports and other tools.

Benefits  Fast {{note|* Map layouts can be printed and easy scaled to useany size paper. This is a simple way of producing {{IMSMANG}} maps without needing additional GIS software. Requires little * Map layout templates can be prepared and distributed to individual {{IMSMANG}} clients, allowing information managers to prepare templates based on user preferences or no trainingfunctional needs.}}

 Can limit data using searches Can be preformatted and available on a network Backed up and stored Users can simply run these reports as opposed to building them Supports charts  Easiest way to get IMSMANG data into Excel Can manipulate data in common applications  Most powerful and customisable way of accessing data There are two options for reports Can manipulate data in advanced or custom embedded reporting applications Can be linked with external databasesChallenges  Reports are simplistic Limited to printing : iReports and reports provided with the software. No customisation.  Limited customisation of resulting data (formats, conditional display, etcexport.) Not ideal for incorporating multiple reports together within a larger report  Only works with one item at a time Process is conducted outside of Both functions rely on {{IMSMANG and so not controlled  Requires expert level understanding of SQL  ==Basic Reporting==IMSMANG provides several reporting options that allow users }} searches to produce basic reports directly from IMSMANGfilter data. These include printing field reports entered into the systemUsing iReports, maps from the main navigation window and item current views for summaries of items. Any of these reports information managers can be sent directly build reporting templates to visualise data in a printer or to an intermediate format such as rich text format (.RTF) or portable document format (.PDF) for transmitting in electronic specific and repeatable 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 Using data. Information export, managers can define map layout templates that include scale bars, annotations export search results to an external tool such as Microsoft Excel and legends or use more sophisticated tools like ArcGIS Desktop to prepare more complicated map layouts for displaying IMSMANG data.  Figure 25. Example of a Map Layout Template {{note|* Map layouts can be printed perform aggregation and scaled to any size paper. This is a simple way of producing IMSMANG maps without needing additional GIS softwarestatistical analysis.* Map layout templates can be prepared and distributed to individual IMSMANG clients, allowing information managers to prepare templates based on user preference or functional need}}

|[[HowTo: Print Maps Use iReport | Print Maps]]|[[HowTo: Print Maps and Data | Print Maps and DataUse iReport]]

 ==Embedded Reporting==IMSMANG supplements the basic reporting options available to all users with several more sophisticated reporting tools that are embedded within the system. In addition to reporting on individual elements, these embedded tools allow for statistical and aggregate reporting of data within the database. Instead of reporting the contents of a single report, statistical reporting allows information managers to produce reports about multiple items and to use functions such as sum, average and count to summarize data.  There are two options for embedded reporting: iReports and data export. Both functions rely on IMSMANG searches to filter data. Using iReports, information managers can build reporting templates to visualize data in a specific and repeatable format. Using data export, managers can export search results to an external tool such as Microsoft Excel and perform aggregation and statistical analysis. ===iReports=== 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 summarize 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.

 *clearance: monthly progress reporting MRE*education: number of people trained by type of training hazard*land: sum of hazardous area by province or type of hazardland *accidents: number of accidents by type or by province *data quality: number and list of hazards 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 of hazards and size a list of hazards by province land with associated ordnance details can produce different reports depending on the search parameters.  Figure 26. Report Example Using No Search ParametersIn 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 hazards whose status is active, a different report is generated.   Figure 27. Report Example Using a Search ParameterMoreover, if the hazards are further limited to hazards that are minefields (excluding UXO and battle areas), another report is generated, all using the same template. In this way, information managers can build templates and searches to fulfil 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 similar to Crystal Reports[[Image:AdminGuide_ReportUsingNoSearchParameters.png|center|500px|''Report Example Using No Search Parameters'']]<div align="center">''Report Example Using No Search Parameters''</div>

In the first example, no search parameter is applied and all data in {{HowTo's|[[HowTo: Use i-Report | Use i-Report]]IMSMANG}}===Data Export===is used in the report. But by adding a search parameter, for example, limiting this to land whose status is Worked on, a different report is generated.

IMSMANG also provides data export functionality designed to allow users to export data to external tools such as Microsoft Excel for additional reporting and analysis[[Image:AdminGuide_ReportUsingSearchParameters. This lets users take advantage of functionality in these tools such as sums, counts, charts, pivot tables and other data manipulation functions to format and present data. Users access this functionality by performing png|center|500px|''Report Example Using a Search Parameter'']]<div align="center">''Report Example Using a search in IMSMANG and then exporting the results to .CSV format. Users can choose which columns to export, and the data can be manipulated in any external tool that supports .CSV.Search Parameter''</div>

Because data export is initiated with a searchMoreover, it provides a flexible approach for getting data to an external tool. However, once if the data land is used in further limited to a tool outside of IMSMANGspecific type, it another report is impossible to control how this data is manipulated which may limit generated, using again the consistency of reports produced in this 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 {{note|IMSMANG searches return information on only one item at a time, and data export is limited }} or saved to the data returned by the search. Data from linked items (an intermediate format such as victim data linked to accidents) is not available .RTF, .PDF or .XLS for export}}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.

|[[HowTo: Export data Exporting| Export data]]

==External Reporting Tools=={{IMSMANG }} also allows information managers provides data export functionality designed to connect advanced allow users to export data to external tools such as Microsoft Excel for additional reporting and analysis. This lets users take advantage of functionality in these tools such as Crystal Reports or ArcGIS Desktop directly sums, counts, charts, pivot tables and other data manipulation functions to its relational database for highly advanced report generationformat and present data. With Users access this capability, information managers can use custom reporting solutions functionality by performing a search in {{IMSMANG}} and then exporting the results to connect with IMSMANG, allowing for complete control of IMSMANG outputs. Or, managers CSV format. Users can modify existing reporting solutions choose which columns to connect to IMSMANGexport, which leverages technology already implemented in the programme and limits the need for retrainingdata can be manipulated in any external tool that supports .CSV.

{{note|Using external reporting tools Because data export is initiated with a complex activity requiring search, it provides a flexible approach for getting data to an advanced understanding of SQLexternal tool. However, reporting tools and once the data is used in a tool outside of {{IMSMANG data model}}, it is impossible to control how this data is manipulated which may limit the consistency of reports produced in this way.

===Connecting External Reporting Tools===The process for connecting external reporting tools {{note|{{IMSMANG}} searches return information on only one item at a time, and data export is essentially the same for all tools. External tools connect limited to the IMSMANG relational database via an ODBC connection. Information managers establish this connection data returned by installing the ODBC driver for MySQLsearch. When this Data from linked items (such as victim data linked to accidents) is complete, information managers can connect any ODBC-compliant tool to the IMSMANG database, including reporting tools, other database packages and SQL management toolsnot available for export. Examples include:}}

==External Reporting Tools==__NOEDITSECTION__{{IMSMANG}} also allows information managers to connect advanced reporting tools Database packages and SQL management tools* such as Crystal Reports* or ArcGIS Desktop* iReport* Microsoft Excel * Microsoft Access* OpenOffice Base* Microsoft SQL Server* Oracle* MySQL Query Browser* Navicat* TOAD SQL* Heidi SQLdirectly 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|When connecting an using external reporting tool tools we recommend to IMSMANG, it is recommended that information managers build database views within the database to do any necessary data transformations. While it is possible connect 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 '''[[IMSMA Staging Area | Staging area]]''' instead of the {{IMSMANG }} database using database views and then import . It does require knowledge about the resulting views into the external toolsIMSMA 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 {{note|Building IMSMANG}} relational database views 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 transform data before importing it into other tools significantly reduces the performance hit associated with connecting external tools{{IMSMANG}}database, including reporting tools, other database packages and SQL management tools. Examples include:

{| class="wikitable"! scope="col" | Reporting tools || scope=Building "col" | Database Views==packages || scope="col" | SQL management tools|-| Crystal Reports || Microsoft Access || PGSQL Query Browser|-| ArcGIS Desktop || OpenOffice Base || Navicat|-| iReport || Microsoft SQL Server || TOAD SQL|-| Microsoft Excel || Oracle || Heidi SQL|} Building database views is the primary way of transforming data to support When connecting an external reporting. Information tool to {{IMSMANG}}, it is recommended that information managers can use SQL editing tools to build and save database queries as views that can be used within the database to format do any necessary data for easier reportingtransformations. Using While it is possible to directly import or connect {{IMSMANG}} database views, information managers can join data together into flat tables that allow for easier incorporation into reports or other analysis in external tools. Database views act like database tables and can be imported or queried from perform transformations within the external tools. Moreover, views automatically refresh as data the recommended method is added to do transformations within the {{IMSMANG }} database using database views and provide an up-to-date data source for other applicationsthen import the resulting views into the external tools.

Using {{note|Building database views, information managers can perform statistical and to transform data before importing it into other operations on tools significantly reduces the IMSMANG set for reporting purposes including sum, count and average or more complicated functions available in SQL. These operations can be combined performance hit associated with search criteria to provide a highly precise mechanism for providing data to reports. For example, information managers can create a view that returns the name of each clearance and a sum of the hours worked, AP mines found and area cleared on all progress reports linked to each clearanceconnecting external tools. }}

<center>{| class="wikitable" width="600"|-| align="left" | '''Clearance ID '''| align="left" | '''Area cleared '''| align="left" | '''AP mines found '''| align="left" | '''Hours worked '''| align="left" | '''Number of progress reports'''|-| align="left" | CL-1022 | align="left" | 23,400 | align="left" | 45 | align="left" | 120 | align="left" | 4|-| align="left" | CL-1239 | align="left" | 22,330 | align="left" | 42 | align="left" | 160 | align="left" | 6|-| align="left" | CL-2345 | align="left" | 1,920 | align="left" | 4 | align="left" | 20 | align="left" | 1|}</center>

This view could then be pasted into Excel, linked with additional {{IMSMANG }} data or external data or linked with a map to provide additional analysis. As such, database views provide a powerful way of formatting and analysing {{IMSMANG }} data.

* Database views created in {{IMSMANG }} are backed up by the {{IMSMANG }} backup functionality. However, it is important to correctly set the database permissions on views or it will cause problems when restoring the databases.* Information managers should maintain separate files containing the view creation scripts so that they can be quickly and easily restored or modified. Using the CREATE OR UPDATE REPLACE VIEW syntax from SQL is an easy way to build scripts for creating or updating replacing views if they already exist.}}