Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Ad Hoc Reports module allows users to create custom reports and get specific person record data. It has a number of features to help users create and interact with data. The following information helps users understand what options are available and what each does.

Overview

Open or Create

When the Ad Hoc Reports screen is loaded users have the option to either run an existing report or create a new one.

Panel
Image RemovedImage Added

Create/Edit Window

When a report is being created or edited a window is opened where users can customize their report. There are three (3) sections to the modal; Title & Description, Column Configuration and Filter Builder. Users can switch between each section by clicking the headings.

Title & Description

Panel

Allows users to add a title and description to their report for future reference. Both fields are displayed in the "Select a Report" menu.


Column Configuration

Panel

This is where users define the data to be listed in the report. The first step is to select the desired columns and then customize via the available options.

  • Click the "Select Columns" button to search for and select the columns that make up the report.


Section
Image Removed

Image Added


  • There are several options for columns once they have been selected:


Section
Image Removed
Image Added


Filter Builder

Panel

Here the users can define the parameters of the desired report. Users will use rules and groups to select columns and then define what filters the report should match. 

Info
  • "Add Rule" will add a new filter to the report.
    • No limit to the number of rules that can be used.
    • The more rules added the better the results will be.
  • "Add Group" will add a new sub set of rules.
    • These can allow users to return multiple sets of data; for example:
      • search two commands at a time.
      • return results with person type "Officers" and "Auxiliary Captains".
  • "And"/"Or" designations -
    • "And" (default setting) means the data results must match ALL of the listed rules.
    • "Or" means the data results only have to match ONE of the listed rules.
Image Removed


Image Added


Report Result Options

When a report loads there are a number of features available for users to manage their report. 

Panel

The column headings can be selected to sort data by that column. Users can use the "quick" filter and column editor to easily make changes to their results!

Section

The report menu allows users to refresh the results, edit the report or export the report data to save it for external use.

Section
Image Removed

Image Added

The new and copy functions allow users quick access to creating a new report!

Section

Image RemovedImage Added




Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@132e0
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "custom-reports" , "reports" , "ad-hoc" ) and type = "page" and space = "OSD"
labelsad-hoc reports custom-reports


Page Properties
hiddentrue


Related issues