Manage Core Reports

Some reports are included by default in StaffMap, and available for viewing by users and administrators. If default field names are changed, these reports may need to be modified. The reports can also be removed entirely, and new reports can be added.

The reports can be modified in two different folders in a default installation. Directories within those folders will function as different headings in the report selecting pane.

Admin Reports: C:\Program Files (x86)\Staffmap 4\_engine\Admin Reports

User Reports: C:\Program Files (x86)\Staffmap 4\_engine\User Reports

The reports are .rpt files that can be opened in text editors such as Notepad and Notepad++. Report files follow a standard format with an SQL query on the first line of the file, with no line breaks, followed by styling (if necessary).

SELECT _Desks.deskname, _Floors.FloorName FROM   _Employees RIGHT OUTER JOIN _Desks ON _Employees.Desk_id = _Desks.desk_id LEFT OUTER JOIN _Floors ON _Desks.floor_id = _Floors.floor_id WHERE (_Employees.Id IS NULL) ORDER BY _Desks.deskname
/* Column widths */
.col1 { width: auto }
.col2 { width: auto }
.col3 { width: auto }