OPAS - Repertoire Reports

Repertoire and Work Reports

		ASCAP / BMI Program Submissions
	Description	Displays program information for a month or quarter that corresponds to the preferred format of ASCAP and BMI. Please use this report to submit your program reports to those organizations. Contact information is contained within the report.
	Download	Click here and save the file to your hard drive. Extract or Unzip the report to the OPAS\REPORT_ART folder on the Server (this report is not put on to your own computer)
	To run the report	In the DATES area of OPAS, filter to a single month of activities - these can include classical, pops and educational concerts. With all of the events showing on the LIST Screen of OPAS, click the Report icon (or press the F4 key) and select this report. The report will filter out the appropriate information Once the report has been generated, type any notes or comments that may be necessary and email the document to ASCAP and BMI using the addresses in the header of the document.
	Revisions / Notes	This report was designed by ASCAP and BMI and is their preferred method for receiving program reports from OPAS orchestras. Please run and submit these reports once a month, or no later than once a quarter. Contact Fine Arts Software with questions regarding the technical execution of this report. General questions about the report or its submission should be directed to: ASCAP - Andrew Shreeves \| BMI - Barbara Petersen
	Click the Back button or...	Return to the top of this page. Go to the Download Instructions page Return to the main Report Download page


		Work List
	Description	Produces a quick list of compositions. This report is primarily used to print the results of a search in the Works area of OPAS
	Download	Click here and save the file to your hard drive. Extract or Unzip the report to the OPAS\REPORT_ART folder on the Server (this report is not put on to your own computer)
	To run the report	In the WORKS area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List
	Revisions / Notes	Works are grouped by Composer
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Dates
	Description	Produces a quick list of compositions, including the date(s) for both the composer and the works. Used primarily to print the results of a search in the Works area of OPAS
	Download	Click here and save the file to your hard drive. Then double-click the attached file and extract/unzip it to the OPAS\REPORT_ART folder on the Server.
	To run the report	In the WORKS area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List (with Dates)
	Revisions / Notes	Works are grouped by Composer
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Duration
	Description	Produces a quick list of compositions, including work duration. Used primarily to print the results of a search in the Works area of OPAS
	Download	Click here and save the file to your hard drive. Then double-click the attached file and extract/unzip it to the OPAS\REPORT_ART folder on the Server.
	To run the report	In the WORKS area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List (with Duration)
	Revisions / Notes	Works are grouped by Composer
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Movements
	Description	Produces a quick list of compositions with total duration, and the movement names/duration for the work. This report is primarily used to print the results of a search in the Works area of OPAS
	Download	FoxPro uses (standard OPAS) right here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the Works area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List (with Movements)
	Revisions / Notes	Works are grouped by Composer
	Click the Back icon or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Publisher Information
	Description	Produces a quick list of compositions including the Publisher of the work, reprints, editor, and information regarding Conductor and Piano/Vocal scores. This report is primarily used to print the results of a search in the Works area of OPAS
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER USERS right-click here and save the file to your hard drive.
	To run the report	In the Works area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List (with Publisher Information)
	Revisions / Notes	Works are grouped by Composer
	Click the Back icon or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Library Catalog/Shelf No.
	Description	Produces a quick list of compositions including the shelf number(s) for score(s) in your Library. This report is primarily used to print the results of a search in the Works area of OPAS
	Download	Click here and save the file to your hard drive. Then double-click the attached file and extract/unzip it to the OPAS\REPORT_ART folder on the Server.
	To run the report	In the Works area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the compositions showing on the List screen, click the Report icon and choose Work List (with Library Catalog No.)
	Revisions / Notes	Works are grouped by Composer
	Click the Back icon or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Instrumentation
	Description	Produces a list of compositions including instrumentation. Woodwind and Brass doublings are spelled out ( 2[1,2/P] 2[1,BC] 21). Keyboard instrument abbreviations and extra instruments are given, but percussion instruments are not printed
	Download	FoxPro users click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the Works area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the compositions showing on the List screen of the works area, click the Report icon and choose Work List (with Instrumentation).
	Revisions / Notes	Works are grouped by Composer
	Click the Back icon or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Instrumentation Summary
	Description	Produces a list of compositions including instrumentation. Woodwind and Brass doublings are indicated by an Asterisk (2221). Keyboard instrument abbreviations and extra instruments are given, but percussion instruments are not printed
	Download	FoxPro users click here and sake the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the Works area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the compositions showing on the List screen of the works area, click the Report icon and choose Work List (with Instrumentation Summary).
	Revisions / Notes	Works are grouped by Composer
	Click the Back icon or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work List with Detailed Instrumentation
	Description	This report produces a list of compositions including total work duration, an asterisk for woodwind doublings (2221), and complete lists of Solo, Percussion, Keyboard, Extra and Vocal instruments used.
	Download	Click here and save the file to your hard drive.
	To run the report	In the WORKS area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List (with Detailed Instrumentation)
	Revisions / Notes	Works are ordered by Composer and Work Print Title
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page


		Work List with Detailed Instrumentation and Library shelf number
	Description	This report produces a list of compositions including the shelf or catalog number(s) for any score(s) you have in the Library, total work duration, an asterisk for woodwind doublings (2221), and complete lists of Solo, Percussion, Keyboard, Extra and Vocal instruments used.
	Download	Click here and save the file to your hard drive.
	To run the report	In the WORKS area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the works showing on the List screen of the works area, click the Report icon and choose Work List (with Detailed Inst & Library Shelf No.)
	Revisions / Notes	Works are ordered by Composer and Work Print Title
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work Performance History Overview
	Description	Displays a concise performance history of the work(s) you select. Includes the Dates, Season, Project, Venue, Conductor, Soloist(s) and performance Timing. This version puts the unique Project/Conductor in each row of the table, and shows the date range for the Project.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users right-click here and save the file to your hard drive.
	To run the report	In the WORKS area of OPAS, use any combination or form of search techniques to isolate a set of compositions. As with all Word reports, there is a finite amount of data that can be processed with this report - it is advised that you keep the number of compositions below 60 or so. With the desired compositions displayed on the List screen of the Works area, click the Report icon (or press the F4 key on your keyboard). Select this report.
	Revisions / Notes	This report was originally requested by the Boston Symphony Orchestra Archives.
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work Performance History - Basic List
	Description	Displays a concise performance history of the work(s) you select. Includes the Dates, Season, Project, Venue, Conductor, Soloist(s) and performance Timing. This version puts each single performance in a separate row of the grid (much like the Performance History grid in OPAS)
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the WORKS area of OPAS, use any combination or form of search techniques (see Chapters 20 and 21 of the Manual) to isolate a set of compositions. As with all Word reports, there is a finite amount of data that can be processed with this report - it is advised that you keep the number of compositions below 60 or so. With the desired compositions displayed on the List screen of the Works area, click the Report icon (or press the F4 key on your keyboard). Select this report and click Preview
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Work Performance History - Detail
	Description	Displays a complete performance history of the work(s) you select. Includes the Dates, Season, Project, Venue, Conductor, Soloist(s), performance Timing and other works on that program
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the WORKS area of OPAS, use any combination or form of search techniques (see Chapters 20 and 21 of the Manual) to isolate a set of compositions. As with all Word reports, there is a finite amount of data that can be processed with this report - it is advised that you keep the number of compositions below 30 or so. With the desired compositions displayed on the List screen of the Works area, click the Report icon (or press the F4 key on your keyboard). Select this report and click Preview
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		MOLA Repertoire Report
	Description	Not a "finished" report per se, but a report to produce data for import into the MOLA repertoire database on the MOLA web site (www.mola-inc.org).
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the DATES area of OPAS, use any combination or form of search techniques (see Chapters 20 and 21 of the Manual) to isolate a set of performances in a single season. You can have any number of activities, projects, etc. as are applicable. It is strongly advised, however that you have the search find only performances. While the report will filter out any non-performance activities, it takes the report much longer to do this than OPAS's search function. You are better off, therefore, to select only concerts or use the Advanced Search function to isolate only performances. Consult the OPAS manual or contact Fine Arts Software for assistance. With the desired activities displayed on the List screen of the Dates area, click the Report icon (or press the F4 key on your keyboard). Select the "MOLA Repertoire Report Output" report and Click Preview After the report has been generated First, be sure to run the OPAS Italicizer macro to remove all the unwanted '<' characters (see the main report page of this web site for instructions, if you require). Fill out the submission information at the top of the completed report, and save the report as a text-only file. Then email this saved file to Ron Whitaker: RonWhit@USA.Net. It will then be imported into the MOLA on-line repertoire database.
	Revisions / Notes	Created specifically for the Major Orchestra Librarians' Association
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Composer Anniversary Chart
	Description	For the composers you choose, this document shows all birth and death anniversaries from 2003 through 2013.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the Composers area of OPAS, use any combination of filters and/or searches to produce a list of composers. With the composers showing on the List screen, click the Report icon and choose Composer Anniversary List and click the Preview button.
	Revisions / Notes	This report runs on whatever criteria you have selected, so it could, for example, be generated for living composers, only American composers, etc. As there is a fair amount of calculation involved, it is recommended that you test this on a sub-set of your composer list before running the report for all composers. Modifications such as including the Composers' nationality are easily accommodated.
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Conductor Repertoire List (works conducted)
	Description	Displays all repertoire performed by a conductor over any time period. Works are grouped by Composer and the report indicates the Work Name, Season, Project, Soloist(s), number of performances and first performance date.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	In the DATES area of OPAS, use any combination or form of search techniques to isolate a set of performances by a single conductor. You can have any number of seasons, projects, etc. It is strongly advised, however that you have the search find only performances. While the report will filter out any non-performance activities, it takes the report much longer to do this than OPAS's search function. It can be better, therefore, to select only concerts or use the Advanced Search function to isolate only performances. The easiest way to do this is to click any check mark in the Performance column on the Dates List screen and press the F7 key on the keyboard. Consult the OPAS manual or contact Fine Arts Software for assistance. With the desired activities displayed on the List screen of the Dates area, click the Report icon (or press the F4 key on your keyboard). Select this report.
	Revisions / Notes	This report was originally suggested by the Indianapolis Symphony Orchestra.
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Repertoire Analysis / Performance by Project ("Clash" Report)
	Description	Intended for future programming needs, or for archival/grant writing analysis of performance history, this report shows, grouped by composer, each work performed in either the three or five seasons you select. For each work, and within each season, the report indicates the Project(s) on which the work was perfumed. This provides a concise history and breakdown of each work.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	This report is unique in that it runs from the SEASONS area of OPAS. Click the Background Data 1 \| Seasons... menu item. Ctrl+click or Shift+click to isolate either three or five seasons. With those three or five seasons showing on the list screen, click the Report icon and choose either: 3-Year Rep Clash List - Project 5-Year Rep Clash List - Project ...depending upon the number of seasons you've chosen. Click Preview
	Revisions / Notes	This class of reports is extremely processor-intensive. It may take the report several minutes to run - in particular, there may be a lengthy wait between the time the report finishes and you see the OPEN / PRINT window. The report automatically filters out all projects with the words "Education", "Youth" or "Administration" in them. Given the wide variety of orchestra operations, you may wish to have the report further refined (or have additional versions of the report created) to restrict to certain Projects. For example, a Pops-only version, eliminate "Family" Projects, etc. The report can also be modified to include performances by only one or a set of conductors. Most of these refinements will be simple and not incur a charge. See the Series "Clash" reports for another version of this document.
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Repertoire Analysis / Performance by Series ("Clash" Report)
	Description	Intended for future programming needs, or for archival/grant writing analysis of performance history, this report shows, grouped by composer, each work performed in either the three or five seasons you select. For each work, and within each season, the report indicates the Series on which the work was perfumed. This provides a concise history and breakdown of each work.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users right-click here and save the file to your hard drive.
	To run the report	This report is unique in that it runs from the SEASONS area of OPAS. Click the Background Data 1 \| Seasons... menu item. Ctrl+click or Shift+click to isolate either three or five seasons. With those three or five seasons showing on the list screen, click the Report icon and choose either: 3-Year Rep Clash List - Series 5-Year Rep Clash List - Series . . . depending upon the number of seasons you've chosen. Click Preview
	Revisions / Notes	This class of reports is extremely processor-intensive. It may take the report several minutes to run - in particular, there may be a lengthy wait between the time the report finishes and you see the OPEN / PRINT window. The report automatically filters out all Projects with the words "Education", "Youth" or "Administration" in them. Given the wide variety of orchestra operations, you may wish to have the report further refined (or have additional versions of the report created) to restrict to certain Projects. For example, a Pops-only version, eliminate "Family" Projects, restricted to certain Series, etc. The report can also be modified to include performances by only one or a set of conductors. Most of these refinements will be simple and not incur a charge. See the Project "Clash" reports for another version of this document.
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		Performance Count
	Description	These reports provide a performance history summary for compositions. The reports summarize the number of performances, non-performances, and Projects to which a work has been assigned.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive. REMEMBER that these are Built-In reports (not Word reports) so they go into the OPAS\REPORT folder on the server (not in to the OPAS\REPORT_ART folder)
	To run the report	In the Works area of OPAS, use any combination of filters and/or searches to produce a list of compositions. With the results showing on the List screen, click the Report icon and choose Performance Count (note there is no Word icon for these reports)
	Revisions / Notes	This PDF file outlines the structure and output of the report. PerfCountReports.PDF You can either click on the link above to open the pdf file in your web browser, or you can right-click and download the file to your hard drive. In either case, you can also print the report for future reference.
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

		NEA "Representative Programming" sheet
	Description	Provides a concise list of Projects, artistic personnel and programming. Created primarily for NEA and other grant applications that require "representative programming" lists.
	Download	FoxPro users (standard OPAS) click here and save the file to your hard drive. SQL-SERVER users click here and save the file to your hard drive.
	To run the report	Use any combination or form of search techniques (see Chapters 20 and 21 of the Manual) to isolate activities within a single season. These can be from any set of Projects With the activities showing on the List screen, click the Report icon and choose the NEA Application - Representative Programming. Then click the Preview button.
	Revisions, Notes or Comments	Originally suggested by the Nashville Symphony. The artist fees do not automatically print simply for security purposes. It's easy to include fees from the Contracts area of OPAS and instructions will be sent on securing the report once that is done. The report can also be modified for other grant or reporting purposes
	Click the Back button or...	Return to the main Report Download page Return to the Works report download section Go to the Download Instructions page

Repertoire and Work Reports

ASCAP / BMI Program Submissions

Work List

Work List with Dates

Work List with Duration

Work List with Movements

Work List with Publisher Information

Work List with Library Catalog/Shelf No.

Work List with Instrumentation

Work List with Instrumentation Summary

Work List with Detailed Instrumentation

Work List with Detailed Instrumentation and Library shelf number

Work Performance History Overview

Work Performance History - Basic List

Work Performance History - Detail

MOLA Repertoire Report

Composer Anniversary Chart

Conductor Repertoire List (works conducted)

Repertoire Analysis / Performance by Project ("Clash" Report)

Repertoire Analysis / Performance by Series ("Clash" Report)

Performance Count

NEA "Representative Programming" sheet