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 (271 records).
URL: Framework/List.asp?LT=qryReports<2=zwReports
| 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 edit form (
ReportsSetup.asp) requires the “Reports & Labels - Reports” permission (security ID 165). Without it, clicking the edit icon returns an access-denied message even for users in the ADMIN group. Grant permission 165 via Group Permissions before attempting to edit report definitions.
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. There are 27 types in total.
URL: Framework/List.asp?LT=qryReportTypes<2=zwReportTypes
List columns: Record, Name, List Top, Active.
| ID | Name |
|---|---|
| 13 | Appointments |
| 5 | Assets |
| 6 | Customer |
| 22 | Cycle Count |
| 20 | Definitions |
| 2 | Inventory |
| 15 | Issuing |
| 21 | Jobs |
| 18 | Leasing |
| 1 | Purchase Orders |
| 16 | Receiving & Transfers |
| 9 | Repair Orders |
| 3 | Shipping Orders |
| 19 | Supplier |
| 14 | System |
| 12 | Warehouse |
| 4 | Work Orders |
| −4 | Popular |
| −5 | Recent |
Categories with Active = No (Barcodes, Labels, Moving Stock, Other, Spare, Temporary, System −1) are hidden from the Reports menu. Negative-ID entries (Popular −4, Recent −5, Spare −3, Temporary −2, System −1) are system-reserved pseudo-categories.
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 URL: Framework/ReportPermissions
| Column | Description |
|---|---|
| ID | Report ID |
| View | Group can run and see this report |
| Edit | Group can edit this report’s definition |
| Name | Report name |
On this page