P4Report is a reporting solution that allows users to generate reports by accessing the Perforce database. The program provides support for Crystal Reports, Microsoft Excel and other tools that retrieve data by using ODBC sources.
The package includes the option to extract data by using the command line to run SQL queries.
What's New in This Release:
Major changes:
· The P4SQL command line client has been ported to work on Unix and Windows x86_64.
· Added tables for 'fstat' and 'resolved' data.
· Added a LIMIT keyword to limit the number of results or return the results after a specified offset. Not part of SQL-92.
· The command line client can now output results in XML using the-X flag. The '&', '' characters in the results data are returned as "&", '<' and ">" respectively.
Minor changes:
· The SubmitOptions and LineEnd fields are now available from the "clients" table for client and server versions 2008.2 and above.
Bugs fixed:
· Labels and other specifiers over a fixed size can cause a crash. The size has been increased to support the server maximum of 1024.Identifiers over 1024 characters are truncated.
· Server counters that were strings instead of numbers are now correctly handled. The counter value is now a WVARCHAR instead of an INTEGER.
· Output from the serverAddress field of the "info" table is no longer corruptible.
· Impr...