Small and medium business | Business Central, N...

Failing to add dataitem to dataset for Transfer Order report

(1) Share

Report

Posted on by TapiwaLouis

Good day,

I'm relatively new to BC development. I'm trying to add a custom text field to the Transfer Order report and reference it in the OnAfterGetRecord trigger.

Followed steps on some blogs and managed to add a field to the base table. But now in my reportextension when i attempt to add the dataitem in then dataset it keeps giving me the following error:

Please assist me.

I'm using: Version: GB Business Central 22.2 (Platform 22.0.57579.0 + Application 22.2.56969.57617)

Syntax error, '}' expectedALAL0104

Expected one of the application object keywords (table, tableextension, page, pageextension, pagecustomization, profile, profileextension, codeunit, report, reportextension, xmlport, query, controladdin, dotnet, enum, enumextension, interface, permissionset, permissionsetextension, entitlement)ALAL0198

Categories:

Dynamics 365 Business Central

I have the same question (1)

All responses (2)

Answers (0)

Suggested answer

Yi Yong 2,559 Super User 2025 Season 2 on at

Like (1)

Report
Hello,

You are using ReportExtension, you can't add a new dataitem immediately after dataset.

You can only add new dataitem by referencing to existing dataitem using addafter or addbefore.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-ext-object

https://community.dynamics.com/blogs/post/?postid=8514d608-fa2e-416b-b6fc-9b55537dc554

reportextension 50000 TransferOrder extends "Transfer Order" { dataset { addafter(CopyLoop) { dataitem(NewTransferHeader; "Transfer Header") { column(NewField; NewField) { } } } } var NewField: Text; }

If you want to add new field into existing dataitem, then you can use Add(DataItem) and insert the new field.

reportextension 50000 TransferOrder extends "Transfer Order" { dataset { add("Transfer Header") { column(NewField; NewField) { } } } var NewField: Text; }

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps: https://learn.microsoft.com/en-us/training/modules/report-extensibility/

Was this reply helpful? Yes No