Collapse AllExpand All

3.14. Images

'Insert Image' Icon

The Image icon enables you to create new image objects. Image objects are used to insert either static or dynamic images into a report definition. Static images—a company logo displayed in the report header, for example—are embedded within the report definition. Dynamic images—pictures of products, for example—are pulled from the database the report writer is connected to, or alternatively from the local file system depending on the structure of the query. If the user query selects a column that is a string(text within quotes), the renderer will assume that the string represents a path on disk and retrieve the image based on the specified path.

To create a new image object, first select the Image icon. Then click in the section of the report definition where you want the image to be located. Doing so will create the image object in that section.

Note

For more information on using image objects in report definitions, see the Advanced Topics chapter.

Once the image object has been created, you may then edit the image object's properties. To edit an image object's properties, double-click on the image object. The following screen will appear:

Image Editor

When editing the properties of an image object, you are presented with the following options:

Resize Mode

Specify one of the following resizing preferences:

Clip

Select to have the image imported as-is into the image object. If selected, no resizing of the image will occur.

Stretch

Select to enable manual resizing of the image once it has been imported into the image object. When manually resizing an image, the image's aspect ratio will be maintained.

Static Image

Select if the image you are importing is a static image. Static images are images which are embedded within a report definition. They are not pulled dynamically from a database. An example of a static image would be a company logo inserted on the top of a standard form. When the 'Static Image' check box is checked, the report writer is connected to:

Load

Select an image from disk.

Database

Specify the following information if the image you are importing will be pulled dynamically from a database the report writer is connected to:

Query Source

Select a query source from the drop-down menu by clicking on the arrow to the right of the field. Query sources are used to populate report definition objects with dynamic data from the database the report writer is connected to.

Note

For more information on query sources and the link between database fields and report definition objects, please see the Getting Started chapter.

Column

Specify the name of the database column you want to use from the selected query source. A query source may refer to multiple columns in its SELECT statement. By indicating a specific column, you instruct the query source to return data only for that specified column. Other columns appearing in the SELECT statement will be ignored. If the column specified in the query is a string(within quotes), the program will search the given disk path for the specified image.

Note

xTuple users can store images in an xTuple database using the client interface. Images imported this way are stored in the image_data column of the images table, using the UU encoding format.

Position/Size

Specify how you want the image object to be positioned and sized within the section where it is located.

X

Specify the distance, measured in inches, from the section’s left border to the upper-left-hand corner of the image object.

Width

Specify the width of the Image object, measured in inches.

Y

Specify the distance, measured in inches, from the section’s top border to the upper-left-hand corner of the image object.

Height

Specify the height of the image object, measured in inches.

Note

The position and size of an image object may be modified manually when editing a report definition.

At the bottom of the screen, the following buttons are available:

OK

Select to save your settings.

CANCEL

Closes the screen without saving any changes, returning you to the Application desktop.