How to export enum value in Excel using custom electronic reporting

(0) Share

Report

Posted on by Vijay A. Vishwakarma

Hi All,

Can anyone help or provide a link, how to add or bind an Enum value or name in excel using electronic reporting report. Actually I want to create custom report (Excel) of Vendor transaction with enum value of transaction type.

Thanking you in advance.

Regards,

Vijay A Vishwakarma.

I have the same question (0)

All responses (2)

Answers (1)

Sort by

JamesT 341 on at

Like (0)

Report
Copy link

Link copied!

Hi Vijay,

I might have done something similar to what you are seeking (not 100% sure) for the Fixed Asset Roll forward report, which is also done via Electronic reporting and Excel format.

The client wanted to show the FIXED ASSET STATUS in the report.

However this is an ENUM field, so D365FO would allow me to just add the ENUM. So I used a formula to convert to a STRING, and this worked for me.

FAssetSTATUS: String = MID(TEXT(@.'>Relations'.AssetId.'book()'.Status),37,15)

Maybe it might be a solution for you.

Regards

James

Was this reply helpful? Yes No
Verified answer

huijij 19,813 on at

Like (0)

Report
Copy link

Link copied!

Hi Vijay,

The following blog mentions CASE function, for each enum value, type in the value you want to display in your report.

The formula is something like:

CASE(@.’purchLine()’.’getItemType()’, Po_Line_Type.Item, “Stock”,Po_Line_Type.Service, “Service”)

antoineabastian.wordpress.com/.../

Was this reply helpful? Yes No