web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Display Image of Items...
Microsoft Dynamics AX (Archived)

Display Image of Items from CompanyImage Table into Crystal Reports

(0) ShareShare
ReportReport
Posted on by Yoki Prasayadi 275

Hi Guys,

I have an assignment to make a price list of items in Crystal Reports. Been looking up for answers from google but could find the right ones.

Any idea how to display image that stored in CompanyImage Table (ref to InventTable) in Crystal Reports? All fields are shown, only image is remaining. For your information, i'm using CR 11.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi

    Here community.dynamics.com/.../244414.aspx you can find many tips.

    Regards

  • Yoki Prasayadi Profile Picture
    Yoki Prasayadi 275 on at

    Hi

    I've seen that page and the code didn't work. I am designing my report in Crystal Reports 11 and accessing InventTable + CompanyImage to display the content. All fields are displayed but only image didn't show.

    Googled and still didn't get the answer.

    But thanks for the link. :)

  • Verified answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi

    In my past i had created a .NET DLL called by AX.

    So, on a class i was reading the AX tables data and for each records i called a .net DLL where i serialized the data. Finally call the Crystal report.

    I think you can use the same method.

    Alternatively, you can read also this post blogs.msdn.com/.../working-with-images-blobs-between-ax-and-external-applications.aspx

    Could be another idea.

    Regards

  • Yoki Prasayadi Profile Picture
    Yoki Prasayadi 275 on at

    Hi Denis,

    That's a bit confusing.

    But if you still can bear with me. I have done this:

    I end up converting the image to base64String (successfully) but next problem occurs. How to use this encoded base64 string that needs to be converted into image in Crystal Reports?

    I know how to convert base64 string to image in VB Net but i don't know how to display it in Crystal Report.

    Help please?

  • Verified answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    HI

    I think that you should convert the base64 string to byte array and then move to Crystal Report.

    You can arrange the convertion from SQL side or with a Crystal report function.

    Honestly, I never tried it before.

    However, I'll try on my local and I will let you know

    Regards

  • Yoki Prasayadi Profile Picture
    Yoki Prasayadi 275 on at

    Problem solved. Thanks Denis.

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi

    Great Yoki.

    Please, remember to set the answer as verified.

    Thanks much

    Have a nice day.

  • Community Member Profile Picture
    Community Member on at

    Hello,

    Could you explain how you did it, convert the Base64 please?

    Thanks

    Mario Zuñiga

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans