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. 

Screenshot_2020-12-15_at_13.44.05.png

 

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.

Screenshot_2020-12-15_at_13.50.07.png

Step 2 - Set Effective Date

Select your date range. This will determine which users (students with an active enrolment or current staff) will be pulled into your report. You can select either:

  • Relative dates - a 'dynamic' rolling date range which will change automatically. For example, 'last week' will change the date range each week to look at the previous week.
  • Custom dates - custom date ranges with specific dates - these won't update automatically and would need to be adjusted.

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.

Screenshot_2020-12-15_at_13.51.19.png

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.

Screenshot_2020-12-15_at_13.54.26.png

 

A slide over may appear after you have added a column, allowing you to set parameters for the column. 

For dates, you can select either:

  • Relative dates - a 'dynamic' rolling date range which will change automatically. For example, 'last week' will change the date range each week to look at the previous week.
  • Custom dates - custom date ranges with specific dates - these won't update automatically and would need to be adjusted.

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.

Screen_Shot_2019-03-04_at_16.51.27.png

 

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.

Edit the column further by clicking the pencil icon.

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

Screenshot_2020-12-15_at_13.56.26.png

 

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.

Screenshot_2023-02-22_at_14.27.28.png

 

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.

order_colums.png

Step 5 - Sort Columns

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

sort_columns.png

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.

Screenshot_2020-12-15_at_14.04.43.png

 

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.

filter.png

Step 7 - Add Groupings

You can add Groupings if required. If you want to group your results into categories or clusters, for example 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.

Screenshot_2020-12-15_at_14.07.53.png

 

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

example_grouping.png

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.

Screenshot_2020-12-15_at_14.13.53.png

 

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

Screenshot_2020-12-15_at_14.14.54.png

 

 

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.

kip_setup_wizard.png

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

Comments

2 comments

Article is closed for comments.