Microsoft Dynamics AX (Archived)

Get employee Image from AX DB to SSRS Report

(0) Share

Report

Posted on by MAKDAX2012_Ahmed

110

HI,

Can any body help I am developing a SSRS report with external data source in DAX 2012 R3.

I want to show employee image on report from AX database but unfortunately image does not show on report,

even i set property of image bmp and one by one set all image property that is available in report but image doesn't show.

some please help me.

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Blue Wang on at

Like (0)

Report

Hi MAKDAX,

How do you link pictures? External?
Can you upload your current display and screenshots so that they are clearer?

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

no i want to fetch from database and my query is

select hcmPersonImage.IMAGE from hcmPersonImage

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Start with the help:

docs.microsoft.com/.../displaying-images-in-reports

docs.microsoft.com/.../add-an-external-image-report-builder-and-ssrs

axbloggerblog.blogspot.com/.../ssrs-report-display-image-from-database.html

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Makd,

What type is hcmPersonImage. IMAGE?
VARBINARY? Then it can choose DataBase to get resources.

They explained in detail the database and the methods of external use as well as some operations.

https://www.tutorialgateway.org/display-image-in-ssrs-report/

https://www.mssqltips.com/sqlservertip/2978/rendering-images-from-a-database-on-ssrs-reports/

I hope it will help you.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Look at the example of salesInvoice report . Simple example to look at is showing company logo on the report.

Was this reply helpful? Yes No
Mohammed Khatib 430 on at

Like (0)

Report

Hi Ahmed,

Can you please provide more information about the report:

1- Is this AX SSRS Report or External SSRS Report

2- Are you using Query Based report or Report Data Provider (RDP)

Thanks.

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

this is External SSRS Report

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

actually i am facing problem to get image from Dynamics AX 2012 R3 database as mention in above snap short.

When i get this image from RDP class(x++) it retrieves easily without any problem.

When i retrive image by T-SQL store procedure that fills report dataset and get image into report, does not show image on report this the actual problem i am facing.

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

actually i am facing problem to get image from Dynamics AX 2012 R3 database as mention in above snap short.

When i get this image from RDP class(x++) it retrieves easily without any problem.

When i retrive image by T-SQL store procedure that fills report dataset and get image into report, does not show image on report this the actual problem i am facing.

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

actually i am facing problem to get image from Dynamics AX 2012 R3 database as mention in above snap short.

When i get this image from RDP class(x++) it retrieves easily without any problem.

When i retrive image by T-SQL store procedure that fills report dataset and get image into report, does not show image on report this the actual problem i am facing.

Was this reply helpful? Yes No