Group MIS: The Custom Report Writer

Group MIS shows you key statistics and figures for attainment, attendance, behaviour or staffing with just a few clicks (take a look at this article to see more), or to drill down even further into your data you can create a report in the Custom Report Writer! 

Pull in data from all your schools to report on, and sort, filter or group the report based on student demographics to highlight any missing information or see what can be improved at your MAT. Once your report is created, you can easily share them with the right people in a variety of ways. Then agree on a plan with your schools, log in to take action or live feed the data out to Excel or Power BI.


All reports and viewing reports

On school sites

The Custom Report Writer: Superuser permission for Group MIS users gives you access to all custom reports on each of your school’s MIS sites once you log in.

We’ve added this permission to anyone with the Chief Executive Officer, Chief Operating Officer and Executive Head Teacher business roles - to give other business roles the permission, you’ll need to edit the business role.



On the Group MIS

When you go to Analytics > Custom Report Writer, the first page you'll see is the All Reports page. You can search for a report title by clicking in the green search box or add criteria using the filters.

Don't see the report you're looking for? You'll only see any reports that have been created by you or shared with you, so you won't need to spend time finding the report you need.

Top Tip: To see who the report has been shared with or sent to, click the report and select Report History from the left-hand menu. On the All Reports page, shared reports have an arrow beside them and scheduled reports have a calendar icon beside them.



Click the report to access it and complete more actions, such as editing it (if it's your report or the person who shared it with you has given edit access), sharing it, downloading deleting or duplicating it.



Creating a new report

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. There are 3 options.



Create report from template

Use one of our out-of-the-box reports on Attendance By Year Group, Number of Pupil Premium Students by Year Group, Demographics, numbers of Fixed Period Exclusions (referred to as 'suspensions' by the DfE from Autumn 2021), Positive Incidents, Negative Incidents and Staff Absences. Just choose the template and your columns will already be added - just skip any wizards and save and view the report!



Import a report

Follow the steps to import a report made by us or someone else who uses your Group site. We’ve got a whole range of templates you can import into your system here, to save you having to set them up! 

Top Tip: Any custom report made on the school MIS can also be imported into the Group MIS!

To create a template of a report, just click the green button from:

  • Analytics > Custom Report Writer > Select report > Export on the Group MIS
  • School > Custom Report Writer > Select report > Export on the School MIS

You can then email this report externally to anyone who also uses Arbor Group MIS who needs to create the same report. Import the report by selecting the Import a report option, selecting the file then clicking Upload



Create new report

Work through each step to create the custom report. Each step has a Help section which you can expand to provide further guidance for the stage you are at.

Top Tip: Once you are confident with creating reports in Custom Report Writer, click the 'Skip wizard set up' link to go directly to the Edit page to add all your parameters all at once!

Step 1 - Set title and topic

This is where you set the title and subject of your report. Select one and then click Next.


Step 2 - Set effective date

This is where you set the date range for your report. All reports must have a date range for which you wish to report upon your chosen topic. For example, you may only be interested in students who were enrolled last spring, or staff who were at your organisation last year.

You can set an absolute date, where you explicitly define a date or a period of time between two set dates. For example on 08 Mar 2020, or between 25 May 2020 and 02 Jun 2020. Or, you can set a relative date range, such as “last week” or “last term” which will change as time goes on.

Top Tip: If you only want to look at currently enrolled students, select 'today' as your date range to exclude any students who have left.


Step 3 - Choose columns

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 will appear after you have added a column, allowing you to set parameters. These parameters decide at what point in time you would like to analyse data from, or how to present the data.

Top Tip: You won't need to add a column for school name as this will automatically be added to your report when you view it at the end of the setup.



For example, to help you monitor student attendance across your trust and support specific students, we’ve added new columns to the Group MIS Custom Report Writer. Just add the Today’s attendance and Today’s notes columns.


Step 4 - Reorder columns 

This allows you to reorder your columns by clicking and dragging the columns into the correct position.


Step 5 - Sort columns

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


Step 6 - Add filters

Adding a filter allows you to exclude certain people from your report. For example, you may only want to see students who are pupil premium. You do not have to set filters to create a report and this section can be left blank. You then need to save your filter by clicking Set parameters before you click Next.



A slide over will appear after you have added filter, allowing you to set parameters. These parameters decide at what point in time you would like to look at, or how to present the data, such as only showing students who were pupil premium between certain dates.


Step 7 - Group your report

If you want your report not to show individual results but to group them together based on certain criteria you can choose this in this step. For example, you could group by 'institution' to see an average for any statistics for each school.

Now your report is ready to be viewed!




Sharing a report

Go to the report you want to share and click the Share button to add this report to another Group MIS user's All Reports page, or send it to them via email. You can either give a user full edit rights to the report or allow them to simply view the report. Sharing a report with another user gives them access to all the data in the report.



Click the Schedule button to send a copy of your report every week to whomever you choose.


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



Please sign in to leave a comment.