Dynamics Community Forum Thread Details

Report Extension Add Custom fields from other table to report dataset

So basically i am attempting to create a report extension for Pick Instructions report.

I am attempting to add the LotNo field to the Pick Instructions Report via ReportExtension. I am able to get columns added from the pre existing tables. I am using DataItemLink and dataitem to display the lot No. with the following code.

reportextension 50102 PickInstructionExt extends /Pick Instruction/
{
dataset
{

add(/Sales Line/)
{
column(itemNo1; /No./)
{
IncludeCaption = true;
}
}
addlast(/Sales Line/)
{
dataitem(/item/; /Item/)
{
DataItemLink = /No./ = FIELD(/No./);
column(itemNo2; /No./)
{
IncludeCaption = true;
}
dataitem(/Reservation Entry/; /Reservation Entry/)
{
DataItemLink = /Item No./ = FIELD(/No./);

column(LotNumber; /Lot No./)
{
IncludeCaption = true;
}
}
}
}

So the column I created being itemNo1 displays the No. however any column I try add in the addlast(/Sales Line/) always displays as blank. I added column itemNo2 to test to see if the issue is the way i linked from sales line to Lot No. However even the link from sales line to item and then grabbing the No. from item shows up blank.

I am updating the report using microsft report builder and it is showing the columns I added in datasets. I have tried dragging directly from that to the report where it uses =First(Fields!LotNumber.Value)
I have also tried =Fields!LotNumber.Value with no success. Currently im just trying to see if I can pull anything at all from a table that isnt already in the pick instructions report.

I dont even know where to debug any further haha

Categories:

Dynamics 365 Business Central

Quick Links