Skip to main content

Creating a Custom Report

Alicia Roberton avatar
Written by Alicia Roberton
Updated over a month ago

Creating a Custom Report

To create a new Custom Report click on the "+" icon in the top right corner of your Dashboard and select "Report":

When you do so, an editing drawer will appear where you can rename and edit the settings.

Renaming and Customising Settings

From the editing drawer that appears when you add your new Report, you can rename and add a description of your Report if needed:

Sharing

Using the "Shared With" drop-down you can choose who will have access to your new Report:

"Only Me" - This will keep it as a personal Report that only you can access.

"Organisation Name" - This will allow everyone within your Organisation (who has reporting permissions) to have access to your new Report.

"Federation Name" - If you are part of a Federation this will allow everyone within your Trust (who has reporting permissions) to have access to your new Report.

Please Note: If you share this Report across your Organisation/Federation, anyone with permission to edit Reports can make and save changes to your Report.

Settings

From the Report editing drawer, you will also be able to choose whether to include certain information:

Federation: If you are part of a Trust, selecting this will include your Central Team Profiles in your new Report.

Excel Export: Select, or De-Select these options based on what you would like your exported Excel to show.

When you are happy, click "Create" to build your new Report, and keep reading for customisation options!


Customising your Report

Once you have clicked "Create", your new Custom Report will open.

You will notice that to start with this Report will show everything including all Profile Types, all Sections and all Fields:

AutoSave

You will also notice that on any Custom Reports, the AutoSave function is set to "On" by default.

This means that any changes you make while editing this Report will be automatically saved as you go.

Customising the Sections and Fields

To choose which Sections and Fields you'd like to view on your Report you can use the Filter Bar on the right-hand side to select/deselect your chosen Fields.

In the below example, you can see that only the Staff Training Section has been selected, along with Tags, First and Last names:

Filter by Profile Type, Tag, or Rating

You could also use the filter bar at the top of the Report to choose which Profile Types and Tags you would like to view, and also if you would like to filter by rating system.

Click 'all profile types' to un-tick any that you do not want to be shown in the report as below, and then click 'Apply':

Click the 'Tags' to select or de-select the tags, and then click 'Apply':

If you need to filter by the rating system, click the '+' symbol to filter:


The below example shows a filtered report, showing any Safeguarding Training for Teaching Staff with an 'Active' or 'Onboarding' tag:

Reordering Columns

You can reorder the columns by dragging and dropping the fields from within the Filter Bar:

Reordering Sections

To reorder whole Sections, click on the Section Header on the Report Spreadsheet and drag/drop it to its new location:

Editing Column Widths

You can edit any column widths by hovering over the column border and dragging it out.

Please Note: Any changes made to column widths will currently not be applied to the Exported Excel spreadsheet.

Pinning Columns

You can Pin columns by clicking on the icon at the right of the Column header and clicking "Pin Column". Then select which direction you'd like to pin it. The columns will then remain visible as you scroll through the rest of the report.

Please Note: Any columns pinned will not remain pinned once the Report has been Exported to Excel.

Setting Conditions

As well as selecting which Sections and Fields you would like to show on your Report, you can also set specific Conditions in order to further customise your view.

This is particularly useful if you need a report for any staff that have undertaken a specific training, or if you need to see a list of staff who started on or after a specified date.

To do so, select Conditions from the Filter bar on the right-hand side of your Report:

You can then select your Conditions and they will be applied to your Report.

Example - Staff Birthday List

As an example, if you wanted to create a list of staff birthdays that were upcoming next month, the Conditions would need to be as below:

Your Report will now show a live and always up-to-date list of Staff who fall under this Condition:

Example: Specialist Trained Staff

If you have customised Sign In Central Record to be able to keep track of Staff Training, this feature is also useful to create a live, up-to-date list of staff with different training. An example of this would be DSL-trained staff, and the Conditions needed for this are shown below:

Your Report will now show a live and always up-to-date list of Staff who fall under this Condition:

Exporting the Report

Once you are happy with your Report click "Export" and once the system has finished building your Custom Report you will be able to click "Download" to view it in Excel.

Did this answer your question?