Tuesday, September 24, 2019

Display Database Images in SSRS Report

Follow the below steps to display database images in SSRS Reports.

I have used AdventureWorksDW2017 database for the below example.

Create the dataset using the below sql script

select FirstName+' '+LastName as EmployeeName,Title as EmployeeTitle,EmailAddress,DepartmentName,EmployeePhoto
from DimEmployee

Create a table in report body and do the formatting.

Click on the text box property-> Insert->Image
Select Image source->Database
User this Field->Column Name (EmployeePhoto)

For detailed video click below:

No comments:

Post a Comment