Ad-Hoc Reporting: Report Type

Ad-Hoc Reporting: Report Type

Purpose

  1. This article will review selecting your Ad-Hoc Report Type within the Reports module. 
  2. The options available in each tab will vary based on if you choose Tabular Report or Summary Report. 

Related Articles



Video




Instructions



1. After completing the Data Source Configuration selections, click next to go to the Report Type tab.


After completing the Data Source Configuration selections, click next to go to the Report Type tab.



2. Select Tabular Report for a report that is grouped in columns and rows and displays all of your data in an organized format for review. (See below for more information on report type differences.)


Select Tabular Report for a report that is grouped in columns and rows and displays all of your data in an organized format for review. (See below for more information on report type differences.)



3. Select Summary Report for a broad look at your data like totals, averages, percentages, and counts. Charts and graphs can be made from Summary Reports.


Select Summary Report for a broad look at your data like totals, averages, percentages, and counts. Charts and graphs can be made from Summary Reports.



4. Click on Next to move to the next tab for creating a report.

  1. For a Tabular report you will go to Columns next. (See Ad-Hoc Reporting: Columns)
  2. Summary Reports do not have Columns, and you can go to the Sort tab next. (See Ad-Hoc Reporting: Sort)


Click on Next to move to the next tab for creating a report.





Understanding Report Types

  1. Tabular Reports:
    1. A tabular report returns all the rows in a dataset after the data and joins have been processed.
    2. Users can filter, sort, add criteria, and group the data in various ways.
    3. The focus is on displaying all individual rows contained within the dataset.
    4. Tabular Reports now have the ability to add in a Summary Row aggregating the columns inside of the report.
  1. Summary Reports:
    1. A summary report aggregates data based on one or more columns.
    2. Instead of displaying individual rows, it summarizes the data, offering an abstraction.
    3. For example, the report might group data by fire station and provide a count of incident reports for each station, without showing the underlying rows.


Key Differences





Tabular Report Example of data display: 




Summary Report Example of data display:




    • Related Articles

    • Ad-Hoc Reporting: Summary Grouping

      Purpose To demonstrate the different ways that you can group data into a Summary Report in Ad-Hoc Reports. Summary Reports are a broad look at totals, averages, trends, or percentages in your agency's data. This data can then be used to create custom ...
    • Ad-Hoc Reporting: Report Schedule

      Purpose To demonstrate how to run and send out a report on a set schedule in Ad-Hoc Reports. Related Articles Report List Features Ad-Hoc Reporting: Tabular Grouping Ad-Hoc Reporting: Summary Grouping Ad-Hoc Reporting: Filters Video Instructions 1. ...
    • Inspection Record - Ad Hoc Violations

      Purpose To demonstrate how to add Ad Hoc Violations to an Inspection Checklist. An Ad-Hoc Violation is a feature to add a violation to the Checklist that is not contained within the current Checklist. Video Instructions Note: Ad-Hoc Violations must ...
    • Ad-Hoc Reporting: Columns

      Purpose To demonstrate how to create the Columns to display the chosen fields from your Data Source in an Ad-Hoc Report. Columns are created to show the pertinent data fields from the records in your Tabular Report. Related Articles Report List ...
    • Ad-Hoc Reporting: Sort

      Purpose This article will review the Ad-Hoc Sorting Section within the Reports module. Related Articles Report List Features Ad-Hoc Reporting: Columns Ad-Hoc Reporting: Criteria Video Instructions 1. You are navigating to Sort from Ad-Hoc Reporting: ...