Exporting Attendance or Lesson Monitor reports to Excel

The inbuilt Attendance and Lesson Monitor reports are designed to output to a web browser such as Internet Explorer. It is possible to export the data from the web browser to Microsoft Excel. After running your report it will open a new window and you will see your information. If you right click on the…

Running reports for a User Defined Group

Before starting the report, make sure you make a note of the Short Name of your User Defined Group as this will be required. After selecting the data fields that you require for your report press Next, this will take you to the Define Filter screen. Click on New, a screen will pop up which…

Report output exceeds maximum width

Error: This exceeds the maximum width when running a report in SIMS.     This is because the report is running as a Word List Report. It would need to be changed to a Form Report (RTF)  output on the Define Presentations screen. Ensure that Form Report (RTF) is selected. Sometimes it will show as…

Generating a list of provisioned users for SIMS Learning Gateway

To create a simple report to generate a list of Usernames and passwords for SIMS Learning Gateway: Reports | Design Report | Create a new report Click on Contact, click next Click on the + Contact Information, select Addressee, AddressBlock of the home address [AddressBlock], Salutation Double click on the Students subreport, click on +…

How do I export Sims.net Reports

  You will need to be a member of any of the following User Groups in System Manager to run this function: Administration Assistant, Assessment Coordinator, Assessment Operator, Class Teacher, Pastoral Manager, School Administrator, System Manager. Previously defined report definitions can be exported for use by other departments, schools, establishments or agencies as required. When…

How Do I Create a Report to Show Student Photos in a Grid View?

In SIMS .net go to: Reports Design Report Create a new report Student – Next On roll – Next Select the fields required e.g Forename & Surname, Photo, Reg Group – Next Add required filters e.g. New – Year Group is one of – Tick Prompt at runtime – OK, And – Reg group is…

Creating New Mail Merge Templates for Printing Labels

          Create your report as normal, including any fields that you want to include and any filters that are necessary.           Go through the report wizard until you get to ‘Report Output’ and select Word Mailmerge. Click ‘New’ to create a new template.          …

Staff Data Collection Sheet Report

This report uses all of the non-confidential School Workforce Census fields within SIMS and should be sent out to all staff in September of each year, in order to get all your data accurate and updated in time for the SWC in November. You can download this report by clicking here. 1.  Save the Scomis Staff…

How to format dates in Excel reports.

When report is run the date of birth will show i.e 21st January 2001 would like the format to be 21/01/01. To format the date in the report as required after export to excel, please follow the below mentioned steps: 1. Select the ‘DOB’ column in the Excel report output. 2. Go to Menu Data…

The edit options are greyed out on my report

When saving reports from Sims .net the edit options such as Data sort are greyed out – this is in Excel 2010. If the header bar, besides giving the file name, also says Group:- 1. Right click on the ‘Sheet 1’ tab at the bottom 2. Choose Ungroup KB6568     Reviewed 29/04/2015

How Can I Create A Quick Registration Group List

There is more than one method to view and print a Registration Group list quickly, this is one options   1)      In SIMS.net go to Reports>Student List>General Student List, this will give you a list of all Students on roll.   2)      Select the Filter Icon from the Menu Bar   3)     The Student Filter…

How Can I See Which Students are Free for a Particular Period

In Sims.net go to: Reports Student List General Student List Filter Double click Free at period Select the day and period Ok and Ok again This will filter to the students free for that period You can now sort  the records as you require This is useful for School Census Day to check students free…

Unable to run report – document management server not installed

If you are working on the main admin PC in school and get the above message please check the service is running Go to Start | Run | then type services.msc and enter. Scroll down list to find Sims.net Document Server Double click to open and check the service is ‘started’ If you are on…

Import SIMS .net Reports after an Upgrade

Hosted Service (Terminal Server) School  & Upgrade Service School please follow Reports > Import > Click Open and if neccessary browse to F/Public/Sims.net Browse to the latest version of the pre-defined report.rptdef file  – e.g. ‘Predefined Reports_v7.162.rptdef’ where 7.162 is the version of the SIMS .net you are now on.  Click Open Click Check All and…