why custom field data not show in report

(9) Share

Report

Posted on by LA-02071030-0

251

i am working on custom report and i make custom field itemdescription on sales line i give this field both tables before posting and after posting sales invoice and when i enter data i see in sales invoice as well as on posted sales invoice but on report this field data not show i add clumn of this itemdesciption field and creat package and add this field in layout
and how we handle this condituon if vat is 0 then its column not show in report i make word layout

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (5)

Report
If your custom ItemDescription field is of type BLOB (e.g. used for long or formatted text), it won’t show directly in Word layouts unless you calculate and convert it into a text variable in the AL report code.

Here’s how to handle it: (i did this for Tax Invoice adjust your code according to your requirements)

dataitem(WorkDescriptionLines; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 .. 99999)); column(WorkDescriptionLineNumber; Number) { } column(WorkDescriptionLine; WorkDescriptionLine) { } trigger OnPreDataItem() var myInt: Integer; begin "Sales Invoice Header"."Work Description".CreateInStream(WorkDescriptionInstream, TextEncoding::UTF8); end; trigger OnAfterGetRecord() var TypeHelper: Codeunit "Type Helper"; begin if WorkDescriptionInstream.EOS then CurrReport.Break(); WorkDescriptionLine := TypeHelper.ReadAsTextWithSeparator(WorkDescriptionInstream, TypeHelper.LFSeparator()); end; trigger OnPostDataItem() var begin Clear(WorkDescriptionInstream); end; }

Assign ItemDescText to a global variable and bind that to the Word layout.

Also, for the VAT column, use a visibility condition in the layout like:

=IIF(Fields!VATAmount.Value = 0, False, True)

Lastly, check out Mr. Yun Zhu’s blog for more Word layout handling tips:

🔗 https://yzhums.com/27951/

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
LA-02071030-0 251 on at

Like (5)

Report
This is custom field itemdescription of data type text[500] which data npot populate on reports

and for vat this expresion i write in vat column
=IIF(Fields!VATAmount.Value = 0, False, True)

Was this reply helpful? Yes No
LA-02071030-0 251 on at

Like (4)

Report

vat% come like this

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (4)

Report

Hi, First check whether this value is included in the following file. If not, it is a problem with the field addition. If it is, it is a layout problem.

Dynamics 365 Business Central: Save report dataset to Excel from the request page (Report Inspector)

https://yzhums.com/14497/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (3)

Report

Hi

It seems to be misconfigured. Could you check if you entered the field name correctly? That value of 15000 doesn't seem right to me.

=IIF(Fields!VATPercent.Value = 0, 0, Fields!VATPercent.Value)

Best

GR

Was this reply helpful? Yes No