Microsoft Dynamics AX (Archived)

Get employee Image from AX DB to SSRS Report

(0) Share

Report

Posted on by MAKDAX2012_Ahmed

104

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

All responses (14)

Answers (0)

Suggested answer

Mohammed Khatib 430 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS Report

Hi Ahmed,

In your case this is totally related to SQL scripting and not AX X++.

Please refer to the below link on how to show vBinary on SSRS report as an image:

www.kodyaz.com/.../display-database-image-using-sql-server-2008-reporting-services.aspx

Thanks.
Blue Wang on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS Report

Hi Ahmed,

I'm sorry for missing the previous picture.
Have you checked my last link? Do you have any wrong tips?
MAKDAX2012_Ahmed 104 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS Report

yes it is varbinary max

but what should i write in expression? in report image filed that tutorial you have shared me not use full for me i tried many times but not avail i tried image type(png,jpg,bitmap etc.) but no avail.
Blue Wang on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS Report

Hi Ahmed,

Use stored procedures to get pictures. In my previous question, I asked you what the format of your Image field is.
Define as varbinary (max).
Then you need to use expressions in the parameters of the data set to get the address.

Please refer this : https://www.sqlshack.com/create-image-cataloging-system-using-sql-server-repoting-services/
MAKDAX2012_Ahmed 104 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS 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.
MAKDAX2012_Ahmed 104 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS 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.
MAKDAX2012_Ahmed 104 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS 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.
MAKDAX2012_Ahmed 104 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS Report

this is External SSRS Report
Mohammed Khatib 430 on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS 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.
Suggested answer

Sukrut Parab 71,680 Moderator on at

Like (0)

Report

RE: Get employee Image from AX DB to SSRS Report

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