Using CommandReporter with SIMS .net

Introduction to CommandReporter with SIMS .net SIMS .net offers powerful reporting features within the GUI, but sometimes you require scheduled report runs to export SIMS data. This is where CommandReporter can be of assistance. CommandReporter.exe serves as a command-line tool accessible through the command prompt, batch files, or as part of a scheduled task. To…

Completing the daily DfE Educational Settings form

To support schools in completing the daily DfE Educational Settings form we have put together a SIMS report that brings together the key student data in a simple to read table. Running this report should reduce the time required to complete the Educational Settings form.   Please follow the instructions in the setting up guide…

How to amend Work Email address to Home Email on Data Collection Sheet

The standard Data Collection Sheet only displays the Work Email address of a contact. This can be amended in several ways, the most stress-free approach is to update the field in the report so that the main email address takes the place of the work email address. This can be done as shown below. 1….

Covid-19 Attendance Report – what you need to check

Update 18/06/2020 The report definition was updated today. To ensure the customer is using the latest version, check that the report output contains the information below. Original post below: What is it? This report is designed to help schools complete the daily DfE return on attendance.  It focuses on the student/pupil section of the form….

DFE FSM Ever 6 Report for 2021/22

To download the report file, click here : FSM EVER 6 – Secondary FSM EVER 6 – Primary Please note that these reports can only be an approximation of FSM Ever6 as used by the DfE for allocating Deprivation Pupil Premium. For example, the DfE knows the YTI reported for pupils in School Census when…

Report to generate classes and teachers

To generate this report, please go to: -Reports > Design Report > Create a new report -Select “Student” and then “on roll” -On the select data fields screen, select “Classes” (blue sub report), then select Class Name, Class Teacher, Students (blue sub report) First Name, surname.  Your previewed report will look like this:   Reviewed…

Where can I find the SPS Safety Reports?

Capita have recently released a new suite of reports called the SPS Safety Reports. The SPS Safety Reports are a suite of reports which simply imports into SIMS and will allow detailed analysis on any key group, subject, class and individual for attendance, behaviour, achievements, staff absence and homework. For both primary and secondary schools….

How to run a career attendance report for leavers

This report will run for any students but the effective date must be one when they were on roll at the school. Reports>Attendance (or Lesson Monitor)>Whole Group Pupil (student) Reports>Pupil’s (student’s)School Career Attendance Report Change the Date if necessary, choose the required Group Type and click Search Highlight required pupils and click Print   kb22716

Individual Session Summary Report – Print more than one student on one page

The Individual Session Summary Report (Reports/Attendance/Individual Pupil Reports/Individual Session Summary Report) will only display one student’s attendance details per page.  Unfortunately it is not possible to change this. As a workaround, please follow the instructions below: Open File Manager Choose a destination (Eg: F:/Public/Updates) Right click on the white background and select New/Microsoft Word Document. …

Identifying addresses modified by CTF import bug

The report can be downloaded by clicking below, please save as to a suitable location, and extract the file so that it shows in your File Explorer as Address change history.rptdef, ready for import into SIMS. Address change history report.zip download For instructions on how to import a report into SIMS, please see the in-depth…

Migration Report for Arrivals duplicating entries

This is due to incomplete, duplicated or multiple entry information in the ‘School History’ section of the student record. If incomplete or duplicated then correct the data and run the report again. If genuinely multiple schools then the report will show a line for each, if this is not what is required then edit the report…

Report for Behaviour/Achievement points over a date range

Current functionality in SIMS makes this almost near impossible or extremely complex to make, so that you can run a report for behaviour/achievement conduct points over a date range. You can download the report definition file below and import into SIMS (Reports > Import), which has made this possible:   Conduct Net points over date…

Homepage Quick Search shortcut reporting criteria/tokens

The quick search on the SIMS homepage can be used as a quick reporting tool to help you find information. You can view details of search tokens available in Quick Search by entering the search string ‘help’ – use the scroll bar to view the entire list. Search tokens, starting with #, are used to…

Sending In-Touch messages to applicants – ‘The following recipients do not have any selected communication method’

