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. Click the Trash Can icon if you need to remove a column from the Sorting options.






6. 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: Columns

      Purpose Statement The Columns configuration allows users to select and customize which data fields from their chosen Data Source will be displayed in a Tabular Ad-Hoc Report. This feature enables users to create focused, relevant reports by choosing ...

    • Ad-Hoc Reporting: Criteria

      Purpose Statement This feature allows users to apply criteria filtering when creating Ad-Hoc Reports in the Reports Module. Criteria filtering enables you to focus on relevant data by filtering records based on specific field values, date ranges, and ...

    • Ad-Hoc Reporting: Tabular Grouping

      Purpose Statement This feature allows users to organize and structure data in Tabular Reports by creating grouped sections based on specific column values. Tabular grouping transforms flat data tables into hierarchical, organized reports where ...

    • Ad-Hoc Reporting: Filters

      Purpose Statement Filters allow you to temporarily modify the data displayed in your Ad-Hoc Reports without permanently adjusting your report criteria. This feature enables dynamic data exploration and customized views of your report information, ...

    • Ad-Hoc Reporting: Settings

      Purpose This article will explain some of the Settings that you can adjust for an Ad-Hoc Report in the Reports Module. Related Articles Report List Features Ad-Hoc Reporting: Filters Video Instructions 1. We got here by Reports Module > Ad-Hoc ...