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:

FunctionDescriptionExample
Logo()Define and fetch dynamic or default logos from the databaseLogo(‘LogoName.png’)
Image()Define and fetch dynamic images from the databaseImage(‘ImageName.png’)
Signature()Define and fetch dynamic signatures from the databaseSignature(‘SignatureName.png’)
DB Image()DBImage(string viewName, string selectColumn, string filters) Define and fetch dynamic images from a separate database viewDBImage(‘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’)