Reporting

Various TIMS3 reports are provided to allow you to request listings of the information stored in the TIMS3 database in a formatted and organized way.
You can select the Reporting option from the main TIMS3 switchboard. This will present you with a screen allowing you to pick the various reporting options.

For each report selected, you will be prompted to enter the report title. Your company name and logo as defined in the Maintenance / Preferences section will appear on each page of the report.

You will notice that from this window you have access to various controls and options for generating the report:

Report Type	This allows you to select which type of report you wish to generate. The details for each report type are described below. Included in the report type is the size of paper needed to print the report.
Sort Order	This determines how the report should be organized. The options allows here depend on the report type selected. For example, if you select the detailed drawing report, you can request a sort order by Document Name or by Client Reference Number.
Projects or Charge No.	You can generate the various reports for all projects or for a selected set of projects. This option is available only for the document reports. The selection is switched to charge numbers when a PC accounting reports is selected.
Groups	You may limit reports to documents belonging to specific groups or departments defined in the system.
Documents	You can generate reports for a specific set of documents that you can select.

Report Types

Document Reports:

Detailed Report	This report is printed in landscape on legal size paper and lists all drawing revisions with: Document ID Creation Date Drawing Description Consultant Name Custom Defined Data Contract Information Drawing Scale Sheet Number Revision number and description Drawing Location Project Name
Detailed Report Most Recent Revision	This lists the most recent revision of the selected documents, showing the same information as the previous report.
Document Records without Files	This exception report lists all document records where the file recorded in the document information cannot be found on the associated project’s file server.
Detailed Drawing Report	This report displays all drawing related information, including: Document ID File Name Drawing Title Type of File Imperial or Metric drawing units Archive Status Drawing Status Date the drawing was last modified drawing size Budgeted man-hours File Lock (On or Off) Percentage Completion
Drawing Summary Report	This option is used to report the percentage completion of drawings. It includes: The Document ID File Name Drawing Title Client Reference Number Percentage completion The average percentage completion of drawings for the groups and/or projects, depending on your sort order, will be generated in the summary section of the report.
Drawing Technical Report	This lists specific drawing information such as the plot scale and working units. It provides a summary of the disk space used for each group and/or project, depending on your selected sort order.
Files without Document Record	This exception report alerts you to those files that exist on the server that do not have corresponding records in the document database
Summary Report	This report lists the last revision of the selected documents with the following information: Document Number Creation Date Document Description Last Revision Number, Description, Date Document Media Location Project Name
PC Usage	These reports summarize the accounting data that is recorded in the system. The PC Usage Summarized report allows you to select a sort order based on any one field. The PC Usage Summarized by Documents reports on the usage sorted by document name. It lists the user that worked on the document, the application that was used, the time spent working on the document, the workstation used, and the type of operation performed (i.e. modify or review). The PC Usage Summarized by User will have the same information but sorted by user. For both reports, you can select a secondary sort key, for example, by date or by workstation node name.

Other database reports include:

Report	Description
Company List Report	A listing of the companies (consultants or contractors) defined in the database
Contacts Report	A listing of the contacts defined on the system, with their associated companies shown
Project List Report	A summary of the projects defined on the system
Transfer Audit Report	A list of the file transfers (check outs, check ins, etc.) that have been executed on the system

Various other reports are available for presenting TIMS3 system data defined by your system administrator. These reports include:

Report	Description
Country List	A list of all the countries
Discipline List	A list of all the disciplines
Doc Status Value List	A list of the status values for each document
Doc Types List	A list of all the document types
Graphic Types List	A list of all the graphic types
Groups List	A list of all the groups
Plot Sizes List	A list of all the plot sizes
Prefix List	A list of all the prefixes
Project Status List	A list of the status of all the project
Spreadsheet Types List	A list of all the spreadsheet types
Suffix List	A list of all the suffixes
Title List	A list of all the titles
Word Pro Types List	A list of all the Word Pro types

As you select the report type, you will be presented with the valid sort options, and if applicable, the projects, groups and documents you wish to include in the report.

For example, if the Drawing Summary Report is selected, you may sort by:

• Client Reference Number
  

• Document Description
  

• Document ID
  

• Percentage Complete

You may click either on the Print button to send the formatted report directly to the printer, or on the Preview button which provides you with a display of how the report will appear on paper. If you approve the report, you can elect to print it.