News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV forum Print item picture in ...

Microsoft Dynamics NAV forum

Suggested answer

Print item picture in SQL SSRS report

(0) Share

Report

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

Categories:

Development / Customization / SDK

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Suresh Kulla 43,640 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,155 on at

Like (0)

Report

RE: Print item picture in SQL SSRS report

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2

Martin Dráb 228,625 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans