Note: The fee is an ESTIMATE only on this report.  The amount is calculated from the number of sessions and fee CURRENTLY stored in the Ensembles file which may not be the same as it was at the time of the requested term and year.  It is dependent on the rolls having been set up and marked in Music Monitor.

1.  Select the Term and Year then click 'Continue'

2.  You can further refine your search if you so choose.  Click 'Continue' at the top right.

3.  Your report is returned showing number of students, No of Enrolments and Total Fees. It is sorted by Campus (or School), then Ensemble Name.

4.  If you are happy you can save to pdf or print (click 'Preview' in the toolbar at the top of the screen to see these options.)

5.  To view the report differently, you can click the 'Change Sort Order' button.  You can remove fields from the sort order and move fields to a different place in the sort order.  eg. You could REMOVE Campus and School.

6.  You can also export the report to excel by clicking the green button.

Choose a location to save the file and enter a name for the file. Don't forget to specify the file type (excel worksheet) and tick the box to automatically open after saving. - In the next window you can name your worksheet if desired

In the next window you can specify the fields to export.  A default export order has been saved.  It's probably easier to use this default order and then delete the unnecessary columns from the exported spreadsheet.  Click 'Export'.