To extend on Report 1 – we now add a condition. We want to add a condition of the student being current.
Click and drag Is Current Student from Available fields to Conditions.
The words ‘is true’ has appeared in the condition. This means that we only want students in this list where this condition is true. If you wanted all students EXCEPT current students you would change the condition to ‘is not true’. Change this by clicking on the words and selecting from the drop-down.
Click Generate Report to ensure the list has changed to only show current students.
Report 4: A list of the current students in the school with an alert
In Available Fields click on the > next to Students.
Click and drag First name and Surname to Selected Fields.
Click and drag Is Current Student to conditions (remain as ‘is true’).
In Available Fields click on the > next to Community Member – Alerts.
Click and drag Alert Type to Selected fields.
Click and drag Alert Type to Conditions and select ‘is not null’. The screen will appear like this:
Click Generate Extract, then select one of the available formats that best suits your requirements. The extract will appear in the same place that your internet browser shows any downloaded file.
f your extract is blank, there is no data that matches the conditions that you have entered. If this happens, you can edit or delete any conditions as required, then re-generate the extract.