Using the Sample Reports
- Copy the reports to a location where they are accessible from the Crystal Reports application.
- Configure a SystemDSN variable using the appropriate operating system tool (Microsoft ODBC Administrator) to connect to the Contenta Database environment. The user is the Contenta Database name and the password is pdmuser.
- Open a report and establish a connection to your Contenta database using the ODBC connection option and choosing the SystemDSN configuration (Step 2). Log in to the database using the Contenta database name and password (Step 2).
You do not have to add tables when establishing the connection unless you would like to customize the report. The report uses the command objects created to extract the appropriate data from the database.
This document describes the SQL that was used to create the following Contenta Reports:
- Due Date
- Project Lock
- Work In Progress
- Auto Populate
- Query Report
To create the reports, Contenta potentially makes two connections to Oracle/MSSQL database. The first connection uses the Contenta APIs/Contenta Server and the second uses Power Builder ODBC drivers.