1.Add the following class path to Report Designer. Refer to the documentation accompanying Report Designer for more information.

C:\oracle\ora92\jdbc\lib\classes12.jar

where C:\oracle\ora92 is the directory containing classes12.jar.

2.Select File > New Catalog.

A catalog is a repository for reports. The catalog and the reports that are based on it must be in the same directory for the report to run. This is because the catalog contains the object definitions that are used by the reports in the catalog.

3.In the Name box, enter a name for the catalog, such as custom.cat.

4.Save the catalog in a directory created especially for it. This way you can work on the reports remotely and then easily move them when you are ready to integrate them with the product.

5.Click OK.

When you finish creating the catalog, the Catalog Browser window is displayed. (If you do not see the Catalog Browser window, open the catalog by selecting File > Open Catalog.) Select the catalog you want to open, and then click Open.

6.In the Catalog Browser window, expand the Default node in the tree, and then right-click Connection and select New Connection.

7.Verify that the OracleOraHome92TNSListener service is running on the management server.

NOTE: If you want to view live data in your custom reports, the management server does not need to be running; however, the Oracle database for the management server does need to be running.

8.In the Get JDBC Connection Information window do the following:

a.Deselect the Use ODBC Data Source option.

b.Select the JDBC Driver option.

c.Enter the following command for the JDBC driver: oracle.jdbc.driver.OracleDriver

d.Enter the following command in the JDBC URL box: jdbc:oracle:thin:@HostIP/DNS:1521:APPIQ

where HostIP/DNS is the host IP address or DNS name of the host running the management server

If Report Designer is running on the same computer as the management server, you can use localhost for the DNS name, as shown in the following example: jdbc:oracle:thin:@localhost:1521:APPIQ

e.Enter the following in the User Name box: Report_User

This is the user name that is used to access the schema view in the management server database. This user has read privileges only for the schema views.

f.Enter the following in the Password box: appiq

9.Click OK.

Report Designer searches for JDBC driver.

446 Running Reports