When sending messages to applicants through In-Touch, you may receive the error ‘The following recipients do not have any selected communication method’. The reason this is not picking up any of the applicants contact details is because its trying to pick up the applicants contact details themselves. Please change the category to ‘InTouch Contacts of…

RTF report not saving changes

When amending an RTF formatted report within SIMS, you may find that the changes you have made haven’t saved. This is due to an RTF report needing to be saved in a different way. Under the ‘Add-ins‘ tab within the toolbar at the top of the page within Microsoft Word, there is an option for…

Creating a Medical Report

This FAQ is to assist in creating a report containing Medical Information of students in SIMS. There are several pre-designed reports on this subject, which can be found via Reports > Run Report > Open Existing Report, then under: Focus > Student. If these reports do not contain the information you require, you will be…

Importing a report into SIMS (RptDef)

The following FAQ demonstrates how to import a Report Definition File (.RptDef) into SIMS.net. If the file is ‘zipped’, download the zip file to a location of your choice or copy the folder and put it somewhere you can find, i.e. your Desktop. Right click on the zip folder and choose ‘Extract all‘ and choose…

Changing The Font In An Individual Report Which Is Using PoS Information

When you pull through information from Programme of Study (PoS) you are not able to change the font to match the rest of the report just by selecting the information and then selecting the font or colour you would prefer. The steps to change the formatting in these columns is :- Change the style of…

Attendance reports for Vulnerable children – Pupil Premium, SEN, FSM or EAL.

The following Attendance/Lesson monitor reports can be run/created in order to show vulnerable groups of children and their attendance figures. This can include Pupil Premium, Special Educational Needs, Free School Meals, Ever6, English Additional Language and others. In order to get a ‘Whole group figure’ for these groups, go to: Reports > Attendance/Lesson Monitor >…

Exporting a SIMS report as a CSV (comma separated) file

There are two ways to create a CSV file from a report, this is usually to import or send the file where it is imported into third party software. After creating the report, on the ‘Default output’ screen at the end of the report, select the Text option under Presentation, in the Format box selected…

Report for students who live with both parents/only live with one parent

A report to show students who live with both parents or either parent is becoming a common request due to a freedom of information request going around. There is no simple way to produce this report however there is a rptdef (Report Definition File) that can be imported into SIMS under Reports > Import and…

Pupil missing from label list

School is running a class list in reports but one pupil is missing – the output is mail merge to labels. If this pupil should be the first on the second (or subsequent) pages then check the word template. Remove <<Next Record>> from the last label on the page – save The same issue may…

Individual Reports not showing assessment marksheet colours

Is the ‘Print Report with Colour’ option ticked? Was the colour added retrospectively to the marksheet? Is the column marked read only or its associated result set locked? If so the marksheet will show the colour but it is not saved for reports. KB19315  

Academic year missing in SLG

In order to publish reports in SLG the required year needs to be present To add an academic year go to Tools>Lookups>Maintain Search for SLG Document Category and add a New Academic year in section 2 Values Click Save It will not be visible in SLG until everyone has logged out of Sims .net so…

Deleting SIMS Reports created by another user.

As you know, when a user creates a report within SIMS, only that user can amend or delete the report. Other users can use this as a base for their own report but the original report remains in effect. Therefore when a person leaves or changes role, their reports were orphaned within SIMS in previous…

How to add date range to SEN report

In the fields section expand the +SEN option then choose the Special Needs sub report – this is at the bottom and not the same as the SEN Needs at the top. Once this is active the Start date and/or End dates may be chosen and used in the filter definitions.   Reviewed – 19/03/2018

Report to show new students or leavers.

You may need to know any joiners and leavers over a date range. There is a report built into SIMS which can show you this. Go to Reports>Run Reports>Click the + to expand Focus and select Student, Select and run either Migration Report for Arrivals or Leavers and enter the date range you need. This…

‘Error: Could not open macro storage.’ when running a SIMS report

‘Error: Could not open macro storage.’ when running a report via Reports > Run Report.     The cause of this problem was a Microsoft Word File Block Setting. To resolve this you will need to open Microsoft Word and click on File -> Options. On this screen select Trust Centre -> File Block Settings….

Unable to format dates in Excel reports

To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…