How to pass an Image as a parameter to an SSRS Report

Question

Hello,

We need to pass an image as a parameter to an SQL SSRS Report.
How would this be done since there is only a date, number, bit and text type for SSRS parameter types ?

Thank you

Answer 1

Hi @vsslasd

First, when setting parameters, you can set the path of the image as the value of the parameter. Then when inserting a picture, set the path in the picture property to this parameter.

For more details, you can refer to this link: Image parameter on ssrs report.

Best regards,

Aniya

Answer 2

Pass an image in which way? As file name/URL it's possible.

But not as BLOB or object.

Answer 3

Hello and thank you both.

Neither of those will work. The image itself must be passed.

I believe the image can be converted to varchar(max) Base64, passed to a stored procedure and then the following command to convert from varchar(max) Base64 to a varbinary:
SET @CapturedPhoto = CAST('' AS XML).value('xs:base64Binary(sql:variable("@SignImage"))', 'VARBINARY(MAX)');

Answer 4

SET @CapturedPhoto = CAST('' AS XML).value('xs:base64Binary(sql:variable("@SignImage"))', 'VARBINARY(MAX)');

Answer 5

Hi @vsslasd

Yes, if you want to store the image itself in the database, you can write the picture as binary data directly into a database field. It can be written using background programs or T-SQL commands.

Shown here is the method using the T-SQL command, executing the SQL OPENROWSET command with the BULK and SINGLE_BLOB options. For more details you can check this link: Save Image to Database Table in SQL Server.

I am not very familiar with programming, if you need help in this area, you can go to the relevant tag to ask more professional personnel.

Once images are stored in the database, paginated reports can reference such images, known as "data-bound images". To add data bound image to paginated report, you can refer to this link: Add a data-bound image to a paginated report.

Then we can experiment with parameters. Here I have made a table with the picture name as a parameter.

Best regards,

Aniya