25 May 2012

Hints & Help: Teacher CRB Information for Schools


Schools often ask for CRB information on the teachers you schedule to work with their pupils. All this information is stored within Ensemble so it’s a simple process to extract this information an produce on a report.

The first thing you need to do is extract teacher information in order to get at the teacher details including the CRD information and the schools they work at. To do this, select the Extract Teacher option on the Teachers menu. On the Teachers tab click the box to include a record for each lesson. You will also need to select the period of time covering the time the teachers will be at the school.


Clicking on the Extract button will send the extracted information to Insight. This will show a line for each lesson a teacher is schedule to work. This is more information than we need so we can remove a number of columns. To do this click on the “Select Columns” button, this will display a list of columns. Click the “None” button to remove all the columns and then tick the columns required. These are ActivityType, ActivityTypeID, TeacherID, LastName, FirstName, PoliceCheck, PoliceCheckSubmit, PoliceCheckRef, Venue, VenueAddressLine1, VenueAddressLine2, VenueTown, VenueCounty and VenuePostCode.

This will show the column information we required but it currently shows a line for every type of lesson each teacher in involved in. So we need to filter out all but school lessons and organise it so that we have a single line for each school per teacher.

Click on the Filter button and add a filter to the ActivityType column to select just those with a value of “S”. This will select just the school lessons. No drag the ActivityTypeID column heading up into the Group by Area. This will group the data by School but we also need to group by teacher. In order to do this you need to show the columns again. (They would have been hidden when you group by Venue). To do this, click on one of the small “+” plus signs over on the left. This will expand the grouping and show the columns. From here drag the TeacherID column up into the group by area as before and then create a New Dataset.


It’s important to drag the ActivityTypeID first and then the TeacherID column.

After clicking on the Create New Dataset button you will set the following.


As you can see the new dataset has all the same columns but now you only have one line per school/teacher combination.

Now that you have the data organised as you want it it’s a simple case to create a report containing a page for each school with a list of teachers working in the school together with their CRB information.

To create your report click on the Produce New Report button, this will take you through a report wizard consisting of a number of pages, each of which asks questions about the report you require.

On the first page you can enter a name for your report. The second page asks how you want to group the report. The grouping specifies how the report in organised, in this report we want all information to be grouped by school. We can therefore add Venue to the Group By list. You may have more than one school with the same name and so to ensure that each school have their own group we need to add a unique identifier to the grouping. The column ActivityTypeID uniquely identifies each school so select this column and add to the Group By list.


The next page of the wizard asks for the columns we want displayed on the report. We want to list the teachers name and CRB information so select FirstName, LastName, PoliceCheckSubmit, PoliceCheck and PoliceCheckRef columns.


The next page asks for any summaries you want added to the report. You used this to add totals to columns. In this report we don’t require any summaries so we can skip to the next page. This page asks how we want the data in each group ordered. We will order ours by the teacher’s last name so add LastName to the Order By list.

The next page allows you to specify how you want the report sectionalised. The reason for creating sections is to split a report up into areas covering one person or in our case one school. Sections are useful they allow you to email each section out to the related recipient.

With this report we want to have the option to email the information to each school so we select to section it by ActivityTypeID, this is the column that identifies each school.


We now have all the information to create our basic report so we can click on the Create Report button. This will generate the report and display it on the screen. The report has the teacher information but we now need to add the School details and tidy up its look.

To do these we need you switch to the report design view and from here make a few changes. The design view looks like this.


The design is split up into a number of regions.

· Page Header – Defines the area at the top of each page.

· Page Footer – Defines the area at the bottom of each page

· Report Header – Defines a page to include at the beginning of the report

· Report Footer – Defines a page to include at the end of the report.

· Header and Footer for each group – Defines the information to display at the beginning and end of each group area whenever the Group By value changes.

· Detail – Defines what included for each record in the dataset.

Our report has two groups one for ActivityTypeID and one for Venue. We need to hide the first group header and its footer. To do this right click somewhere on group header area and select Hide, then do the same for the group footer.


We now need to expand the heading for ActivityTypeID, do this by hovering over the line along the bottom of the area until the cursor changes then hold down the mouse and drag the line down so as to make the area bigger. You will see that the report wizard placed a field to display the ActivityTypeID within this area. We need to remove this by clicking on the field and then hitting the delete button.

We can now add the School name and address by dragging these fields from the field explorer over on the left hand side. Expand the Database fields node by clicking on the plus sign. Find the field called Venue and drag this into the group area. No repeat this for the other address fields. You can align the address information by dragging the fields around the area. You should end up with something like this.


To make the report look better you can also remove some of the column headings and move some of them down into the group area. The final design looks like this.


If you click back on the View Document button the report will be produced and should look something like this.


If you want to re-use the report at a later date you should switch back to design mode and click on the save definition button.

No comments:

Post a Comment