How about something like this? I got this a long time ago from someone on the community - so - who ever first wrote this - much thanks.
//--- Report Summary --- //
Begin ReportSummary
ReportType = reporttypeSales
ReportTitle = "12 Month Unit Sales"
PageOrientation = pageorientationLandscape
WordWrap = False
ShowDateTimePicker = False
OutLineMode = True
Groups = 1
GroupDescription = ""
DisplayLogo = True
LogoFileName = "MyLogo.bmp"
ProcedureCall = ""
PreQuery1 = "IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'ViewItemMovementHistory') DROP VIEW ViewItemMovementHistory"
PreQuery2 = <BEGIN>
CREATE VIEW ViewItemMovementHistory AS
Select Item.ItemLookupCode, ItemClass.ItemLookupCode as ClassILC, ItemClass.Description as ClassDesc,
Item.Description, Item.Quantity, Item.QuantityCommitted, Item.ReorderPoint, Item.RestockLevel,
Item.subDescription1, Item.subDescription2, Item.subDescription3, Item.Inactive,
(SELECT SUM(PurchaseOrderEntry.QuantityOrdered-PurchaseOrderEntry.QuantityReceivedToDate)
FROM PurchaseOrderEntry WHERE PurchaseOrderEntry.ItemID = Item.ID) AS OnOrder,
[Transaction].Time as Date, Department.ID as Department, Category.ID as Category, Supplier.ID as Supplier,
SupplierList.ReorderNumber,
CASE WHEN ((cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 AND (cast(DatePart(mm,GetDate()) as int) - cast(DatePart(mm,[Transaction].Time) as int)) < 0) OR (cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) AND (cast(DatePart(mm,GetDate()) as int) - cast(DatePart(mm,[Transaction].Time)as int)) > -1) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END AS MAT,
CASE WHEN ((cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 AND (cast(DatePart(mm,GetDate()) as int) - cast(DatePart(mm,[Transaction].Time) as int)) < 0) OR (cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) AND (cast(DatePart(mm,GetDate()) as int) - cast(DatePart(mm,[Transaction].Time)as int)) > -1) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END AS MATSales,
CASE WHEN ((cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 AND (cast(DatePart(mm,GetDate()) as int) - cast(DatePart(mm,[Transaction].Time) as int)) < 0) OR (cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) AND (cast(DatePart(mm,GetDate()) as int) - cast(DatePart(mm,[Transaction].Time)as int)) > -1) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END AS MATCost,
CASE WHEN (cast(DatePart(Mm,[Transaction].Time) as int) - cast(DatePart(Mm,GetDate()) as int) <= 0) AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as YTD,
CASE WHEN (cast(DatePart(Mm,[Transaction].Time) as int) - cast(DatePart(Mm,GetDate()) as int) <= 0) AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as TotalSales,
CASE WHEN (cast(DatePart(Mm,[Transaction].Time) as int) - cast(DatePart(Mm,GetDate()) as int) <= 0) AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as TotalCost,
CASE WHEN (cast(DatePart(Mm,[Transaction].Time) as int) - cast(DatePart(Mm,GetDate()) as int) <= 0) AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYTD,
CASE WHEN (cast(DatePart(Mm,[Transaction].Time) as int) - cast(DatePart(Mm,GetDate()) as int) <= 0) AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYTotalSales,
CASE WHEN (cast(DatePart(Mm,[Transaction].Time) as int) - cast(DatePart(Mm,GetDate()) as int) <= 0) AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYTotalCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) = cast(DatePart(Mm,GetDate()) as int) AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) AND cast(DatePart(dd,GetDate()) as int) >= cast(DatePart(dd,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as MTD,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) = cast(DatePart(Mm,GetDate()) as int) AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) AND cast(DatePart(dd,GetDate()) as int) >= cast(DatePart(dd,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as MonthSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) = cast(DatePart(Mm,GetDate()) as int) AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) AND cast(DatePart(dd,GetDate()) as int) >= cast(DatePart(dd,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as MonthCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) = cast(DatePart(Mm,GetDate()) as int) AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYM,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) = cast(DatePart(Mm,GetDate()) as int) AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYMonthSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) = cast(DatePart(Mm,GetDate()) as int) AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYMonthCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '1' AND '1' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Jan,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '1' AND '1' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYJan,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '1' AND '1' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as JanSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '1' AND '1' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as JanCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '1' AND '1' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYJanSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '1' AND '1' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYJanCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '2' AND '2' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Feb,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '2' AND '2' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYFeb,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '2' AND '2' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as FebSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '2' AND '2' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as FebCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '2' AND '2' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYFebSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '2' AND '2' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYFebCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '3' AND '3' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Mar,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '3' AND '3' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYMar,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '3' AND '3' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as MarSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '3' AND '3' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as MarCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '3' AND '3' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYMarSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '3' AND '3' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYMarCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '4' AND '4' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Apr,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '4' AND '4' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYApr,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '4' AND '4' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as AprSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '4' AND '4' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as AprCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '4' AND '4' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYAprSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '4' AND '4' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYAprCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '5' AND '5' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as May,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '5' AND '5' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYMay,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '5' AND '5' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as MaySales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '5' AND '5' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as MayCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '5' AND '5' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYMaySales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '5' AND '5' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYMayCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '6' AND '6' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Jun,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '6' AND '6' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYJun,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '6' AND '6' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as JunSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '6' AND '6' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as JunCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '6' AND '6' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYJunSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '6' AND '6' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYJunCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '7' AND '7' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Jul,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '7' AND '7' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYJul,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '7' AND '7' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as JulSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '7' AND '7' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as JulCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '7' AND '7' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYJulSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '7' AND '7' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYJulCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '8' AND '8' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Aug,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '8' AND '8' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYAug,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '8' AND '8' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as AugSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '8' AND '8' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as AugCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '8' AND '8' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYAugSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '8' AND '8' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYAugCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '9' AND '9' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Sep,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '9' AND '9' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYSep,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '9' AND '9' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as SepSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '9' AND '9' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as SepCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '9' AND '9' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYSepSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '9' AND '9' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYSepCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '10' AND '10' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Oct,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '10' AND '10' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYOct,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '10' AND '10' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as OctSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '10' AND '10' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as OctCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '10' AND '10' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYOctSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '10' AND '10' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYOctCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '11' AND '11' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Nov,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '11' AND '11' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYNov,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '11' AND '11' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as NovSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '11' AND '11' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as NovCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '11' AND '11' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYNovSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '11' AND '11' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYNovCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '12' AND '12' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as Dec,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '12' AND '12' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY) ELSE 0 END as LYDec,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '12' AND '12' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as DecSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '12' AND '12' AND cast(DatePart(yy,GetDate()) as int) = cast(DatePart(yy,[Transaction].Time)as int) THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as DecCost,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '12' AND '12' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Price) ELSE 0 END as LYDecSales,
CASE WHEN cast(DatePart(Mm,[Transaction].Time) as int) BETWEEN '12' AND '12' AND (cast(DatePart(yy,GetDate()) as int) - cast(DatePart(yy,[Transaction].Time)as int)) = 1 THEN SUM(TRANSACTIONENTRY.QUANTITY * TransactionEntry.Cost) ELSE 0 END as LYDecCost
FROM
[transaction]
LEFT JOIN TRANSACTIONENTRY ON [TRANSACTION].TRANSACTIONNUMBER = TRANSACTIONENTRY.TRANSACTIONNUMBER
LEFT JOIN ITEM ON TRANSACTIONENTRY.ITEMID = ITEM.ID
LEFT JOIN DEPARTMENT ON ITEM.DEPARTMENTID = DEPARTMENT.ID
LEFT JOIN CATEGORY ON ITEM.CATEGORYID = CATEGORY.ID
LEFT JOIN SUPPLIER ON ITEM.SUPPLIERID = SUPPLIER.ID
LEFT JOIN SUPPLIERLIST ON SUPPLIERLIST.SUPPLIERID = SUPPLIER.ID AND SUPPLIERLIST.ITEMID = ITEM.ID
LEFT JOIN ITEMCLASSCOMPONENT ON ITEM.ID = ITEMCLASSCOMPONENT.ITEMID
LEFT JOIN ITEMCLASS ON ITEMCLASSCOMPONENT.ITEMCLASSID = ITEMCLASS.ID
GROUP BY
Item.ID, Item.ItemLookupCode, Item.Description, [Transaction].Time, Department.ID, Category.ID,
Supplier.ID, SupplierList.ReorderNumber, Item.Quantity, Item.QuantityCommitted, ItemClass.ItemLookupcode,
ItemClass.Description, Item.ReorderPoint, Item.RestockLevel, Item.subDescription1, Item.subDescription2,
Item.subDescription3, Item.Inactive
<END>
TablesQueried = "FROM ViewItemMovementHistory LEFT JOIN Department ON ViewItemMovementHistory.Department = Department.ID LEFT JOIN Category ON ViewItemMovementHistory.Category = Category.ID LEFT JOIN Supplier ON ViewItemMovementHistory.Supplier = Supplier.ID"
SelCriteria = ""
GroupBy = "ViewItemMovementHistory.ItemLookupCode, ViewItemMovementHistory.Description, Department.Name, Category.Name, Supplier.SupplierName, ViewItemMovementHistory.ReorderNumber, ViewItemMovementHistory.Quantity, ViewItemMovementHistory.Quantitycommitted, ViewItemMovementHistory.OnOrder, ViewItemMovementHistory.ClassILC, ViewItemMovementHistory.ClassDesc, ViewItemMovementHistory.ReorderPoint, ViewItemMovementHistory.RestockLevel, ViewItemMovementHistory.subDescription1, ViewItemMovementHistory.subDescription2, ViewItemMovementHistory.subDescription3, ViewItemMovementHistory.Inactive"
SortOrder = ""
End ReportSummary
//--- Title Rows ---//
Begin TitleRow
Text = "<Store Name>"
Font = "Arial"
FontBold = True
FontSize = 16
Color = "Blue"
End TitleRow
Begin TitleRow
Text = "<Report Title>"
Font = "Arial"
FontBold = True
FontSize = 12
Color = "Black"
End TitleRow
Begin TitleRow
Text = "Generated On <Report Date>"
Font = "Arial"
FontBold = True
FontSize = 10
Color = "Black"
End TitleRow
//--- Filters ---//
Begin Filter
FieldName = "ViewItemMovementHistory.Date"
FilterOp = reportfilteropBetween
FilterLoLim = "<YearStart>"
FilterHilim = "<Today>"
FilterConnector = reportfilterbooleanconAND
End Filter
//--- Columns ---//
Begin Column
FieldName = "Department.Name"
DrillDownFieldName = "Department.Name"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Department"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1395
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.ItemLookupCode"
DrillDownFieldName = "Item.ItemLookupCode"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Item Lookup Code"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1395
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ILC"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Class ILC/Description"
VBDataType = vbString
Formula = "ViewItemMovementHistory.ClassILC + '/' + ViewItemMovementHistory.ClassDesc"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2000
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.Description"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Item Description"
VBDataType = vbString
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2550
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.ClassDesc"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Class Description"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 2550
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.subDescription1"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "!CaptionItemSubDescription1"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1000
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "ViewItemMovementHistory.subDescription2"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "!CaptionItemSubDescription2"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1000
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "ViewItemMovementHistory.subDescription3"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "!CaptionItemSubDescription3"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1000
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "ViewItemMovementHistory.ReorderNumber"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Reorder #"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1000
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignLeftCenter
End Column
Begin Column
FieldName = "ViewItemMovementHistory.Inactive"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "InActive"
VBDataType = vbBoolean
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 900
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCenter
End Column
Begin Column
FieldName = "Avail"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Avail"
VBDataType = vbLong
Formula = "ViewItemMovementHistory.Quantity - ViewItemMovementHistory.QuantityCommitted"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 615
GroupMethod = GroupMethodSum
ColFormat = ""
End Column
Begin Column
FieldName = "OnOrder"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "On Order"
VBDataType = vbLong
Formula = "CASE WHEN ViewItemMovementHistory.OnOrder > 0 THEN ViewItemMovementHistory.OnOrder ELSE 0 END"
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 800
GroupMethod = GroupMethodSum
ColFormat = ""
End Column
Begin Column
FieldName = "Category.Name"
DrillDownFieldName = "Category.Name"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Category"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1395
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "Supplier.SupplierName"
DrillDownFieldName = "Supplier.SupplierName"
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Supplier"
VBDataType = vbString
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1395
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.ReorderPoint"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "ReOrder Pt"
VBDataType = vblong
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 465
GroupMethod = groupmethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.RestockLevel"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Restock Lvl"
VBDataType = vblong
Formula = ""
ColHidden = True
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 465
GroupMethod = groupmethodNone
ColFormat = ""
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Jan"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Jan) <> 0 THEN SUM(ViewItemMovementHistory.Jan) ELSE SUM(ViewItemMovementHistory.LYJan) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Feb"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Feb) <> 0 THEN SUM(ViewItemMovementHistory.Feb) ELSE SUM(ViewItemMovementHistory.LYFeb) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Mar"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Mar) <> 0 THEN SUM(ViewItemMovementHistory.Mar) ELSE SUM(ViewItemMovementHistory.LYMar) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Apr"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Apr) <> 0 THEN SUM(ViewItemMovementHistory.Apr) ELSE SUM(ViewItemMovementHistory.LYApr) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "May"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.May) <> 0 THEN SUM(ViewItemMovementHistory.May) ELSE SUM(ViewItemMovementHistory.LYMay) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Jun"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Jun) <> 0 THEN SUM(ViewItemMovementHistory.Jun) ELSE SUM(ViewItemMovementHistory.LYJun) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Jul"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Jul) <> 0 THEN SUM(ViewItemMovementHistory.Jul) ELSE SUM(ViewItemMovementHistory.LYJul) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Aug"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Aug) <> 0 THEN SUM(ViewItemMovementHistory.Aug) ELSE SUM(ViewItemMovementHistory.LYAug) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty2"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Sep"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Sep) <> 0 THEN SUM(ViewItemMovementHistory.Sep) ELSE SUM(ViewItemMovementHistory.LYSep) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty2"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Oct"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Oct) <> 0 THEN SUM(ViewItemMovementHistory.Oct) ELSE SUM(ViewItemMovementHistory.LYOct) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty2"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Nov"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Nov) <> 0 THEN SUM(ViewItemMovementHistory.Nov) ELSE SUM(ViewItemMovementHistory.LYNov) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty2"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Dec"
VBDataType = vbDouble
Formula = "CASE WHEN SUM(ViewItemMovementHistory.Dec) <> 0 THEN SUM(ViewItemMovementHistory.Dec) ELSE SUM(ViewItemMovementHistory.LYDec) END"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 465
GroupMethod = GroupMethodSum
ColFormat = "###"
End Column
Begin Column
FieldName = "qty"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Ttl"
VBDataType = vbLong
Formula = "SUM(ViewItemMovementHistory.MAT)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = True
ColWidth = 500
GroupMethod = GroupMethodSum
ColFormat = ""
End Column
Begin Column
FieldName = "ViewItemMovementHistory.Date"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Date"
VBDataType = vbDate
Formula = ""
ColHidden = True
ColNotDisplayable = True
FilterDisabled = False
ColWidth = 5
GroupMethod = GroupMethodNone
ColFormat = ""
End Column
