Ad-Hoc Reporting: Sort

Ad-Hoc Reporting: Sort

Purpose

This article will review the Ad-Hoc Sorting Section within the Reports module.


Related Articles


Video





Instructions


1. You are navigating to Sort from Ad-Hoc Reporting: Columns. Click the Next button at the bottom or Click the Tab for Sort to move on.




2. Select the box next to the columns you want to focus on for sorting. Click the plus icon to move them over to the Sort section. You can choose one or more columns. The Sort will utilize the columns in the order they appear.


Select the box next to the columns you want to focus on for sorting. Click the plus icon to move them over to the Sort section. You can choose one or more columns. The Sort will utilize the columns in the order they appear.


3. Grab and drag the hamburger icon to change the order of the columns.


Grab and drag the hamburger icon to change the order of the columns.


4. Click the Ascending/Descending Icon to select which option you want to use. The icon will change direction to reflect your choice.

Info
Ascending Order: Arranges data from smallest to largest (e.g., earliest to latest date, alphabetical order A–Z, or lowest to highest number).
Descending Order: Arranges data from largest to smallest (e.g., latest to earliest date, reverse alphabetical order Z–A, or highest to lowest number).



5. Once you have set your Sort options, you can navigate to the Criteria Tab. (Ad-Hoc Reporting: Criteria)


Once you have set your Sort options, you can navigate to the Criteria Tab.



Example Use Cases for Sorting


Incident Reports: Sort by date in descending order to show the most recent incidents first.

Personnel Records: Sort by personnel name in ascending alphabetical order for easier navigation.

Response Times: Sort by response time in descending order to highlight incidents with the longest response times.

Summary Report: Sort by the total number of incidents per type to prioritize the most frequent incident types

 














    • 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: 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: Criteria

      Purpose This article will review how to use the Criteria filtering options when creating an Ad-Hoc Report in the Reports Module. Choosing Criteria for your report allows you to focus on the relevant data in a specific section of your system. Related ...
    • Ad-Hoc Reporting: Report Type

      Purpose This article will review selecting your Ad-Hoc Report Type within the Reports module. The options available in each tab will vary based on if you choose Tabular Report or Summary Report. Related Articles Reports List Features Ad-Hoc ...
    • 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 ...