A script-enabled browser is required for this page to function properly.

Creating a JDBC data source query using the Report Wizard

To create a JDBC query using the Report Wizard:

  1. Launch Reports Builder (or, if already open, choose Fileright arrowNewright arrowReport).

  2. In the Welcome or New Report dialog box, select Use the Report Wizard, then click OK.

  3. If the Welcome page displays, click Next.

  4. On the Data Source page, click JDBC Query, then click Next.

  5. On the Data page, click Query Definition to display the JDBC Query dialog box.

  6. In the JDBC Query dialog box, define the JDBC query or procedure and the connection parameters for the data source. Click Help for assistance.

  7. Click Connect to display the Connect dialog box.

  8. In the Connect dialog box, enter your user name, password and database name, choose the Driver Type you want to use, then click Connect.

  9. In the JDBC Query dialog box, click OK to close the dialog box and display your JDBC query in the Data Source definition field on the Data page of the Report Wizard.

  10. Follow the Report Wizard to complete your report definition.