Display methods on SSRS report AX7

(0) Share

Report

Posted on by Vishal Jevtani

278

Hi,

I need to know how can we use display methods in SSRS reports. I am having an issue. I have created extension class for an existing table. and under that class I have written my display method.

[SysClientCacheDataMethodAttribute(true)]
public display CustAccount CustAccount(ProdTable _prodTable)
{
CustAccount custAccount;

if (_prodTable.InventRefType == InventRefType::Sales)
{
custAccount = SalesTable::find(_prodTable.InventRefId).CustAccount;
}

return CustAccount;
}

My report is a query based report.

I am able to see the display method in report and also I have dropped the field into the report design. But there is no value on the report.

Please guide me though this.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Sort by

André Arnaud de Cal... 304,553 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishal,

What datasources is the report based on? Also the ProdTable? Did you deploy the report to the SSRS server?

Was this reply helpful? Yes No
Vishal Jevtani 278 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

I am referring to the query (ProdReport) which has ProdTable as its root datasource. Yes i have deployed the report it is showing other additional fields I have added on query, but no any value in display method field.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,553 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishal,

I'm not that familiar with SSRS report customizations. I assume you had done a correct build. Can you verify if the control has the correct properties for the datasource and the field?

When you create a simple form with the ProdTable as datasource and the new display method, is it then showing the correct value?

Was this reply helpful? Yes No
Vishal Jevtani 278 on at

Like (0)

Report
Copy link

Link copied!

The control on SSRS has correct properties. I have tried it with form. It is working fine. Can't figure out what is the problem with report.

Was this reply helpful? Yes No
Suggested answer

Hichem.Chekebkeb 3,371 on at

Like (0)

Report
Copy link

Link copied!

I had similar issue when display method not showing its value. I fixed it with SSRS Server restart.

What I found is that if I use a display method from my own tables, it works fine. but when I use a display method from an extended out-of-box table this doesn't show any value. Still couldn't resolve this issue.

Was this reply helpful? Yes No
Suggested answer

faheem Ahmed 450 on at

Like (0)

Report
Copy link

Link copied!

issue is with the model you are sitting in.

example: I have created one new model MyModel and i want to use display method from HcmWorker Empname although in my report datasource it will show me method to select but will not return any information because its in application suit model to access value from that method i need to write delegate method.

Was this reply helpful? Yes No
Vishal Jevtani 278 on at

Like (1)

Report
Copy link

Link copied!

in my case model was the same. I tried using that query in a form to see if display value shows any value, it worked. but not in SSRS.

well i had to go for another solution and a join on query worked for me. Still I am in search of the answer for why the display method in extension would not work with SSRS

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report
Copy link

Link copied!

In platform update 10 display methods in forms has changed, the problem is the same, the method doesn't exists for the table (in the report design), only for the extension class, so you have to use a static method, you can see it in this link from Kurt Hatlevik’s AX Blog may be is the same problem in ssrs reports?

Was this reply helpful? Yes No
Adrian Pascari A 1,683 on at

Like (0)

Report
Copy link

Link copied!

Did you find a solution for this? Using Application version 7.3 and the display method is not returning anything in the SSRS report.

Was this reply helpful? Yes No
Ansar Basha 1,584 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

Did any one able to resolve the issue, kindly share your thoughts, data is not appearing on Report.

Thanks & Regards,

Ansar Basha.S

Was this reply helpful? Yes No