New report: Music Tuition Retention Report

One of our Melbourne schools phoned the other day and needed some help producing a report showing all music tuition enrolments and how many years they have been learning.  Because they have the multi-user version of Music Monitor, I was able to make some changes straight away for them.

Firstly, I added a new field called 'No. Years'.  This field calculates the number of years a student has been learning an instrument by subtracting the enrolment year from the the current year.  It also shows how many years a student DID learn, if the record has been archived. (It calculates YEARS only, so if a student enrolled THIS year, the number displayed in this field will be '0'... until NEXT year when it will show '1'.)

Then I created a new layout showing teacher name, enrolment date, termination date, subject, student name, current year level (will be empty if the student has left the school), and number of years learning.

Then I created a script to run this report from the 'What Do You Want To Do?' area, in the 'Quick Reports' category.  As with most other printouts, a default find request has been set up, but the script pauses and you can change it.  The report sorts by teacher name, then subject, then number of years learning, then student name (but you can change the sort order by cancelling the preview and re-sorting.)

We did all this in just over an hour and the Director of Music was very happy!

Here's what the report looks like:

The report is available in V7.17.5.