CribMaster +T73iUgA2cVFWuXc+djqKt7EwSjFUdPB8l31nMMspNfEEpspYkvzzWtN7dzkAOoPgFrZAk1Me23ie3HMw2zqZ9944YnGTnudalv1BPnEop/CyHEDxkx73e1N7b3kfWnnw1bfiFtNk8hsTYQ= CribMaster ItemClassUsage TransDate,System.DateTime SiteID,System.String Item,System.String ItemClass,System.String Description1,System.String TypeDescription,System.String Cost,System.Decimal Quantity,System.Int32 CostSum,System.Decimal QtySum,System.Int32 30 ItemClassUsage CribMaster pFromDate,Dates.From,31,0 pToDate,Dates.To,31,0 pItemClass,_x0022_Boring_x0020_Bars_x0022_,23,0 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 (ItemClass = @pItemClass) AND {vConsignment} ,Dates,Dates,Transaction_x0020_Date_x0020_Range,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0031__x005F_x002F_1_x005F_x002F_2010_x005F_x0020_12:00:00_x005F_x0020_PM_x002C__x005F_x0034__x005F_x002F_1_x005F_x002F_2014_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__x000D__x000A_,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 28be28ca071148619e64f3d899fee262 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 8b1be79073ad44d0b71b1bd31af419ab 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,9.02,0.3 Flaxen_Report_Title1 Arial,14,Bold Center 0,0,0,0 ReportTitleText Usage by Item Class [193:152:89] Expression None;[143:102:102];1;Solid;False;4;Black;True Transparent 0,0.3,9,0.2 Arial,8,Bold c6cff9dbd2504180be76f17201c6b49e Center 0,0,0,0 Text10 Item Class: {ItemClassUsage.Parameters["pItemClass"].ParameterValue} | Dates: {Format("{0:MM/dd/yy}", ItemClassUsage.Parameters["pFromDate"].ParameterValue)} - {Format("{0:MM/dd/yy}", ItemClassUsage.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 MM/dd/yy Expression ReportTitle

Transparent 0,1.2,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] True 0,0,1.2,0.2 Flaxen_Header1 Arial,8,Bold True 0,0,0,0 HeaderText1 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 1.9,0,1.1,0.2 Flaxen_Header1 Arial,8,Bold True 0,0,0,0 HeaderText2 Item [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,0,2.6,0.2 Flaxen_Header1 Arial,8,Bold True 0,0,0,0 HeaderText3 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 1.2,0,0.7,0.2 Flaxen_Header1 Arial,8,Bold True 0,0,0,0 HeaderText4 Type [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 5.6,0,1.7,0.2 Flaxen_Header1 Arial,8,Bold True Right 0,0,0,0 HeaderText5 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 7.3,0,1.7,0.2 Flaxen_Header1 Arial,8,Bold True Right 0,0,0,0 HeaderText6 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,0,9,0.2 Flaxen_Header1 Arial,8,Bold 0,0,0,0 Text8 SiteID: {ItemClassUsage.SiteID} [193:152:89] Expression Center {ItemClassUsage.SiteID} GroupHeaderBand1 Transparent 0,2.4,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black Transparent True 0,0,1.2,0.2 Flaxen_Data1 Arial,8 True 0,0,0,0 DataText1 {ItemClassUsage.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 1.9,0,1.1,0.2 Flaxen_Data1 Arial,8 True 0,0,0,0 DataText2 {ItemClassUsage.Item} [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 3,0,2.6,0.2 Flaxen_Data1 Arial,8 True 0,0,0,0 DataText3 {ItemClassUsage.Description1} [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 1.2,0,0.7,0.2 Flaxen_Data1 Arial,8 True 0,0,0,0 DataText4 {ItemClassUsage.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 5.6,0,1.7,0.2 Flaxen_Data1 Arial,8 True Right 0,0,0,0 DataText5 {ItemClassUsage.CostSum} [193:152:89] , 0 0 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 7.3,0,1.7,0.2 Flaxen_Data1 Arial,8 True Right 0,0,0,0 DataText6 {ItemClassUsage.QtySum} [193:152:89] 0 , 1 False HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Wysiwyg Expression Center Left;[143:102:102];1;Solid;False;4;Black White 9,0,1.22,0.3 Arial,8,Bold 0,0,0,0 Text1 Black Expression ItemClassUsage Flaxen_Data1_Even Style Data Flaxen_Data1_Odd Style ASC TransDate ASC Item Transparent 0,3,10.22,0.2 All;[143:102:102];1;Solid;False;4;Black;True [242:234:221] True 5.6,0,1.7,0.2 Flaxen_Header1 Arial,8,Bold True 71711bc55844457a850400fe9a153d7e Right 0,0,0,0 Text11 {Sum(ItemClassUsage.CostSum)} [193:152:89] , 0 0 False 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 [242:234:221] True 7.3,0,1.7,0.2 Flaxen_Footer1 Arial,8 True 011d48034ca843889cb1ea82f6386ec7 Right 0,0,0,0 Text12 {Sum(ItemClassUsage.QtySum)} [193:152:89] 0 , 1 False 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;True [242:234:221] 0,0,5.6,0.2 Flaxen_Header1 Arial,8,Bold 7b029ee135c14442a8000ba3c64a833f Right 0,0,0,0 Text13 {ItemClassUsage.SiteID + " Total"} [193:152:89] Expression Center GroupFooterBand1 ce59ebe3ff4648d7b9179fd3e7ac51d8 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:28:30 AM 1/21/2014 2:51:28 PM C:\_CorporateProjects\Main\Web\Main\CMWeb\CMWeb\Content\Reports\ItemClassUsage.mrt 99668971ed894390a748c6497c617edd 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]