Navigate to 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. There are 3 options to choose from.
- 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.
- Create a new report: See steps 1 - 8 outlined below.
- Import a custom report: Follow the steps to import a report you already have.
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.
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.
This is where you set the date range for your report. Please note all reports must have a date range.
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. For example, if you have chosen the date of birth you may only want to see children born between certain dates.
The pencil icon also allows you to edit parameters after you have created your report.
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 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.
Before moving onto Step 4 you can preview the columns by clicking on the green 'Preview columns and continue'.
This allows you to reorder your columns should you decide to make any changes.
This is an optional step that allows you to sort your columns alphabetically or chronologically should you wish.
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. You do not have to set filters to create a report and this section can be left blank.
We’ve now added more filter options in the custom report writer, allowing you to filter 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 can add Groupings if required. If you want to group your results into categories or clusters eg gender, EAL, FSM, Year Groups this is where you can add these groups.
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.
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.