Share
Report
20Hi all,
I have created a report extension, to get data from another table. In this report extension I have added the dataitem Sales Comment Line and this is linked to the Sales Header.
I have created a report extension, to get data from another table. In this report extension I have added the dataitem Sales Comment Line and this is linked to the Sales Header.
Thereafter, I have downloaded the standard RDLC report and copied it in my extension and updated the dataset in the report. The Comment column is available.
However, somehow I do not get the information from the sales comment line. Has someone an idea why it is not working?
reportextension 60134 pickinstructieSchut extends /Pick Instruction/
{
RDLCLayout = 'layouts/pickinstructieSchut.rdl';
dataset
{
add(/Sales Header/)
{
column(ExternalDocumentNo; /External Document No./)
{
IncludeCaption = true;
}
column(Shipment_Method_Code; /Shipment Method Code/)
{
IncludeCaption = true;
}
}
addlast(/Sales Header/)
{
dataitem(/Sales Comment Line/; /Sales Comment Line/)
{
DataItemLink = /No./ = field(/No./);
DataItemTableView = sorting(/Document Type/, /No./, /Document Line No./, /Line No./) where(/Document Type/ = const(Order));
column(Comment; Comment)
{
IncludeCaption = true;
}
}
}
add(/Sales Line/)
{
column(Description2; /Description 2/)
{
IncludeCaption = true;
}
column(Item_Reference_No_; /Item Reference No./)
{
IncludeCaption = true;
}
}
addlast(/Sales Line/)
{
dataitem(Item; Item)
{
DataItemLink = /No./ = field(/No./);
DataItemTableView = sorting(/No./);
column(Base_Unit_of_Measure; /Base Unit of Measure/)
{
}
}
}
}
}
Categories:
All responses (
Answers (
