Reporting on Rooms

This guide will explain the possible reports you could create when using our custom report writer to create a report using the report focus of Rooms.

Room Specific Report Fields

• Room name
• Short name
• Site name
• Student capacity
• Invigilation capacity

Permissions

Access to data in the Custom Report Writer is based on a user's permissions. This means you are able to regulate what data they can see in order to safeguard your students and staff. Certain types of data may be restricted for some staff members without the correct permissions. For example, if you are unable to view Rooms in the timetable module, you won't be able to see them on the Custom Report Writer. 

You can view the permissions needed to report on each thing in Arbor by going to School > Users & Security > Access Control > Permissions. 

If you need to give someone permission to create reports or report on certain items, you can follow these instructions.

Top Tip: You may find it easier to click 'Skip setup wizard' after choosing your report focus and title to head straight to the main Edit screen. 

Adding a Filter

If you would like to filter your report to look for specific rooms you can do so by scrolling down to the Filters section.

From the drop-down, select the filter that you are interested in. For example, if you would like your report to only show rooms with a certain capacity, you could choose the Student capacity filter.

Select Student capacity from the drop-down, and then click the green Add filter button on the right-hand side.

Then you can set your filter parameters. For example, identify what you need the capacity to be. Then click Save.

Adding a Grouping

If you would like to sort the data into groups, you can do this by adding a grouping to the report. 

Please be aware that when adding a grouping you may loose some of the contextual information and end up with just the number of items. 

For example, if you add a grouping of site name to the report, you will see how many rooms there are for each site (if your school is split across multiple sites), but you would no longer see the detail of the rooms like student or invigilation capacity etc. 

You can see which data will no longer be displayed in the Report Columns section as it adds (Hidden - does not support groupings) after the column name.

To add a grouping, scroll down to Groupings. From the drop-down, select the grouping that you are interested in, for example, Site name. Then click on the green Add grouping button.

Set the parameters if required and then click Save.

Adding a Collation

There are no possible collations when making a report about Rooms.

All Available Report Fields for Room Reports

To see a matrix of all available report fields and which report types they can be used with, please take a look at this article: What report fields can I use with each report type in the custom report writer?

• Room name
• Short name
• Site name
• Student capacity
• Invigilation capacity