How to add picture of Item in Sales Order Report

ali_khodr

Hello guys,

I would like to ask you how to add the picture of Items in Sales Order Report in Dynamics Nav 2009 R2.

Please help me, this is urgent and I will lose my job if I don't finish this job.

Good Luck

Savatage

If this task stops you from being fired then this link will be your best friend.
search.php

DRB

In report, In SalesLine-OnAfterGetRecord trigger you will find following code (if this is base report):


IF Type = 0 THEN BEGIN
"No." := '';
"Unit of Measure" := '';
"Line Amount" := 0;
"Inv. Discount Amount" := 0;
Quantity := 0;
END ELSE IF Type = Type::"G/L Account" THEN
"No." := '';

Add following code to above:

END ELSE IF Type=Type::Item THEN BEGIN
Item.GET("No." );
Item.CALCFIELDS("Picture");
END;

Declare Item as Record datatype with SubDatatype Item and add a picture box in section with SourceExpression: Item.Picture.