"Yes, we know Progresso can easily take registers, but we want a paper version because we've not given our teachers access yet."
A good point made here, and Progresso's roll call maintenance feature makes quick work of bulk entry from the completed forms.
Also, because this question came from a primary school, we added the option of an additional column to be included (such as Lunch choice).
Another simple list report which lists learner contacts by group and priority filter.
List all associated contacts or just the ones with above a priority level.
14/11/13 Update: This report now lists all learners in the group regardless of having any contacts that match the selection criteria.
I wanted to have an attempt at using the expand (show/hide) feature in SSRS so I wrote this little widget to summaries the total learners by category (Free School Meal, Gifted and Talented and Looked After Children).
It consists of 3 tables, the 2nd and 3rd being a summary by gender. By clicking on the + you can expand or shrink each table.
Updated: 28/02/2014 to include Pupil Premium column and totals.
Here's a simple A4 landscape learner list report that uses the selected theme to define it's heading and highlighted colours.
Parameters include Academic year, Group Type and Group Code.
After 2 days of training in SQL Server Reporting Services (SSRS) I have now written my first report.
I wanted it to be useful but also to keep it simple what with it being my first venture into SSRS. As any of you who work with school's MIS databases will know the many different types of data that is recorded, so I decided to go for a report based on learner data.
Also, I love the fact that you can place these reports within a widget on a users desktop. So as soon as a user logs on, POW! there's the information.
Anyway, the report lists the different Ethnicity of the learners currently at the school. It also makes use of the 'Databar' feature which is a nice graphical way of viewing amounts.
