How to add a field from another table in a report extension.

(1) Share

Report

Posted on by Community member

I want to create a new Pys. Inventory List with 2 other fields that are in the Item table.

/No./ is already there, but I also need /No. 2/ and /Item Category Code/

reportextension 50105 TellelisteEXT extends 722

{

dataset

{

add(/Item Journal Line/)

{

column(ItemNo2_ItemJournalLine; item./No. 2/)

{ }

column(ItemCatCode_ItemJournalLine; item./Item Category Code/)

{ }

}

requestpage

{

// Add changes to the requestpage here

}

rendering

{

layout(LayoutName)

{

Type = RDLC;

LayoutFile = 'Telleliste.rdl';

}

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (1)

Report

How to add a field from another table in a report extension.

Did you get item record anywhere?

You may have to get it like

modify("Item Journal Line")

{

trigger OnBeforeAfterGetRecord()

begin

item.Get("Item No.");

end;

}

Was this reply helpful? Yes No
Community member 9 on at

Like (0)

Report

How to add a field from another table in a report extension.

I only get this error with or without your code:

error AL0161: 'Item' is inaccessible due to its protection level

So if I press CTRL+F5 it starts compiling and gives the error.

With your code before or after "add" I get that same error twice:

\Phys.Inv.List.Ext.al(14,45): error AL0161: 'Item' is inaccessible due to its protection level

\Phys.Inv.List.Ext.al(16,49): error AL0161: 'Item' is inaccessible due to its protection level

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
How to add a field from another table in a report extension.

Hi, try the following.

reportextension 50118 MyExtension extends "Phys. Inventory List" { dataset { addfirst("Item Journal Line") { dataitem(Item; Item) { DataItemLink = "No." = field("Item No."); DataItemLinkReference = "Item Journal Line"; column(ItemNo; Item."No.") { } } } } }

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Community member 9 on at

Like (0)

Report

How to add a field from another table in a report extension.

Thanks! That put me on the right track and I was able to get the correct fields :)

Was this reply helpful? Yes No