How to display the name of reference field RecId?

Finance and Operations/AX Technical Forum
1

Hi,

I want to display the name of worker in report but this is a Ref Field. It displays only RecId, not display the name of worker.

For Example :

Dirpartytable HCMWorker InventQualityOrderTable

Name RecId Person RecId ValidatedByworker

(DirPartyTable RecId) (HCMWorker RecId)

In InventQualityOrderTable displays the validate worker name.

in my report it does not displays the name, In place of ValidatedByworker , I want to display the DirpartyTable Name.

Pls help me how to display the ref field recId names in Report.

Thanks,

Balu

2

HcmWorker::find(InventQualityOrderTable.ValidatedByWorker).name()

3

Hi Kranthi,

I already wrote this code, but it does not display the name.

Thanks,

Balu

4

It should work

5

I write the above code and run the report it throws the following error:

“Could not execute the query. The field(s) TmpCAL_InventQualityOrderTable.1.ValidateByWorker do not exist in the report provider table TmpCAL_InventQualityOrderTable.”

6

The code written by Kranthi should have worked. Perhaps you got the field name incorrect. The correct field is ‘ValidatedByWorker’.

7

I wrote the code In Local server it is working Fine, But same code I wrote in My Remote the code is not working

It throws the same error “Could not execute the query. The field(s) TmpCAL_InventQualityOrderTable.1.ValidateWorkerName do not exist in the report provider table TmpCAL_InventQualityOrderTable.”

How should I rectify these error, Please help me.