Reports — Festival Tab

On this page you can generate reports for each Festival.

  1. Select the Festival Area and Festival from the drop down menu.
    1. By default, only Festivals from the current Festival year are listed.
    2. Click the All radio button to see previous Festival years.
  2. Select the desired report from the drop down menu.
    1. Here is a complete list of available reports and their descriptions:
      1. Compiled Festival Room Schedules: The schedule for every room in your Festival. Each time window is on a separate page. List contains time, event, class, student, required piece, scheduling notes.
      2. Compiled Festival Room Schedules-Recital Format: Identical to the previous report, except without individual time slots for each student. Times are listed by time window only.
      3. Student Registration List: A complete alphabetical list of all registrations for the selected Festival. If a student has multiple events, the registrations are listed in Bulletin order. List contains student name/entry ID, teacher, event, class, required & choice pieces/composers, room/date/time.
      4. Student Registration List-Recital Formal: Identical to the previous report, except without individual times for each student. Times are listed by time window only.
      5. Room Schedule (Public): A schedule without student names. The list is compiled by room, with each entry listed in chronological order. List includes time, entry ID, teacher #, event, class, required & choice piece/composer.
      6. Room Schedule (Public) - Recital Format: Identical to the previous report, except without individual times for each student. Times are listed by time window only.
      7. Room Schedule (Monitor/Judge: A schedule that includes a column for recording ratings. List includes time, student name/entry ID, event, class, required & choices pieces/composers, rating.
      8. Room Schedule (Monitor/Judge) - Recital Format: Identical to the previous report, except without individual times for each student. Times are listed by time window only.
      9. Teachers' Schedules for Distribution: The schedule compiled by teacher. Each teacher's schedule is on a separate page. List includes teacher name at the top, entry ID, student name, section, class, required piece, room, date, time.
      10. Teachers' Schedules for Distribution - Recital Format: Identical to the previous report, except without individual times for each student. Times are listed by time window only.
      11. Theory Event Register: An alphabetical list of all the theory registrations with a column to record the rating. List includes entry ID, student name, teacher #, event, level, rating.
      12. Teachers' Registration Invoices - All Teachers: An compilation of each teacher's invoice. Each invoice is on a separate page. List includes teacher name at top of page, entry ID, student name, event, class, required piece, amount.
      13. Teacher Numbers - Sort By Name: A list of teacher numbers ordered alphabetically by teacher's last name. List includes teacher #, teacher name, teacher email.
      14. Teacher Numbers - Sort By Number: A list of teacher numbers ordered numerically. List includes teacher #, teacher name, teacher email.
      15. Rating Sheets: A complete compilation of all the rating sheets for the selected Festival in schedule order. The teacher # is printed at the top, to the left of the barcode.
      16. Student History Report: A list of all the students who participated in the selected Festival with their complete performance history covering 15 years. List includes student name, entry ID, events, cup point totals, consecutive superiors, class/points earned per year.

The following reports can be used to print participation and Superior certificates. Download the PDF and perform a test print before using actual certificates. If  the document spacing is not going to align for your printer, use the export files instead. (See next section.)

      1. Certificates - Participation - Junior: This report generates a PDF that can be used for printing the small blue participation certificates for Junior Festival entrants. The exported data includes the name for official documents, Junior Club name, rating, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
      2. Certificates - Participation - Adult: This report generates a PDF that can be used for printing the small green participation certificates for Adult Festival entrants. The exported data includes the name for official documents, Junior Club name, rating, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
      3. Certificates - First Superior: This report generates a PDF that can be used for printing the large Superior certificates (white) for all entrants earning a first-year Superior rating. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
      4. Certificates - Consecutive Superior - 3: This report generates a PDF that can be used for printing the large 3-Year Superior certificates (red) for all entrants earning 3 consecutive Superior ratings. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
      5. Certificates - Consecutive Superior - 6: This report generates a PDF that can be used for printing the large 6-Year Superior certificates (brown) for all entrants earning 6 consecutive Superior ratings. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
      6. Certificates - Consecutive Superior - 9: This report generates a PDF that can be used for printing the large 9-Year Superior certificates (gold) for all entrants earning 9 consecutive Superior ratings. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
      7. Certificates - Consecutive Superior - Others: This report generates a PDF that can be used for printing the large Superior certificates (cream) for all entrants earning Superior ratings that are not 1st, 3rd, 6th, or 9th year consecutive Superiors. The exported data includes the name for official documents, # of consecutive Superiors (ordinal number, i.e. 2nd, 4th, etc), "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.

The following reports can be used to print participation and Superior certificates if the PDF files don't work for you. These reports will be an Excel file which can be utilized with the mail merge function in a certificate template document.

  • Note: You may export data for printing participation certificates either before or after Festival. A pre-Festival export will have a blank field for the rating. A post-Festival export will have the rating filled in; however, students who did not perform will have blank rating fields. Delete the records with blank rating fields before performing mail merge if you do not want these registrations to print. .
  1. Certificates Export - Participation - Junior: This report generates an exported Excel file that can be used for printing the small blue participation certificates for Junior Festival entrants. The exported data includes the name for official documents, Junior Club name, rating, event, class, year.
    1. Note: If the name for official documents is blank on the student's information page, there will be no name exported to this report.
  2. Certificates Export - Participation - Adult: This report generates an exported Excel file that can be used for printing the small green participation certificates for Adult Festival entrants. The exported data includes the name for official documents, Junior Club name, rating, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
  3. Certificates Export - First Superior: This report generates an exported Excel file that can be used for printing the large Superior certificates (white) for all entrants earning a first-year Superior rating. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
  4. Certificates Export - Consecutive Superior - 3: This report generates an exported Excel file that can be used for printing the large 3-Year Superior certificates (red) for all entrants earning 3 consecutive Superior ratings. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
  5. Certificates Export - Consecutive Superior - 6: This report generates an exported Excel file that can be used for printing the large 6-Year Superior certificates (brown) for all entrants earning 6 consecutive Superior ratings. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
  6. Certificates Export - Consecutive Superior - 9: This report generates an exported Excel file that can be used for printing the large 9-Year Superior certificates (gold) for all entrants earning 9 consecutive Superior ratings. The exported data includes the name for official documents, "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.
  7. Certificates Export - Consecutive Superior - Others: This report generates an exported Excel file that can be used for printing the large Superior certificates (cream) for all entrants earning Superior ratings that are not 1st, 3rd, 6th, or 9th year consecutive Superiors. The exported data includes the name for official documents, # of consecutive Superiors (ordinal number, i.e. 2nd, 4th, etc), "held in" text from the Settings tab of the Festival Area Management page, event, class, year. Note: if the name for official documents is blank on the student's information page, there will be no name exported to this report.