Perforce 2007.3 P4Report User's Guide
<< Previous Chapter
Table of Contents
Table of Contents
Index
Perforce on the Web
Next Chapter >>
Configuring and Using P4Report

Preface
About This Manual

This manual describes the Perforce Reporting System (P4Report), which enables you to create reports by accessing the database where Perforce stores information about the files, users, clients, and jobs in its control. To access the database, you use SQL with an ODBC driver. Microsoft defines ODBC as follows:

After you install P4Report, you can use tools such as Microsoft Excel or Crystal Reports (or any tool that can interact with an ODBC data source) to report on Perforce activity. This guide provides examples of typical queries and reports.

P4Report includes the Perforce SQL Command-Line Client (P4SQL), which enables you to test queries against your Perforce server before embedding the queries into a reporting tool. To use the tool, choose Start>Perforce SQL>SQL Command Line Client. P4Report launches P4SQL in a DOS window. At the SQL prompt, you can issue valid SQL-92 queries. For details about using the command line client, refer to "Using the Perforce SQL Command-Line Client" on page 11.

For details about the SQL functions supported by P4Report, refer to Appendix B, P4Report Functions. For details about the schema of the Perforce database, refer to Appendix A, Database Schema and SQL Keywords.

Please Give Us Feedback

Does this guide provide the information you need to succeed with the product? Email comments and questions to manual@perforce.com.


Perforce 2007.3 P4Report User's Guide
<< Previous Chapter
Table of Contents
Table of Contents
Index
Perforce on the Web
Next Chapter >>
Configuring and Using P4Report
Please send comments and questions about this manual to manual@perforce.com.
Copyright 2002-2008 Perforce Software. All rights reserved.
Last updated: 03/01/07