Display Method Data Not Showing in Query-Based SSRS Reports in D365 FO

 While working on a Query-Based SSRS Report in Dynamics 365 Finance & Operations, I faced an issue where a display method added through a table extension was not showing data in the SSRS report design, even after adding it to the dataset.

Issue

• Extended a table and added a display method.

• Added the display method in the SSRS report dataset.

• Field appeared in the dataset/design, but data was not displayed in the report.

Resolution

To resolve the issue:

1. Created a new View using the same table.

2. Moved the display method from the table extension to the View.

3. Joined this View with the existing SSRS report View/Query.

4. Built and synchronized the project.

5. Refreshed the SSRS report dataset by using the Query.

6. Added the View display method field into the report design.

Result

The data started displaying correctly in the SSRS report.

Key Takeaway

In D365 FO, display methods from table extensions may not work properly in Query-Based SSRS reports. Using a View and exposing the display method through the View can be a reliable workaround.