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

Ad-Hoc Reporting: Summary Rows 


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 Summary Reports: Grouping

      Purpose This article demonstrates uses cases and provides an overview of grouping options available within a Summary Ad-Hoc report. Summary Reports Grouping is in beta phase. The First Due Team will be making quick and frequent updates to this ...
    • Ad-Hoc Reporting: Report Schedule

      Purpose This article will review the Ad-Hoc Report Schedule Information within the Reports module. Information The Report Scheduling section in the ad-hoc reporting module allows users to automate the generation and distribution of reports at regular ...
    • 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: Filters

      Purpose This article will review the Ad-Hoc Filters within the Reports module. Information The Filters section in the ad-hoc reporting module allows users to refine the data included in their reports by applying specific conditions. Filters are ...
    • Ad-Hoc Reporting: Grouping

      Purpose This article will review the Ad-Hoc Grouping within the Reports module. Information The Grouping section in the ad-hoc reporting module allows users to organize their report data by specific fields, making it easier to analyze and interpret ...