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

Adding a field to rdlc report

(1) Share

Report

Posted on by RB-10051553-0

Hi,

I have added a field in to the Purchase Order using a page extension & table extension code. The values are displaying on the purchase Order page. But the purchase Order template rdlc the field is displaying as blank. Can you please advice where I am going wrong.

field(50012; "Tariff No_"; Text[100])

{

Caption = 'CN Code';

FieldClass = FlowField;

Editable = False;

CalcFormula = Lookup(Item."Tariff No." where("No." = field("No.")));

}

Report.al code to display the field in the BC Purchase Order report template

dataitem("Itemt"; "Item")

{

DataItemLink = "Tariff No." = field("No."), "No." = field("No.");

DataItemLinkReference = "Purchase Line";

DataItemTableView = sorting("No.");

column(TTariffNo_PurchaseLine; "Item"."Tariff No.")

{

}

}

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Sami Ullah 315 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

When you extend a table and add a new field, the report dataset must also include this field. To ensure the new field is available to the RDLC layout, you need to update the Dataset of the RDLC report.

Open the report object related to the Purchase Order and ensure the new field is added to the report's dataset. Without this, the RDLC report will not be able to access or display the field.

Was this reply helpful? Yes No
RB-10051553-0 30 on at

Like (0)

Report
Copy link

Link copied!

Hi Sami,,

I have already added the field to the RDLC dataset as well, not working.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,084 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

Dynamics 365 Business Central 2021 release wave 1 (BC18): Report extensibility (ReportExtension Object)

https://yzhums.com/10723/

Dynamics 365 Business Central: How to add Media or MediaSet data type (Pictures) to a report

https://yzhums.com/38137/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

I hope this can help and give you some hints.

How do I: Create a Report Extension to add a field to the dataset of a Report? – think about IT

Adding fields to reports with ReportExtensions – hougaard.com

Best

GR

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Follow below steps: standard purchase order (word)

Was this reply helpful? Yes No