Question Status

Verified
Yoki Prasayadi asked a question on 6 Feb 2014 8:20 PM

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.

Reply
Suggested Answer
Denis Macchinetti responded on 6 Feb 2014 10:44 PM

Hi

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

Regards

Reply
Yoki Prasayadi responded on 6 Feb 2014 10:54 PM

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. :)

Reply
Verified Answer
Denis Macchinetti responded on 7 Feb 2014 9:49 AM

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

Reply
Yoki Prasayadi responded on 9 Feb 2014 9:15 PM

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?

Reply
Verified Answer
Denis Macchinetti responded on 10 Feb 2014 10:40 PM

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

Reply
Yoki Prasayadi responded on 13 Feb 2014 6:47 PM

Problem solved. Thanks Denis.

Reply
Denis Macchinetti responded on 13 Feb 2014 9:28 PM

Hi

Great Yoki.

Please, remember to set the answer as verified.

Thanks much

Have a nice day.

Reply
Mario Zuniga responded on 24 Jul 2015 12:08 PM

Hello,

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

Thanks

Mario Zuñiga

Reply
Verified Answer
Denis Macchinetti responded on 7 Feb 2014 9:49 AM

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

Reply
Verified Answer
Denis Macchinetti responded on 10 Feb 2014 10:40 PM

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

Reply
Suggested Answer
Denis Macchinetti responded on 6 Feb 2014 10:44 PM

Hi

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

Regards

Reply