Skip to content

Enhancing Reports with Dynamic Images

This approach involves storing image data (typically in binary format) within a database table. When the image is needed, it is retrieved from the database and displayed or processed as required.

Dynamic Content: Images can be dynamically inserted into reports based on user input or other criteria. These images could be logos, images, or images used for signatures. Please follow the instructions on the Report images page to learn how to manage, import, and export images used on reports.

  • First, drag the picture box element from the toolbox into the layout.

  • Then invoke the Expression Editor from the inserted picture box element.

    Select the Image Source property and apply dynamic image functions to the layouts via the expression editor as follows:

Image Functions:

Function Description Example
Logo() Define and fetch dynamic or default logos from the database Logo(‘LogoName.png’)
Image() Define and fetch dynamic images from the database Image(‘ImageName.png’)
Signature() Define and fetch dynamic signatures from the database Signature(‘SignatureName.png’)
DB Image() DBImage(string viewName, string selectColumn, string filters) Define and fetch dynamic images from a separate database view DBImage(‘report_logo_’,’image_data’,’item_id=[ItemID]’)
Media() Media(string mediaName) Define and fetch dynamic image media items from the file store or the database. Media(‘2050’)