CribMaster 5X7L7UYYk4HiS73Y6iXhu8Nw2QLWV/O87X5N3GoYdQ/xcLWhTVrThctcrL3hmKQvxFbVCV9X451yTc296VRhv8Q6u+vlaNnIwgW9bOglYmPgQGUJT3F62U0T1QRNAKAT4nD/wtxP091rWpzcwwDre9xutc3dS/P8QlHN7GpMpBvEeEkrRkyx/GFG7Q== CribMaster ItemUsage ItemClass,System.String TypeDescription,System.String SiteID,System.String TransDate,System.DateTime Item,System.String Description1,Description,System.String CostSum,System.Decimal QtySum,System.Int32 30 ItemUsage CribMaster pToDate,Dates.To,31,0 pFromDate,Dates.From,31,0 pItemNumber,_x0022_x_x0022_,23,30 SELECT TransDate, SiteID, Item, ItemClass, Description1, TypeDescription, CostSum, QtySum FROM TRANSDay (nolock) WHERE (TypeDescription IN ('ADJUS', 'CANCL', 'COUNT', 'ISSRT', 'ISSUE', 'RETN', 'RETNW', 'SCRAP', 'SCRPR')) AND (Transdate >= @pFromDate AND TransDate < @pToDate) AND (Item = @pItemNumber) AND {vConsignment} ,Dates,Dates,Transaction_x0020_Date_x0020_Range,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031_0_x005F_x002F_1_x005F_x002F_2012_x005F_x0020_12:00:00_x005F_x0020_PM_x002C__x005F_x0034__x005F_x002F_1_x005F_x002F_2013_x005F_x0020_12:00:00_x005F_x0020_PM,False,False,True ,vConsignment,vConsignment,System.String,_x0028_1_x003D_1_x0020_or_x0020_Consignment_x0020__x003D__x0020_1_x0029_,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,7.42,10.22,0.3 None;[143:102:102];1;Solid;False;4;Black Transparent True 9.4,0.08,0.8,0.2 Arial,8,Bold bfb2deb9fa874ad1b16a13fbaf72f59a Right 0,0,0,0 Text2 {PageNofM} Black Expression None;[143:102:102];1;Solid;False;4;Black Transparent 0,0.08,1.4,0.2 Arial,8,Bold 9e4ced2429ca4919a7863f5716f04ef3 0,0,0,0 Text39 {Time} Black Expression PageFooterBand1 Transparent 0,0.2,10.22,0.6 None;[143:102:102];1;Solid;False;4;Black Transparent 0,0,10.22,0.3 Flaxen_Report_Title1 Arial,14,Bold Center 0,0,0,0 ReportTitleText Item Usage [193:152:89] Expression True None;[143:102:102];1;Solid;False;4;Black;True Transparent True 0,0.3,10.1,0.2 Arial,8,Bold Center 0,0,0,0 Text1 Item: {ItemUsage.Parameters["pItemNumber"].ParameterValue} | Dates: {Format("{0:MM/dd/yy}", ItemUsage.Parameters["pFromDate"].ParameterValue)} - {Format("{0:MM/dd/yy}", ItemUsage.Parameters["pToDate"].ParameterValue)} | Consignment: {Switch(vConsignment == "(1=1 or Consignment = 1)", "All Items",vConsignment == "(Consignment = 1)", "Consignment Only",vConsignment == "(Consignment is null or consignment = 0)", "Non Consignment Only")} Black Expression ReportTitle

