...
- Open Ad Hoc Reports.
Click the "New" button.
Section screenshot
- Name your report.
Optionally, add a description (this helps to show the purpose of the report).
Section screenshot
- Click "Column Configuration".
Click the "Select Columns" button.
Section screenshot
Search for the data fields you want to see displayed on the report.
Section screenshot
Once all data fields are added click "Select".
Section screenshot
- Verify the order of the columns.
Optionally, change the column name or set the sort order.
Section screenshot
- Click "Filter Builder".
Click "Add Rule" to add a filter.
Section screenshot
Search for the data you want to use to filter report results.
Section screenshot
After selecting a filter choose an operator and value.
Section 
Info If no filter is selected then every person record in OMS would be listed on the report. The goal of the filter builder is to add as many filters as necessary to limit results to match the desired criteria.
If a user wanted all officers currently serving in THQ, commissioned before 2000 then the filters would be:
- Person Type (Column) equals (operator) "Officer" (value).
- Is Current Appointment (Column) "is true" (operator) .
- Command Name (Column) equals (operator) "Territorial Headquarters" (value).
- Commission Date (Column) is less than (operator) "1/1/2000" (value).
Once all filters are selected click "Create".
Section screenshot
The report will load and display the results onscreen.
Section screenshot
Users can export the results or edit the report for different results.
Section screenshot
| Info |
|---|
| Keep in mind that access to ad hoc reports is a specific user permission. Without it a user cannot see the "Ad Hoc Report" menu link. |
...