Add self-created Field in Item as a dataset to a report in AL

(0) Share

Report

Posted on by TTTRRR

I created this table extension (and page extension) to add fields to Item

tableextension 50100 "Fuu Field" extends Item
{
    fields
    {
        field(50100; "Fuu"; Text[100])
        {
            Caption = 'Fuu';
        }
    }
}

How can I add the field to the Standard Sales - Invoice report dataset?

I tried the following, but neither Fuu_Line nor Fuu_Line_Lbl are recognized

reportextension 50100 FuuReport extends "Standard Sales - Invoice"
{
    RDLCLayout = './src/StandardSalesInvoiceExtended.rdlc';
    
    dataset
    {
        addLast(Line)
        {
            dataItem(Item; Item)
            {
                DataItemLink = "No." = FIELD("No.");
                DataItemLinkReference = Line;
                DataItemTableView = SORTING("No.");
        
                column(Fuu_Line; Fuu) { }
                column(Fuu_Line_Lbl; FieldCaption(Fuu)) { }
            }
        }
    }
}

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Please try to use below code:

reportextension 50100 FuuReport extends "Standard Sales - Invoice"

{

RDLCLayout = './src/StandardSalesInvoiceExtended.rdlc';

dataset

{

addbefore(shipmentline)

{

dataItem(Item; Item)

{

DataItemLinkReference = Line;

DataItemLink = "No." = FIELD("No.");

DataItemTableView = SORTING("No.");

column(Fuu_Line; Fuu) { }

column(Fuu_Line_Lbl; fuu) { }

trigger OnAfterGetRecord()

begin

fuu := Item."No."; // You can take your new fields value here.

end;

}

}

add(Header)

{

column(fuu; fuu)

{ }

}

}

var

fuu: Text;

}

Was this reply helpful? Yes No