Why display method is not returning Image ?

(1) Share

Report

Posted on by Majid Hafeez

I have developed a Query based report. I want to display Images for relevant Item. Hierarchy of query is SalesTable and SalesLine Table and I have written Display method on SalesLine Table.

22600.Capture.JPG

On SSRS report, I have mapped a source type is Database and Image type is jpeg.

If some have solution please provide.

Thanks,

Majid Hafeez

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Display methods are not going to work.

Here is the documentation on providing images for SSRS reports in AX 2012:

technet.microsoft.com/.../cc622140.aspx

Here is a practical example on how to use images for a Query based report. They also mention how would it look like if you would use a Data Provider class such as SalesInvoiceDP.insertIntoSalesInvoiceTmp.

blogs.msdn.microsoft.com/.../dynamics-ax-2012-reporting-how-to-add-company-logo-into-query-based-report

Was this reply helpful? Yes No
Martin Dráb 239,364 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

First of all, you code doesn't do what you want. As I understand, you want an image related to the item on the sales line, but your code never look at the line; it selects *some* record from ProductBranchImage table (if I ignore the missing semicolon, which makes the code even incompilable).

By the way, using a join would be more efficient than executing a separate query to database for every line.

Was this reply helpful? Yes No
Majid Hafeez 40 on at

Like (0)

Report
Copy link

Link copied!

Martin, I have provided just sample code to view an image for Item. I can move to my actual code once it get fixed . I just need a solution against my issue. If you have idea, how to add image to report using display method, please share it.

Thanks.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Try the way in the already linked solution. You will not be able to do it via display methods.

Was this reply helpful? Yes No
Majid Hafeez 40 on at

Like (0)

Report
Copy link

Link copied!

Vilmos thanks for comments. But I need some solution or work around, I don't want to convert the query datasource to RDP because I have to change whole structure for the report. If you some work around please share it.

Thanks

Was this reply helpful? Yes No
Sohaib Cheema 49,679 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I cannot see anything wrong with your approach(on ssrs only)

so I would verdict martin comments, here. I am very suspicious and wondering if your method is returning something. as I said, nothing seems wrong with adopted approach otherwise.

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

The second link does exactly what you would like to do without data providers, I even made it bold that it is for Query based report, what you have. Did you read it?

Was this reply helpful? Yes No