Hello All,
I m trying to create a custom report... in the report there is a custom table with a field LOGO datatype is Blob and subtype is Bitmap. Picture is saving properly in the page and showing but when I added the column in the report, it is not displaying the image. Please see the dataset where I am wrong.
report xxxxx "Temp Sales Invoice"
{
Caption = 'Temp Sales Invoice';
DefaultLayout = Word;
WordLayout = 'Layout/ReportTempSalesInvoice.docx';
PreviewMode = PrintLayout;
//Permissions = TableData "Sales Shipment Buffer" = rimd;
WordMergeDataItem = Header;
dataset
{
dataitem(Header; "Sales Invoice Header")
{
DataItemTableView = SORTING("No.");
RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed";
RequestFilterHeading = 'Posted Sales Invoice';
column(No_; "No.") { }
column(Sell_to_Customer_Name; "Sell-to Customer Name") { }
column(Document_Date; "Document Date") { }
column(Bill_to_Customer_No_; "Bill-to Customer No.") { }
dataitem(Shop; "Sales Invoice Line")
{
DataItemLink = "Document No." = FIELD("No.");
DataItemLinkReference = Header;
DataItemTableView = SORTING("Document No.", "Line No.");
column(ShopName; tempShop.Description) { }
column(ShopCode; tempShop.Code) { }
column(shopLogo; tempShop.Logo) { }
}
dataitem(Line; "Sales Invoice Line")
{
DataItemLink = "Document No." = FIELD("No.");
DataItemLinkReference = Header;
DataItemTableView = SORTING("Document No.", "Line No.");
column(LineNo_Line; "Line No.") { }
column(AmountExcludingVAT_Line; Amount) { }
}
trigger OnAfterGetRecord()
begin
if TempShop.Get("Webshop Code") then begin
TempShop.SetAutoCalcFields(Logo);
end;
end;
}
}
var
TempShop: Record "Web Shop";
}
