SUPPORT/
DOWNLOADS

REPORT KEY

* = Report requires OPAS Extended
= Word Document
= Excel Document
= Word 2007 Document
=OPAS Internal Report

= Information about the report, how to download, etc..
= PDF document
= Opens in new browser window
VFP = FOXPRO (standard OPAS) Users
SQL = SQL-Server Users

Composition List and General Reports

Composer Anniversary Chart - Shows -- for the next 10 years -- major birth and death anniversaries for any set of composers

Here

Mar. 09

Work List - Produces simple list of compositions

Here

Mar. 07

Work List Alphabetical by Title - Primarily for Pops compositions, this version sorts first by title then by composer

Here

Mar. 07

Work List with Dates - Simple list of compositions including composer and work dates

Here

Mar. 07

Work List with Detailed Instrumentation - Prints full percussion, keyboard, extra instrument lists and uses an asterisk (*) to indicate wind and brass doublings

Here

May 07

Work List with Detailed Instrumentation and with Library Shelf (Catalog) No. - Prints full percussion, keyboard, extra instrument lists and uses an asterisk (*) to indicate wind and brass doublings

Here

June 07

Work List with Duration - Simple list including work duration

Here

Apr. 07

Work List with Instrumentation Summary - Orderd by composer, Wind and Brass doublings are indicated with an asterisk (*)

Here

Mar. 05

Work List with Instrumentation - Orderd by composer, Wind and Brass doublings are indicated as in David Daniels' "Orchestral Music"

Here

Mar. 05

Work List with Library Shelf (Catalog) No. - Simple table of Works grouped by Composer and showing the shelf number and publication for works in your library

Here

Mar. 05

Work List with Most Recent Performance - Prints the compositions you select and indicates the most recent performance and conductor where applicable

Here

May 05

Work List with Movements - Includes duration of movement(s) and works

Here

Mar. 05

Work List with Publisher Information - Compositions grouped by composer with publisher information (availability, reprints, etc.)

Here

Mar .05

Work List with Specified Doublings and Detailed Instrumentation - Includes detailed indication of doubling instruments, and complete Percussion, Extra, Keyboard, Solo Instrument and Chorus information

Here

Feb. 09

Works not performed - From the list of compositions you select, the report prints only those not performed

Here

May 05

ASCAP / BMI Programs - Programs for quarterly submission

Here

Jul 02

MOLA Repertoire Rept. Output  - Concert repertoire output in the old MOLA rep report format  

Here

June 02

NEA "Representative Programming" - List / schedule of performances and repertoire for grant applications such as those for the NEA

Here

Feb. 04

Performance Histories

Performance History - Overview - Performances are grouped by Project and Season

Here

Mar. 09

Performance History - 5 Season Overview - Each of the past five seasons is shown in a column with either a simple indication or the Project code if the selected works were performed in that season. 'Next' season performances are also shown for context

Performance History - 20 Season Overview - Each of the past 20 seasons is shown in a columns of 5-season 'blocks' with a simple indication if the selected works were performed in that season. 'Next' season performances are also shown for context

Work Perfomance History - with reporting options - Before the report is run, you can specify the time period, Projects to include/exclde and other reporting options Perfomances are grouped by Project and Season.

Work Performance History - Basic List  - Similar in layout to the Performance History screen, each performance of the work(s) selected constitutes a row in the table.

Here

Feb. 09

Work Performance History - Detail - Includes the Dates, Season, Project/Series, Venue, Conductor, Soloist(s), and other works on the program

Here

Feb. 09

Performance Count (number of performances)

VFP

SQL

13.May.03

Program 'Context' report - when a certain work has been programmed, what other works were on the concert?

VFP

SQL

05.Apr.05

Season Work List with Soloists - works being performed in a given season (or any other time period)

VFP

SQL

21.Feb.03

Library Catalog - Standard format with Instrumentation (Landscape format)

Here

Oct. 07

Library Catalog - Standard format with Instrumentation (Portrait format)

Here

Oct. 07

Library Catalog with most recent performance

Here

Oct. 07

Library Catalog with Score Information - includes score holdings along with work instrumentation / publication info

Here

Oct. 07

Library Expense Tracker - An all-in-one Excel spreadsheet that allows you to view and analyze library expenses over multiple seasons and expense typest. (a related how-to guide on library expenses can be found here)

Call
(why?)

May 08

Work List with Publisher & Library Info - For the activities you select, the report shows each work performed (grouped by composer) and library / publication info for each.

Here

Jan. 09

Work List with Publisher & Library Info / Date Sorted - Similar in content to the report above, but presented chronologically by Project

Here

Jan. 09

Work List with Publisher, Library and Instrumentation info - For the activities you select, each program is shown, with instrumentation and library/publication info for each work.

Here

Jul 03

Rental Contract Summary - For the time period selected the report shows Season/Project, Conductor, Performance, Work, Publisher and Rental cost information.  

Here

Feb. 07

Rental Contract Summary without cost information - Layout and information is the same as above, but omits expenses

Here

Feb. 07

Rental Contract Summary by Project

Here

Feb. 07

Rental Order form - Boosey & Hawkes

Here

June 07

Rental Order form - C.F. Peters

Here

June 07

Rental Order form - European American Music

Here

June 07

Rental Order form - G. Schirmer

Here

June 07

Lists, Labels and General Reports

Artist List - prints a quick list of entries you select in the Address Book. Includes a version that prints the musician's instrument as well.

Here

Mar. 05

Mailing Labels - 5160 format 

Here

Nov. 03

Mailing Labels - 5161 format 

Here

Mailing Labels - 5162 format 

Here

Mailing Labels - 5164 format 

Here

Nov. 03

Musician Phone / Address Lists - a set of four reports:

• Musician Phone / Address List
• Musician Phone / Address / Instrument List
• Musician Phone / Email List
• Musician Phone / Email / Address List

Here

Feb. 09

Performance Histories

Artist Performance History Overview - Suitable for Conductors and Soloists. 

Here

Feb. 09

Artist Performance History - Full Program - Suitable for Conductors and Soloists. Shows the entire program for the concerts in question (not just the work on which the soloist perfomed)

Here

Mar. 09

Conductor Performance History - by Composer/Work - For the Conductor(s) you select, shows works performed, grouped by composer. Includes soloist, performance dates and project.

Here

02.Apr.05

Conductor Repertoire List (works conducted)  

VFP

SQL

29.Jul.03

"Conductors who have appeared with this Soloist"

VFP

SQL

04.Nov.02

"Soloists who have appeared with this Conductor"   

VFP

SQL

04.Nov.02