Display images stored in Database – SSRS
SSRS has a feature to read image data from the SQL Server database. In this article, I will be giving step by step method to store image into database and display it in SSRS reports.
Step 1: Create a table with the following DDL
CREATE TABLE [dbo].[Pictures](
[Picture] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Step 2: Download this Image to your local drive.
Step 3: Upload image data to SQL table
INSERT INTO dbo.Pictures(Picture)
SELECT * FROM OPENROWSET(BULK N'<>\sql2012.jpg’, SINGLE_BLOB) AS i;
Step 4: Create a report and create data source that connects to the image database and create dataset to fetch the image data from the Pictures table.
Step 5: Add image component and configure with image dataset
Step 6: Click OK and preview the report
Thanks for reading.