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

Creating a Text data source query using the Report Wizard

Before you use a Text pluggable data source, you might want to examine the text file by opening it in a text editor first to see what it looks like.

Accessing a Text data source does not require any database connection information as required for SQL queries.

To create a Text query using the Report Wizard:

  1. First, set up the Text PDS configuration file (textpds.conf) with your text file's format information.

  2. Launch Reports Builder.

    Tip: If Reports Builder was already open when you modified the textpds.conf file, you must shut down Reports Builder and restart it for Reports Builder to recognize your text file as a valid data source.

  3. In the Welcome dialog box, select Use the Report Wizard, then click OK.

  4. If the Welcome page displays, click Next.

  5. On the Report Type page, select Create Paper Layout only, then click Next.

  6. On the Style page, type a title for your report and select the desired report style, then click Next.

  7. On the Data Source page, click Text Query, then click Next.

  8. On the Data page, click Query Definition to display the Define Text Query dialog box.

    If you get an error message and cannot display the Define Text Query dialog box, check your configuration file (textpds.conf) to confirm the code you added.

  9. In the Define Text Query dialog box, under Data Definition, select the format for your Text data source. The formats listed here are registered in the textpds.conf file.

  10. Under Data Source, click Browse to find the file for the Text PDS, or type a URL where the Text PDS is located in the Location field.

  11. Click OK to close the dialog box and display your Text query in the Data Source definition field on the Data page of the Report Wizard.

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

See also

The chapter titled "Building a Report with a Text Pluggable Data Source" in the Oracle Reports Building Reports manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).

About the Text pluggable data source

Creating a Text data source query manually