Creating bespoke reports in the Custom Report Writer

The Custom Report Writer enables you to create bespoke reports to show in a table grid, which you can then share or export.

What are the different ways to create reports?

There are 3 options to choose from when creating a report.

  • Create a new report: See steps 1 - 8 outlined below.
  • Create a new report from a template: Select the template you would like to use. You are then automatically taken to Step 2 of the report creation process with all the fields pre-populated with the info you require.
  • Import a custom report: Follow the steps to import a report you already have. You can import reports that another school have shared with you using these instructions, or check out our common Custom Report Writer reports you can download from the Help Centre.


Creating a report from scratch

Go School > Custom Report Writer


From the All Reports page you can create a new report by clicking on the green 'Create New Report' button in the top right-hand corner of the page.

Clicking on this button will take you to the beginning of the Report Creation steps. Select to Create a new report. 



After clicking on the green 'Create new report' button you will be taken to the first step of the setup report creation process. You can identify which stage you are at by looking at the top of the page you are on. Each step also has a Help section which you can expand to provide further guidance for the stage you are at. 

Step 1 - Set Title and Topic

This is where you set the title and subject of your report. After naming the report you can see the choices for what or who this report is about. Select one and then click on next.


Step 2 - Set Effective Date

Select your date range. This will determine which students will be pulled into your report. You can select a 'dynamic' date range which will change automatically (such as 'yesterday'), or custom date ranges with specific dates.

In this example, I’m going to generate a report of the last term so only want to look at students on roll last term, but you can set it to report on the last year, term, week or day.


Step 3 - Select Columns

This stage of the wizard allows you to select the columns you want in your report.

On the left-hand of the screen, you can search for column titles in the search box or scroll through the list and select the columns you need. Drag and drop these into the right-hand side.



A slide over may appear after you have added a column, allowing you to set parameters for the column. Dates can be set dates or on a rolling basis if you are creating a report you would like to schedule on a weekly basis. In the example below, each week the report will display the relevant data from the previous week.

You can also choose what to display in the summary row. Average and Sum is available for columns involving numerical values, such as attendance and Row Count can be used for all columns.



If you add a column and then decide you no longer want that in your report, the right-hand side of the screen has a small bin icon beside each column you add. Clicking on this will remove the column from your report.

You can edit the column further by clicking the pencil icon.

You can also reorder the columns you have placed in the right-hand area of the screen by dragging and dropping them into the order you wish.



Top Tip: For reports about Students, you'll also see a Bulk Add Assessment Columns button at the bottom of the page. Use this to add assessment columns in bulk - just select the year, assessments and periods, and for Summatives choose which marks or targets to show.



Step 4 - Reorder Columns

This allows you to reorder your columns should you decide to make any changes. Just click and drag the columns into the correct position.


Step 5 - Sort Columns

This is an optional step that allows you to sort your columns alphabetically or chronologically.


Step 6 - Add Filters 

You may want to filter the data for your report, for example, you only want to see students in year 8. Using a filter will reduce the number of records seen in your report to only those matching your set criteria. This guide will give you some handy hints when using filters in a student-based custom report: Using AND and OR filters in the Custom Report Writer

You can use further filter options for ‘Not Yes’ and ‘Not No’. For example, if you want to look at students who have a brother, you can now filter by ‘Not Yes’. Your results will then include students for whom it is not recorded whether they have a brother or not.

You do not have to set filters to create a report and this section can be left blank.

To add a filter, type the filter into the box then click Set parameters.



This will allow you to set the date range and parameters of your filter. For example, you only want your report to show students who were in certain year groups.


Step 7 - Add Groupings

You can add Groupings if required. If you want to group your results into categories or clusters eg. sex, EAL, FSM, Year Groups this is where you can add these groups. 

To add a grouping, type the group into the box then click Add Grouping.



This will allow you to set the date range and parameters of your grouping.


Step 8 - Add Collations

Collating a report allows you to collect results into different sections. This means when you download the report, you can choose how rows are grouped together.

To add a collation, type the collation into the box then click Add Collation.



This will allow you to set the date range and parameters of your collation.




Now your report is ready to be viewed!

Once you are confident with creating reports in Custom Report Writer you can skip the Wizard using the 'Skip wizard set up' link which will take you directly to the Edit page to create a report, with all the steps on one page.


Was this article helpful?
3 out of 14 found this helpful
I'm still stuck!



Article is closed for comments.