You need to create an extension in VSCode with your DataItem (Item table and related Default Dimension table, where the relation is Table ID = 27 and "No." = your Item No.).
Then, in AL a report is defined like the following example (I've placed here a sample with 2 related tables):
When compiling, VSCode creates the layout (RDLC or Word) and you can modify them in Report Builder.
report 50100 MySalesOrder
{
//DefaultLayout = Word;
RDLCLayout = 'Layout\MySalesOrderReportRDLC.rdl';
WordLayout = 'Layout\MySalesOrderReportWord.docx';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
CaptionML = ITA = 'My Sales Order Report', ENU = 'My Sales Order Report';
dataset
{
dataitem("Sales Header"; "Sales Header")
{
column("No"; "No.")
{
}
dataitem("Sales Line";"Sales Line")
{
DataItemLink = "Document Type"=FIELD("Document Type"),"Document No."=FIELD("No.");
column(Type; Type)
{
}
}
}
}
/* requestpage
{
layout
{
area(content)
{
group(GroupName)
{
field(Name; SourceExpression)
{
}
}
}
}
actions
{
area(processing)
{
action(ActionName)
{
}
}
}
}
var
myInt: Integer; */
}
