To create a JDBC query using the Report Wizard:
Launch Reports Builder (or, if already open, choose FileNew
Report).
In the Welcome or New Report dialog box, select Use the Report Wizard, then click OK.
If the Welcome page displays, click Next.
On the Data Source page, click JDBC Query, then click Next.
On the Data page, click Query Definition to display the JDBC Query dialog box.
In the JDBC Query dialog box, define the JDBC query or procedure and the connection parameters for the data source. Click Help for assistance.
Click Connect to display the Connect dialog box.
In the Connect dialog box, enter your user name, password and database name, choose the Driver Type you want to use, then click Connect.
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.
Follow the Report Wizard to complete your report definition.
Copyright © 1984, 2005, Oracle. All rights reserved.