15 October 2010

Hints & Help: A list of Instruments and Pupils

Welcome to the third installment of the Help blog, this week the Support Ticket chosen was another 'HowTo' question. A customer wanted to know how many pupils were presently having lessons within the service, not including and including groups, and also a list of the total number of instruments on loan etc.

The solution was as follows:

For the Pupils having lessons you need to do Pupil Lists and Member Lists for groups. These are found in the School, Centre and Group tabs. When you publish the report, open the Data tab, which will take you to a table of the data, click any column header with a Sigma (The Big 'E' thing) and from the drop down list that appears click 'count' you will then be see the total number of Pupils/Memebers having tution at the moment at the bottom of the table. Note that you need to do this with Schools, Centres and Groups and then add them together, there is no report to show ALL pupils.

The solution for the Instruments is simelar, firstly you will need to print an Instrument Stock Report and select that you want a list of all instruments.To get this to to Instruments -> Print Instrument Stock Report. Once you have done this click on the data tab and do a count (like with the Pupil lists). Then you need to group the data by the InstrumentStatusDsc column, you will then see how many instruments are on hire etc.

Thank you for reading this and I hope it could prove helpful to you in the future, The Help blog will be back next week!

No comments:

Post a Comment