Print item picture in SQL SSRS report

(0) Share

Report

Posted on by NavTech

2,390

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

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/.../

Was this reply helpful? Yes No