Hello All
i have developed a report for the inventory remaining stock. but in our item Master all of the items have Item category and Subcategory is there. but while running the Report those category details was coming only in some of the items.
how can we correct it?
ITem Master Categories are there
Out of the Report
///
/// Report ITEM WISE BY LOC (Stock) (ID 62015).
///
report 62015 " ITEM WISE BY LOC (Stock)"
{
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
DefaultRenderingLayout = LayoutName;
AllowScheduling = true;
// report is created for getting item/stock report for sales team and Stock Taking
dataset
{
dataitem(Item; Item)
{
DataItemTableView = where(Inventory = filter('>0'));
column(No; "No.")
{
}
column(UnitCost_Item; "Unit Cost")
{
}
column(UnitPrice_Item; "Unit Price")
{
}
column(Description; Description)
{ }
column(ShowPrice; ShowPrice)
{
}
dataitem(Item_Ledger_Entry; "Item Ledger Entry")
{
DataItemLink = "Item No." = field("No.");
column(ItemNo_Item_Ledger_Entry; "Item No.")
{
}
column(Location_Code; "Location Code")
{
}
column(ItemCategoryCode_Item_Ledger_Entry; "Item Category Code")
{
}
column(ItemParentCagetory_Item_Ledger_Entry; "Item Parent Cagetory ")
{
}
column(Remaining_Quantity; "Remaining Quantity")
{
}
}
}
}
requestpage
{
layout
{
area(Content)
{
group(GroupName)
{
field(ShowPrice; ShowPrice)
{
Caption = 'Show Price';
ApplicationArea = All;
}
}
}
}
}
rendering
{
layout(LayoutName)
{
Type = RDLC;
LayoutFile = '.\ReportLayouts\ITEMBYLOCATION1.rdl';
}
}
var
ShowPrice: Boolean;
}
