How to Edit a Report in StaffMap:
- Open the Sidebar Menu and select the report you would like to edit.
- Select the Edit button from the top toolbar.
- In the resulting Report Properties panel, edit the Name, Icon, SQL or Styles.
- Select the Save button to confirm your changes.
The SQL field will accept any standard SQL queries, including sorting and joins. Use the following notation to select database elements:
For example, the following query will display employees who have been assigned to desks.
[_Employees].[LastName], [_Employees].[FirstName], [_Desks].[deskname], [_Floors].[FloorName]
You can learn more about SQL queries at w3schools.com.
The Styles field can be used to apply standard CSS to elements of the report. Table columns are named incrementally, e.g: