NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{| class="wikitable" width="1000"
|-
| align="center" colspan="76" | '''Comparison of {{IMSMANG}} Reporting Options'''
|-
| width="20pt" |
| width="195pt" | '''iReport'''
| width="195pt" | '''Data export'''
| width="195pt" | '''Other external reporting tool'''
|-
| 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" | 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" |
*Linking or exporting {{IMSMANG}} data for use in external tools
*Easiest way to get {{IMSMANG}} data into Excel
*Can manipulate data in common applications
| align="left" |
*Most powerful and customisable way of accessing data for reports
*Limited customisation of resulting data (formats, conditional display, etc.)
*Not ideal for incorporating multiple reports together within a larger report
| align="left" |
*Requires expert level understanding of SQL
{{note|{{IMSMANG}} searches return information on only one item at a time, and data export is limited to the data returned by the search. Data from linked items (such as victim data linked to accidents) is not available for export.}}
==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.