Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to display item images in RDLC Reports.

Posted on by Microsoft Employee

Hi,

I have uploaded some images into items from the picture uploading in item card.

But, when i try to create RD CL report from the item tables it shows as "#Error".

Please help me to sort this issue.

Thank you.

Regards,

Dinuka.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to display item images in RDLC Reports.

    Thanks all. Now, the report is working well :)

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: How to display item images in RDLC Reports.

    Hi Dinuka,

    Follow this link http://msdn.microsoft.com/en-us/library/dd301353(v=nav.70).aspx

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: How to display item images in RDLC Reports.

    You need to set several things in the report in order to make this work.

    1. In the Picture Item column of the report delete the expression you have written already and then drag and drop image holder from the toolbox.

    2. In the properties of the Image Set the image source as Database

    3. Set the MIME type as per your image type.

    4. In the expression you need to convert your picture value. To do that use following code.

    =Convert.ToBase64String(Field!Item_Image.Value)

    Replace the "Field!Item_Image.Value" with your own code. 

    This should solve your problem. 

    For more information refer below link as well :

    saurav-nav.blogspot.com/.../nav-2013-and-nav-2013-r2-add-image-in.html

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: How to display item images in RDLC Reports.

    hi,

    did you call calcfields(picField)?

    follow:
    http://msdn.microsoft.com/en-us/library/dd301353(v=nav.70).aspx
    http://saurav-nav.blogspot.com/2014/04/nav-2013-and-nav-2013-r2-add-image-in.html

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans