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

Selecting an image from the database

Note: These steps, and the steps to link an image object to a file (for paper-based reports only), allow you to include images in a wide variety of formats supported by Oracle Reports, including JPEG (all types, such as Progressive JPEG and Exif JPEG), PNG, BMP, TIFF, GIF, and CGM. For paper-based reports, you can also use Insertright arrowImage to import an image from a file into the report layout for images in the following formats: TIFF, JFIF, BMP, TGA, PCX, PICT, GIF, CALS, RAS, OIF, PCD.

To select an image from the database:

  1. Create a query that selects a column containing images or the filenames of image objects.

  2. In the Data Model view, double-click the image column to display the Property Inspector.

  3. If the column contains the filenames of image objects, rather than the images themselves:

  4. In both cases (a column containing images or a column containing the filenames of image objects): under the Column node, set the File Format property to Image.

  5. If you are developing a JSP-based Web report, you will also need to add the containsHtml attribute to the <rw:field> JSP tag for the column, as follows:

  6. To preview your report output with Web layout in a Web browser, choose Programright arrowRun Web Layout to run the Web Source. If you have made changes to the Web Source view (for JSP-based Web reports), this enables you to immediately see the effect of your changes on the output.

See also

About images

Selecting an image URL from the database

Linking an image object to a file

Linking an image object to a URL

Importing an image (for images of format TIFF, JFIF, BMP, TGA, PCX, PICT, GIF, CALS, RAS, OIF, PCD)

About database columns