Project Report Generator

To generate a report over Projects from within MDCMS, press F8 from the Project Listing screen select option 1 for Project Reports. The following prompt screen is then displayed:

This screen allows you to define your own Project Report. The report may consist of any or all of the listed fields and any or all Projects may be selected and sorted as you choose. The report definitions may then be saved and used again in the future from this screen or from a command line.

Seq

Each field with a sequence number > 0 will be included in the report. The columns of the report are ordered by the sequence number. The sorting of the records is also based on the order of the sequence fields.

Minimum

The smallest value that the corresponding field may contain, unless the value is a special value or a generic value

Special Values:

*PY - the date must fall within the previous year (only valid for date fields)

*PM - the date must fall within the previous month (only valid for date fields)

*CY - the date must fall within the current year (only valid for date fields)

*CM - the date must fall within the current month (only valid for date fields)

Generic Values:

The wildcard value * may be used multiple times anywhere within a string to limit records to occurrences where the field contains the string. For example, *3XJ* will select all records where the value 3XJ is contained somewhere within the field string. *XJ will select all records where the value XJ is contained at the end of the field string.

Maximum

The largest value that the corresponding field may contain. This field must be left blank if a special or generic value was entered in the Minimum field.

Sort

A - Sort this field in ascending (A->Z) order.

D - Sort this field in descending (Z->A) order.

Function Keys:

F3=Exit

F4=Browse - Browse the list of available entries depending upon which field the cursor is positioned.

F5=Refresh - Reset the definition back to the initial settings

F7=Load Def - Load a definition from the list of saved definitions

F9=Save Def - Save the entered configuration as a report definition. The saved definition may then be reused at anytime in the future from within MDCMS or from a command line. See the chapter on MDRUNRPT for more information about running reports from a command line.

F11=View Output - Display the MD Output panel and other spool files.