Time Report Generator

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

This screen allows you to define your own Time Entry Report. The report may consist of any or all of the listed fields and any or all entries 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. The only exception is the Description field, which is not part of the sort.

Minimum

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

Special Values:

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

*PW - the date must fall within the previous week (only valid for date fields)

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

*CW - the date must fall within the current week (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.

Task Description Field

Minimum - Tasks can be filtered by a generic value entered in the minimum field

Maximum - The maximum length of the description that will be in the report. The default length is 160 characters and a length of up to 600 characters is permitted.

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.