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.")

{

}

}

All responses (5)

Answers (0)

Suggested answer

Khushbu Rajvi. 3,866 on at

Like (1)

Report

Adding a field to rdlc report

Follow below steps: standard purchase order (word)
Suggested answer

gdrenteria 11,183 Most Valuable Professional on at

Like (1)

Report

Adding a field to rdlc report

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
Suggested answer

YUN ZHU 71,749 Super User 2024 Season 2 on at

Like (1)

Report

Adding a field to rdlc report

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
RB-10051553-0 16 on at

Like (0)

Report

Adding a field to rdlc report

Hi Sami,,

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

Sami Ullah 284 on at

Like (0)

Report

Adding a field to rdlc report

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.