Perforce 2007.1 P4Report User's Guide | ||
<< Previous Chapter Table of Contents |
Table of Contents Index Perforce on the Web |
Next Chapter >> Configuring and Using P4Report |
"Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language."
(From the Microsoft web page http://www.microsoft.com/data/odbc/)
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.
Perforce 2007.1 P4Report User's Guide | ||
<< Previous Chapter Table of Contents |
Table of Contents Index Perforce on the Web |
Next Chapter >> Configuring and Using P4Report |