| title | Add a data-bound image to a paginated report | |
|---|---|---|
| description | Learn how to reference an image that is stored in a database to display the image in your paginated reports in Report Builder. | |
| ms.date | 09/25/2024 | |
| ms.service | reporting-services | |
| ms.subservice | report-design | |
| ms.topic | how-to | |
| ms.custom |
|
[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]
A paginated report can include a reference to an image that is stored in a database. Such an image is known as a data-bound image. The pictures that appear alongside product names in a product list are examples of data-bound images.
Adding a data-bound image to a page header or page footer requires additional steps. For more information, see Page headers and footers (Report Builder).
-
In report design view, create a table with a data source connection and a dataset with a field that contains binary image data. For more information, see Tables (Report Builder).
-
Insert a column in your table. For more information, see Insert or delete a column (Report Builder).
-
On the Insert menu, select Image, and then choose in the data row of the new column.
-
On the General page of the Image Properties dialog, enter a name in the Name text box or accept the default.
-
(Optional) In the Tooltip text box, enter text to display when the user hovers over the image in the report rendered for HTML.
-
In Select the image source, select Database.
-
In Use this Field, select the field that contains images in your report.
-
In Use this MIME type, select the MIME type, or file format, of the image-for example, bmp.
-
Select OK.
An image placeholder appears on the report design surface.