A database column represents a column that is selected by the query, containing the data values for a report. For each column that you select in your query, Reports Builder automatically creates a column in the data model of your report. If you want to perform summaries and computations on database column values, you can create new columns manually in the Data Model view (for summary and formula columns) or by using the Report Wizard (for summary columns). You can also reassign one or more columns to a group or groups youve created.
In addition to the traditional column types (for example, date, number, character), Reports Builder also supports graphic or image columns, which are columns whose values can be:
graphics or images stored directly in the database. Such a column is usually of data type LONG or LONG RAW and contains a graphic or image. In this case, specify the graphic or image format in the columns properties.
file names. The values of such a column are pointers to files stored in the operating system. In this case, specify in the columns properties that its values are file contents (Read from File property) and the format of the files. Many graphic and image formats are supported, including BMP, CALS, CGM, GIF, JFIF, PCD, PCX, PICT, RAS, TIFF, and so on.
Selecting an image from the database
About referencing columns and parameters
Copyright © 1984, 2005, Oracle. All rights reserved.