Print item picture in SQL SSRS report

(0) Share

Report

Posted on by NavTech

2,382

Hi Experts ,

I want to display item picture in SQL SSRS report in nav 2018 . Picture data type in 2018 is changed to MediaSet . Actual image is stored in Tenant Media table . I can't stablish relation between item picture and Tenant Media .

When I try to display picture directly from item table using sql query . it doesn't display it .

Thanks

All responses (3)

Answers (0)

Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Print item picture in SQL SSRS report

Please check this you need a .NET assembly that can convert that and then use that in your SQL Query.

devch.wordpress.com/.../

devch.wordpress.com/.../
NavTech 2,382 on at

Like (0)

Report

RE: Print item picture in SQL SSRS report

That solution works in CAL , I need to it in SQL SSRS
Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: Print item picture in SQL SSRS report

This is a good resource: cloudblogs.microsoft.com/.../