40
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.
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
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?
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.
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
Try the way in the already linked solution. You will not be able to do it via display methods.
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.
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.
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.
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
