Why is the display method not showed in the SSRS report?

(0) Share

Report

Posted on by Shooowtek

845

Hello,

I have an SSRS report, based on the standard SimpleQuery, which includes AssetBook table as the main data source. By extending the table, I added a display method to AssetBook. As a test, I placed it in a form and it works very well.
In the report it does not work. I connected this query to the datasets of my report, checked from the list to pass all methods (my method is of course visible in the list). I think I am doing everything what I should, but unfortunately the field on the report not showing. I think I have tried everything - full build, SQL Server Reporting Services restart, etc. and unfortunately I still have this problem.

I tried this, but I don't know if I used the view in the query correctly:

https://community.dynamics.com/365/financeandoperations/b/microsoftdynamicsaxextensions/posts/display-methods-on-ssrs-report-in-msdyn365fo

Has anyone had a similar problem before?

Thanks.

I have the same question (0)

All responses (4)

Answers (0)

Anton Venter 20,657 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Have you tried deploying the report from Visual Studio? Did you check that the name of the display method is correct in the report field?

Was this reply helpful? Yes No
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!

Yes, everything is OK. I put this field in the form and it works very well, but in the report unfortunately I can't show it.

I found this thread also:

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/468993/display-method-not-called-during-srss-report-execution/1287585

How do I include the AssetBook table view in my query? As a sub-datasource? Can someone explain to me how to do this?

I created a view, attaching the AssetBook table as a data source and provided all the fields from this table and wrote a display method.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,208 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

Display method on Table extension NEVER shows on an Ssrs report.

Create a view, use the AssetBookTable as datasource

Write your display method on the AssetBookTableView

Use the view as your Query datasource and you will find the display method on the report.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Please check this article

https://wp.me/p1C0vr-4C

Was this reply helpful? Yes No