Contents
Report administration covers the configuration surfaces for managing report definitions, categories, and group access. This page is for administrators. For running, filtering, and exporting reports as a standard user, see the Reports section.
Report administration spans four surfaces:
| Surface | Access | Purpose |
|---|---|---|
| Report Definitions list | Standard admin | View all 271 report records |
| Report Configuration (edit) | Requires permission 165 | Edit individual report definitions |
| Report Types | Standard admin | Manage report categories |
| Report Permissions | Standard admin | Control per-group report access |
The Report Definitions list shows every report in the system.
| Column | Description |
|---|---|
| Edit | Opens the report configuration form |
| Record | Report ID |
| Name | Report name |
| Custom | Yes/No - user-created report flag |
| Active | Yes/No - whether the report appears in the Reports menu |
Use the Add button to create a new report record. Use the search bar to find a report by name or ID.
Access restriction: Opening the report edit form requires the Reports & Labels - Reports permission (Security ID 165) in Group Permissions. Without it, clicking the edit icon returns an access-denied message even for administrators.
When accessible, the edit form covers the core report fields:
| Field | Description |
|---|---|
| Report Type | Category - links to a Report Types entry |
| Name | Display name shown in the Reports menu |
| Use This Report | Active flag; controls visibility in the Reports menu |
| Is Custom | Marks the report as user-created to protect it from system updates |
| Report SQL | The SELECT query that generates report data |
| Columns | Comma-separated column width values |
| URL Links | Clickable link definitions per column |
| Order By | Default sort order |
Important: System reports can be overwritten during updates. Always check Is Custom before editing a built-in report, and consider copying the report first rather than modifying it directly.
Report Types are the categories that organize reports in the Reports menu.
List columns: Record, Name, List Top, Active.
Common report categories include Appointments, Assets, Customer, Cycle Count, Inventory, Issuing, Jobs, Leasing, Purchase Orders, Receiving & Transfers, Repair Orders, Shipping Orders, Supplier, System, Warehouse, and Work Orders. Categories marked inactive do not appear in the Reports menu.
To create a new category, click Add and enter a Name. New categories must have Active checked to appear in the Reports menu.
Report Permissions control which reports each group can run or edit, independently of the general Group Permissions security matrix.
System → Report Permissions
| Column | Description |
|---|---|
| View | Group can run and see this report |
| Edit | Group can edit this report’s definition |
| Name | Report name |
On this page