This is the whole al code of report
report 50004 "E01 Location Wise Enventory"
{
ApplicationArea = All;
Caption = 'E01 Location Wise Inventory';
UsageCategory = ReportsAndAnalysis;
DefaultLayout = RDLC;
RDLCLayout = './location_Wise_Inventory.rdl';
dataset
{
dataitem("Company Information"; "Company Information")
{
column(Company_Name; company_info.Name)
{
}
column(Company_Aderess; company_info.Address)
{ }
column(Company_Aderess_2; company_info."Address 2")
{ }
column(Company_Logo; company_info.Picture)
{ }
column(Company_PinCode; company_info."Post Code")
{ }
column(Company_Country; company_info."Country/Region Code")
{ }
column(Company_City; company_info.City)
{ }
column(Comapny_State; company_info."State Inscription")
{ }
}
dataitem(Item; Item)
{
column(Item_Category_Code; "Item Category Code")
{
}
column(No; "No.")
{
}
column(Description; Description)
{
}
column(Base_Unit_of_Measure; "Base Unit of Measure")
{
}
column(Unit_Price; "Unit Price")
{
}
}
dataitem("Item Ledger Entry"; "Item Ledger Entry")
{
DataItemLinkReference = Item;
DataItemLink = "Item No." = field("No.");
column(Location_Code; "Location Code")
{
}
column(Remaining_Quantity; "Remaining Quantity")
{
}
}
}
requestpage
{
layout
{
area(content)
{
group(groupname)
{
}
}
}
actions
{
area(processing)
{
}
}
}
trigger OnInitReport()
var
myInt: Integer;
begin
company_info.Get();
company_info.CalcFields(Picture);
end;
var
company_info: record "Company Information";
item_detail: Record Item;
item_ledger: Record "Item Ledger Entry";
}
