The
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
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.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:
When editing the properties of an image object, you are presented with the following options:
Specify one of the following resizing preferences:
Select to have the image imported as-is into the image object. If selected, no resizing of the image will occur.
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.
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:
Select an image from disk.
Specify the following information if the image you are importing will be pulled dynamically from a database the report writer is connected to:
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.
For more information on query sources and the link between database fields and report definition objects, please see the Getting Started chapter.
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.
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.
Specify how you want the image object to be positioned and sized within the section where it is located.
Specify the distance, measured in inches, from the section’s left border to the upper-left-hand corner of the image object.
Specify the width of the Image object, measured in inches.
Specify the distance, measured in inches, from the section’s top border to the upper-left-hand corner of the image object.
Specify the height of the image object, measured in inches.
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:
Select to save your settings.
Closes the screen without saving any changes, returning you to the Application desktop.