Transparent 0,1.2,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] True 1.3,0,0.9,0.2 Flaxen_Header1 Arial,8,Bold True 0,0,0,0 HeaderText2 Description [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] True 0,0,1.3,0.2 Flaxen_Header1 Arial,8,Bold True 0,0,0,0 HeaderText4 TransDate [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] True 2.2,0,1.2,0.2 Flaxen_Header1 Arial,8,Bold True Right 0,0,0,0 HeaderText6 Cost [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] True 3.4,0,1.2,0.2 Flaxen_Header1 Arial,8,Bold True Right 0,0,0,0 HeaderText7 Quantity [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Header

Transparent 0,1.8,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] 0.4,0,4.2,0.2 Flaxen_Header1 Arial,8,Bold 0,0,0,0 Text8 {ItemUsage.SiteID} [193:152:89] Center All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] 0,0,0.4,0.2 Flaxen_Header1 Arial,8,Bold 0,0,0,0 Text9 SiteID: [193:152:89] Expression Center {ItemUsage.SiteID} GroupHeaderBand1 Transparent 0,2.4,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black Transparent True 1.3,0,0.9,0.2 Flaxen_Data1 Arial,8 True 0,0,0,0 DataText2 {ItemUsage.TypeDescription} [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center All;[143:102:102];1;Solid;False;4;Black Transparent True 0,0,1.3,0.2 Flaxen_Data1 Arial,8 True 0,0,0,0 DataText4 {ItemUsage.TransDate} [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center All;[143:102:102];1;Solid;False;4;Black Transparent True 2.2,0,1.2,0.2 Flaxen_Data1 Arial,8 True Right 0,0,0,0 DataText6 {ItemUsage.CostSum} [193:152:89] , 1 HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center All;[143:102:102];1;Solid;False;4;Black Transparent True 3.4,0,1.2,0.2 Flaxen_Data1 Arial,8 True Right 0,0,0,0 DataText7 {ItemUsage.QtySum} [193:152:89] HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg DataColumn Center Left;[143:102:102];1;Solid;False;4;Black White 4.6,0,5.62,0.2 Arial,8,Bold 0,0,0,0 Text3 Black Expression ItemUsage Flaxen_Data1_Even Style Data Flaxen_Data1_Odd Style ASC TransDate Transparent 0,3,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black [242:234:221] 2.2,0,1.2,0.2 Flaxen_Footer1 Arial,8 Right 0,0,0,0 Text10 {Sum(ItemUsage.CostSum)} [193:152:89] , 1 False Expression All;[143:102:102];1;Solid;False;4;Black [242:234:221] 3.4,0,1.2,0.2 Flaxen_Footer1 Arial,8 9405afaba6af45eb933238b744a48d2e Right 0,0,0,0 Text11 {Sum(ItemUsage.QtySum)} [193:152:89] 0 , 1 False Expression All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] 0,0,2.2,0.2 Flaxen_Header1 Arial,8,Bold 922a847d02af44839be03fde6d478139 Right 0,0,0,0 Text6 {ItemUsage.SiteID + " Total"} [193:152:89] Expression Center GroupFooterBand1 be2ab2259d764b6cab83aae058b40231 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 2/19/2014 11:29:12 AM 1/21/2014 10:08:14 AM C:\_CorporateProjects\Main\Web\Main\CMWeb\CMWeb\Content\Reports\ItemUsage.mrt 0c91aeb1e82f4a88b47aa02ef4b9142b Report Inches 2014.1.1810 CSharp None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image ReportTitle ComponentType, Placement, PlacementNestedLevel Arial,14,Bold Flaxen_Report_Title1 [193:152:89] None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image GreaterThanOrEqualTo ReportTitle 2 ComponentType, Placement, PlacementNestedLevel Arial,10,Bold Flaxen_Report_Title2 [193:152:89] None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image ReportSummary ComponentType, Placement Arial,10,Bold Flaxen_Report_Summary [193:152:89] None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image PageHeader ComponentType, Placement Arial,10 Flaxen_Page_Header [193:152:89] None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image PageFooter ComponentType, Placement Arial,10 Flaxen_Page_Footer [193:152:89] None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image GreaterThanOrEqualTo GroupHeader ComponentType, Placement, PlacementNestedLevel Arial,13,Bold Flaxen_Group_Header1 [193:152:89] None;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image GroupFooter ComponentType, Placement, PlacementNestedLevel Arial,13,Bold Flaxen_Group_Footer1 [193:152:89] All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] Flaxen Text, Primitive, Image GreaterThanOrEqualTo Header ComponentType, Placement, PlacementNestedLevel Arial,8,Bold Flaxen_Header1 [193:152:89] All;[143:102:102];1;Solid;False;4;Black Transparent Flaxen Text, Primitive, Image, CheckBox GreaterThanOrEqualTo Data ComponentType, Placement, PlacementNestedLevel Arial,8 Flaxen_Data1 [193:152:89] None;[143:102:102];1;Solid;False;4;Black White Flaxen GreaterThanOrEqualTo DataOddStyle Placement, PlacementNestedLevel Arial,8 Flaxen_Data1_Odd Style [193:152:89] None;[143:102:102];1;Solid;False;4;Black [240:237:232] Flaxen GreaterThanOrEqualTo DataEvenStyle Placement, PlacementNestedLevel Arial,8 Flaxen_Data1_Even Style [193:152:89] All;[143:102:102];1;Solid;False;4;Black [242:234:221] Flaxen Text, Primitive, Image Footer ComponentType, Placement, PlacementNestedLevel Arial,8 Flaxen_Footer1 [193:152:89]