Category / Section
Creating Dynamic Image Reports in Bold Reports
Published:
Updated:
This guide walks you through creating visually engaging and flexible report layouts in Bold Reports by adding dynamic images using the Image report item. By using expressions, you can fetch image URLs dynamically from a dataset or external API and place them on a freeform canvas, free from table constraints. This approach allows you to design adaptable, professional reports with images that update based on your data.
Steps to Create Dynamic Image Reports
- Insert the Image Report Item
- Drag and drop the Image report item onto your desired position on the report canvas.
- Drag and drop the Image report item onto your desired position on the report canvas.
- Configure the Image Report Item Properties
- Select the inserted Image report item.
- In the Properties panel under Basic Settings, set
Sourceto External or Database depending on where your image URLs are stored.
Apply the properties above to each image report item by setting the source to external.
- Setting the Expression
-
Click the small square next to the Value field to open the Expression Editor.
-
Use the following expression to dynamically fetch an image URL from your dataset:
-
=Split(Join(LookupSet(1, 1, Fields!url.Value, "DataSet1"), "::"), "::")(1)
Expression Function
| Expression | Description |
|---|---|
LookupSet(1, 1, Fields!url.Value, "DataSet1") |
Retrieves all image URLs from the url field. |
Join(..., "::") |
Combines the URLs into a delimited string. |
Split(..., "::") |
Breaks the string into an array of URLs. |
(1) |
Selects the second URL (array index is zero-based) |
- Preview the Report
- Run the report to preview how the images are rendered dynamically based on your dataset.
- Run the report to preview how the images are rendered dynamically based on your dataset.
