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