LTS_RG_Data 9GpPoUNKe6R/Sej0zoTkF4ssyy5NXJPdaXu53GpEZRvRaM2h137riGl/5exqXPZz1GT360hKS53iQbm9aly1n9ZY0WhnZMOB LTS_RG_Data DrillsHorizontal ActualToolName,System.String DateCreated,System.DateTime Diameter,System.Double DiameterOffset,System.Double DrillBitType,System.Int64 EntrySpeed,System.Double Face,System.Int64 Face1Offset,System.String Face1ToolName,System.String Face2Offset,System.String Face2ToolName,System.String Face3Offset,System.String Face3ToolName,System.String Face4Offset,System.String Face4ToolName,System.String FeedSpeed,System.Double HeightOffset,System.Double ID,System.Int64 IsAssociative,System.String LinkID,System.String LinkIDCategory,System.String LinkIDPart,System.String MachineUse,System.Int64 MaxX,System.Double MaxY,System.Double MinX,System.Double MinY,System.Double Modified,System.String Name,System.String NoDowel,System.String PeckingNumber,System.Int64 Rotation,System.Double RotationSpeed,System.Double Sequence,System.Int64 ToolNumber,System.String ToolPriorityNumber,System.Int64 ToolType,System.Int64 X,System.Double Y,System.Double Z,System.Double 30 DrillsHorizontal LTS_RG_Data select * from DrillsHorizontal DrillsVertical ActualToolName,System.String DateCreated,System.DateTime Diameter,System.Double DiameterOffset,System.Double DrillBitType,System.Int64 EntrySpeed,System.Double Face,System.Int64 FeedSpeed,System.Double HeightOffset,System.Double ID,System.Int64 IsAssociative,System.String LinkID,System.String LinkIDCategory,System.String LinkIDParentDrill,System.String LinkIDPart,System.String MachineUse,System.Int64 MaxX,System.Double MaxY,System.Double MinX,System.Double MinY,System.Double Modified,System.String Name,System.String PeckingNumber,System.Int64 Rotation,System.Double RotationSpeed,System.Double Sequence,System.Int64 ToolNumber,System.String ToolPriorityNumber,System.Int64 ToolType,System.Int64 UseRouter,System.String X,System.Double XOffset,System.Double Y,System.Double YOffset,System.Double Z,System.Double 30 DrillsVertical LTS_RG_Data select * from DrillsVertical Edgebanding Code,System.String Comments,System.String DateCreated,System.DateTime Face,System.Int64 Grain,System.Int64 HatchType,System.Int64 ID,System.Int64 InventoryAvailableQty,System.Double InventoryCurrentQty,System.Double InventoryMinQty,System.Double LinFt,System.Double LinkID,System.String LinkIDCategory,System.String LinkIDDefaultVendor,System.String LinkIDMaterial,System.String LinkIDPart,System.String LinkIDProduct,System.String LinkIDProject,System.String LinkIDSheetSize,System.String LinkIDSubAssembly,System.String MarkUp,System.Double Modified,System.String Name,System.String Quantity,System.Double SqFt,System.Double Thickness,System.Double Type,System.Int64 UnitType,System.Int64 VendorCost,System.Double WasteFactor,System.Double 30 Edgebanding LTS_RG_Data select * from Edgebanding ErrorMessages DateCreated,System.DateTime ID,System.Int64 LinkID,System.String LinkIDCategory,System.String LinkIDGCodeResult,System.String LinkIDProcessingStation,System.String Modified,System.String Name,System.String 30 ErrorMessages LTS_RG_Data select * from ErrorMessages FaceFrameImages DateCreated,System.DateTime ID,System.Int64 JPegName,System.String JPegStream,System.Byte[] LinkID,System.String LinkIDCategory,System.String LinkIDProduct,System.String Modified,System.String Name,System.String TiffName,System.String TiffStream,System.Byte[] Type,System.Int64 WMFName,System.String WMFStream,System.Byte[] 30 FaceFrameImages LTS_RG_Data select * from FaceFrameImages Hardware ActualToolName,System.String BasePoint,System.Int64 BasePointX,System.Double BasePointY,System.Double BasePointZ,System.Double BlockFileName,System.String Code,System.String Comments,System.String Comments2,System.String Comments3,System.String DateCreated,System.DateTime Depth,System.Double Diameter,System.Double DiameterOffset,System.Double EntrySpeed,System.Double Face,System.Int64 FeedSpeed,System.Double Grain,System.Int64 HatchType,System.Int64 Height,System.Double HeightOffset,System.Double ID,System.Int64 Index,System.Int64 InventoryAvailableQty,System.Double InventoryCurrentQty,System.Double InventoryMinQty,System.Double IsAssociative,System.String LinkID,System.String LinkIDCategory,System.String LinkIDDefaultVendor,System.String LinkIDEQPart,System.String LinkIDMaterial,System.String LinkIDPart,System.String LinkIDProduct,System.String LinkIDProject,System.String LinkIDSheetSize,System.String LinkIDSubAssembly,System.String LinkIDVendor,System.String MachineUse,System.Int64 MarkUp,System.Double MaxX,System.Double MaxY,System.Double MinX,System.Double MinY,System.Double Modified,System.String Name,System.String PartType,System.Int64 Quantity,System.Double Rotation,System.Double RotationSpeed,System.Double RotationX,System.Double RotationY,System.Double RotationZ,System.Double Sequence,System.Int64 Thickness,System.Double ToolNumber,System.String ToolPriorityNumber,System.Int64 ToolType,System.Int64 TotalQuantity,System.Double Type,System.Int64 UnitType,System.Int64 VendorCost,System.Double WasteFactor,System.Double Width,System.Double X,System.Double Y,System.Double Z,System.Double Comments1,Comments1,System.String,SubField_x0028_Hardware.Comments_x002C__x0027__x007C__x0027__x002C_1_x0029_ 30 Hardware LTS_RG_Data select * from Hardware MicrovellumSystem ApplicationVersion,System.String DateCreated,System.DateTime ID,System.Int64 LinkID,System.String Modified,System.String Name,System.String 30 MicrovellumSystem LTS_RG_Data select * from MicrovellumSystem NestScrap DateCreated,System.DateTime ID,System.Int64 IDScrap,System.Int64 Length,System.Double LinkID,System.String LinkIDCategory,System.String LinkIDNestScrapBin,System.String LinkIDWorkOrderBatch,System.String MaterialCode,System.String MaterialName,System.String Modified,System.String Name,System.String Quantity,System.Int64 Thickness,System.Double Width,System.Double 30 NestScrap LTS_RG_Data select * from NestScrap OptimizationResults AlreadyPrinted,System.String BorderCoordinates,System.Byte[] DateCreated,System.DateTime ID,System.Int64 Index,System.Int64 IsScrap,System.String LinkID,System.String LinkIDPart,System.String LinkIDSheet,System.String LinkIDStack,System.String LinkIDStrip,System.String LinkIDWorkOrderBatch,System.String OptimizedQuantity,System.Int64 OptimizerRotated,System.String PrintFlag,System.String TrueShapedLength,System.Double TrueShapedWidth,System.Double Type,System.Int64 XCoord,System.Double YCoord,System.Double 30 OptimizationResults LTS_RG_Data select * from OptimizationResults Parts AdjustedCutPartLength,System.Double AdjustedCutPartWidth,System.Double Barcode,System.String BasePoint,System.Int64 BasePointX,System.Double BasePointY,System.Double BasePointZ,System.Double Code,System.String Comments,System.String Comments2,System.String Comments3,System.String CutPartLength,System.Double CutPartWidth,System.Double DateCreated,System.DateTime DontIncludeRoutesinNestBorder,System.String DrawToken2DElv,System.String DrawToken3D,System.String DXFFileName,System.String EdgeNameBottom,System.String EdgeNameLeft,System.String EdgeNameRight,System.String EdgeNameTop,System.String Face6Barcode,System.String Face6FileName,System.String FileName,System.String FullFace6FileName,System.String FullFileName,System.String Grain,System.Int64 HatchType,System.Int64 HboreBarcodeLeft,System.String HboreBarcodeLower,System.String HboreBarcodeRight,System.String HboreBarcodeUpper,System.String HboreFileNameLeft,System.String HboreFileNameLower,System.String HboreFileNameRight,System.String HboreFileNameUpper,System.String ID,System.Int64 Index,System.Int64 InventoryAvailableQty,System.Double InventoryCurrentQty,System.Double InventoryMinQty,System.Double JPegStream,System.Byte[] Length,System.Double LinkID,System.String LinkIDCategory,System.String LinkIDDefaultVendor,System.String LinkIDEQPart,System.String LinkIDMaterial,System.String LinkIDProcessingStations,System.String LinkIDProduct,System.String LinkIDProject,System.String LinkIDSheetSize,System.String LinkIDSubAssembly,System.String LinkIDVendor,System.String MachinePoint,System.String MarkUp,System.Double MaterialCode,System.String MaterialName,System.String MaterialThickness,System.Double MaterialType,System.Int64 Modified,System.String Name,System.String OverridePartCutLength,System.Double OverridePartCutThickness,System.Double OverridePartCutWidth,System.Double PartType,System.Int64 PerfectGrainCaption,System.String PrintFlag,System.String Processed,System.String Quantity,System.Double RotationX,System.Double RotationY,System.Double RotationZ,System.Double Row_ID,System.Int64 RunFieldNameFace5,System.String RunFieldNameFace6,System.String Thickness,System.Double TiffStream,System.Byte[] TotalQuantity,System.Double Type,System.Int64 UnitType,System.Int64 VendorCost,System.Double WasteFactor,System.Double Width,System.Double WMFName,System.String WMFNameFace6,System.String WMFStream,System.Byte[] WMFStreamDimensioned,System.Byte[] WMFStreamFace6,System.Byte[] WMFStreamFace6Dimensioned,System.Byte[] 30 Parts LTS_RG_Data select * from Parts PlacedSheets Code,System.String Comments,System.String CPOUTNumber,System.Int64 DateCreated,System.DateTime Face6FileName,System.String FileName,System.String FullFace6FileName,System.String FullFileName,System.String Grain,System.Int64 HatchType,System.Int64 ID,System.Int64 Index,System.Int64 InventoryAvailableQty,System.Double InventoryCurrentQty,System.Double InventoryMinQty,System.Double JPegStream,System.Byte[] LeadingLengthTrim,System.Double LeadingWidthTrim,System.Double Length,System.Double LinkID,System.String LinkIDCategory,System.String LinkIDDefaultVendor,System.String LinkIDMaterial,System.String LinkIDProcessingStation,System.String LinkIDSheetSize,System.String LinkIDStack,System.String LinkIDSubType,System.String LinkIDWorkOrderBatch,System.String MarkUp,System.Double MaterialCost,System.Double Modified,System.String Name,System.String OptimizationPriority,System.Int64 OptimizationType,System.Int64 Quantity,System.Double Thickness,System.Double TiffStream,System.Byte[] TrailingLengthTrim,System.Double TrailingWidthTrim,System.Double Type,System.Int64 UnitType,System.Int64 WasteFactor,System.Double Width,System.Double WMFStream,System.Byte[] WMFStreamFace6,System.Byte[] 30 PlacedSheets LTS_RG_Data select * from PlacedSheets PlacedSheetsVendors ID,System.Int64 LinkIDMaterial,System.String LinkIDVendor,System.String 30 PlacedSheetsVendors LTS_RG_Data select * from PlacedSheetsVendors Products ActivityPath,System.String ActivityPathShort,System.String AncorType,System.Int64 Angle,System.Double Comments,System.String Comments1,System.String Comments2,System.String Comments3,System.String CopiedLinkIDList,System.String DateCreated,System.DateTime Depth,System.Double DoPerfectGrain,System.String DrawIndex,System.Int64 Extruded,System.String Height,System.Double ID,System.Int64 IsBuyOut,System.String ItemNumber,System.String JPegName,System.String JPegStream,System.Byte[] LinkID,System.String LinkIDCategory,System.String LinkIDLibrary,System.String LinkIDLocation,System.String LinkIDProductGroup,System.String LinkIDProject,System.String LinkIDRelease,System.String LinkIDSpecificationGroup,System.String LinkIDWall,System.String LinkIDWorkOrder,System.String Modified,System.String Name,System.String PerfectGrainChar,System.String PrintFlag,System.String Quantity,System.Int64 QuoteName,System.String RoomComponentType,System.Int64 RoomName,System.String Row_ID,System.Int64 ShippingTicketName,System.String TiffName,System.String TiffStream,System.Byte[] Type,System.Int64 UITreeFilter,System.Int64 Width,System.Double WMFName,System.String WMFStream,System.Byte[] WorkBook,System.Byte[] WorkOrderName,System.String X,System.Double Y,System.Double Z,System.Double 30 Products LTS_RG_Data select * from Products ProductsPrompts ID,System.Int64 LinkIDProduct,System.String LinkIDPrompt,System.String LinkIDSubassembly,System.String 30 ProductsPrompts LTS_RG_Data select * from ProductsPrompts Prompts ControlType,System.Int64 DateCreated,System.DateTime HideOnReports,System.String ID,System.Int64 IsQuantity,System.String LinkID,System.String LinkIDCategory,System.String LinkIDProduct,System.String LinkIDSubassembly,System.String Modified,System.String Name,System.String Type,System.Int64 Value,System.String 30 Prompts LTS_RG_Data select * from Prompts Routes ActualToolName,System.String CenterX,System.Double CenterY,System.Double DateCreated,System.DateTime Diameter,System.Double DiameterOffset,System.Double DontDrawLead,System.String DontDrawLeadOut,System.String DoublePass,System.String EntrySpeed,System.Double Face,System.Int64 FeedSpeed,System.Double FirstVector,System.Int64 FromCreateBoundary,System.String HardwareZ,System.Double HeightOffset,System.Double ID,System.Int64 IncludedInNestRoute,System.String IntersX,System.Double IntersY,System.Double IsAssociative,System.String IsLastPass,System.String IsMultiRoute,System.String IsPocketRouter,System.String IsRegion,System.String IsSteppedRoute,System.String LastVector,System.Int64 LayerDepth,System.Double LayerOffset,System.Int64 LinkID,System.String LinkIDCategory,System.String LinkIDPart,System.String MachineUse,System.Int64 MacroString,System.String MaxX,System.Double MaxY,System.Double MinX,System.Double MinY,System.Double Modified,System.String Name,System.String Offset,System.Int64 PassNumber900Tool,System.Int64 PeckingNumber,System.Int64 Priority,System.Int64 Rotation,System.Double RotationAngle,System.Double RotationSpeed,System.Double RoughCutOffset,System.Double RouteNum,System.Int64 Sequence,System.Int64 SetMillBulge,System.Double SetMillBulgeDirection,System.Int64 shiftX,System.Double shiftY,System.Double Steps,System.Int64 ToolNumber,System.String ToolPriorityNumber,System.Int64 ToolProfile,System.String ToolType,System.Int64 UseRouter,System.String X,System.Double XOffset,System.Double Y,System.Double YOffset,System.Double Z,System.Double 30 Routes LTS_RG_Data select * from Routes SawCutLines DateCreated,System.DateTime Dimension,System.Double ID,System.Int64 IsHorizontal,System.String LinkID,System.String LinkIDCategory,System.String LinkIDPart,System.String LinkIDPlacedSheet,System.String Modified,System.String Name,System.String Phase,System.Int64 WayLength,System.Double XCoord,System.Double YCoord,System.Double 30 SawCutLines LTS_RG_Data select * from SawCutLines Saws ActualToolName,System.String DateCreated,System.DateTime Diameter,System.Double DiameterOffset,System.Double EndX,System.Double EndY,System.Double EndZ,System.Double EntrySpeed,System.Double Face,System.Int64 FeedSpeed,System.Double HeightOffset,System.Double ID,System.Int64 IsAssociative,System.String LayerDepth,System.Double LayerOffset,System.Int64 LinkID,System.String LinkIDCategory,System.String LinkIDPart,System.String MachineUse,System.Int64 MaxX,System.Double MaxY,System.Double MinX,System.Double MinY,System.Double Modified,System.String Name,System.String Offset,System.Int64 Rotation,System.Double RotationSpeed,System.Double Sequence,System.Int64 ToolNumber,System.String ToolPriorityNumber,System.Int64 ToolType,System.Int64 X,System.Double Y,System.Double Z,System.Double 30 Saws LTS_RG_Data select * from Saws SawStacks DateCreated,System.DateTime ID,System.Int64 LinkID,System.String LinkIDCategory,System.String MaterialName,System.String Modified,System.String Name,System.String StackHeight,System.Int64 30 SawStacks LTS_RG_Data select * from SawStacks Sheets Code,System.String Comments,System.String DatabaseTableNameType,System.Int64 DateCreated,System.DateTime Grain,System.Int64 HatchType,System.Int64 ID,System.Int64 Index,System.Int64 InventoryAvailableQty,System.Double InventoryCurrentQty,System.Double InventoryMinQty,System.Double LeadingLengthTrim,System.Double LeadingWidthTrim,System.Double Length,System.Double LinkID,System.String LinkIDCategory,System.String LinkIDDefaultVendor,System.String LinkIDMaterial,System.String LinkIDSheetSize,System.String LinkIDStack,System.String LinkIDSubType,System.String MarkUp,System.Double MaterialCost,System.Double Modified,System.String Name,System.String NumplacedParts,System.Int64 NumStrips,System.Int64 OptimizationPriority,System.Int64 Pattern,System.Int64 Picture,System.Byte[] PrintFlag,System.String Quantity,System.Double Thickness,System.Double TrailingLengthTrim,System.Double TrailingWidthTrim,System.Double Type,System.Int64 UnitType,System.Int64 UsableLength,System.Double UsableWidth,System.Double WasteFactor,System.Double Width,System.Double 30 Sheets LTS_RG_Data select * from Sheets Subassemblies ActivityPath,System.String ActivityPathShort,System.String Angle,System.Double BayPosition,System.Int64 Comments,System.String Comments1,System.String Comments2,System.String Comments3,System.String DateCreated,System.DateTime Depth,System.Double DrawIndex,System.Int64 Height,System.Double ID,System.Int64 IsBuyOut,System.String JPegName,System.String JPegStream,System.Byte[] LinkID,System.String LinkIDCategory,System.String LinkIDLibrary,System.String LinkIDParentProduct,System.String LinkIDParentSubassembly,System.String LinkIDProject,System.String Modified,System.String ModifiedRowID,System.Int64 Name,System.String PerfectGrainCaption,System.String Quantity,System.Int64 TiffName,System.String TiffStream,System.Byte[] Type,System.Int64 Width,System.Double WMFName,System.String WMFStream,System.Byte[] WorkBook,System.Byte[] X,System.Double Y,System.Double Z,System.Double 30 Subassemblies LTS_RG_Data select * from Subassemblies Vectors ActualToolName,System.String Bulge,System.Double BulgeDirection,System.Int64 CenterX,System.Double CenterY,System.Double DateCreated,System.DateTime Diameter,System.Double DiameterOffset,System.Double EntrySpeed,System.Double Face,System.Int64 FeedSpeed,System.Double HeightOffset,System.Double ID,System.Int64 IsAssociative,System.String LinkID,System.String LinkIDCategory,System.String LinkIDPart,System.String LinkIDRoute,System.String MachineUse,System.Int64 MaxX,System.Double MaxY,System.Double MinX,System.Double MinY,System.Double Modified,System.String Name,System.String Radius,System.Double Rotation,System.Double RotationSpeed,System.Double Sequence,System.Int64 ToolNumber,System.String ToolPriorityNumber,System.Int64 ToolType,System.Int64 VectorIndex,System.Int64 X,System.Double Y,System.Double Z,System.Double 30 Vectors LTS_RG_Data select * from Vectors WorkOrderBatches DateCreated,System.DateTime ID,System.Int64 LinkID,System.String Name,System.String 30 WorkOrderBatches LTS_RG_Data select * from WorkOrderBatches Products LinkIDProduct Products Products-Hardware LinkID Subassemblies LinkIDSubAssembly LinkIDProduct Subassemblies Subassemblies-Hardware LinkID LinkIDParentProduct ,KeyNumberStingVar,KeyNumberStingVar,System.String,,False,False LTS_RG_Variables,LTS_Units,LTS_Units,System.Int32,_x0030_,False,False ,indexFunc,indexFunc,Incremented_x0020_with_x0020_each_x0020_detail_x002C__x0020_used_x0020_for_x0020_substring_x0020_and_x0020_QTY_x0020_Count,System.Int32,,False,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,4,196,0 {Hardware.Name} GroupHeaderBand1 KeyNumberStingVar = KeyNumberStingVar + ";" + Hardware.Comments1; ; foreach (string item in Hardware.Comments1.Split(';')) { if (!ht.ContainsKey(item)) { ht.Add(item, 1); } else { ht[item] = ((int)ht[item]) + 1; } }; Transparent 0,12,196,4 Transparent 38,0,32,4 Arial Narrow,9 0,0,0,0 Text2 {Hardware.Name} Black Transparent 76,0,112,4 Arial Narrow,9 0,0,0,0 Text4 {Hardware.Comments1} Black Expression Transparent 0,0,16,4 Arial Narrow,9 0,0,0,0 Text5 {Hardware.Products.ItemNumber} Black Transparent 20,0,16,4 Normal Arial Narrow,10 0,0,0,0 Text10 {Hardware.Quantity*Hardware.Products.Quantity} Black Expression Hardware Comments,NotContaining,Machining_x0020_Only,,String Name,Containing,Lock,,String Name,NotContaining,Lock_x0020_Strike,,String Name,NotContaining,Lock_x0020_Cam,,String fd8f0de7c6b44efeb0a6ab809f5f37cb DataParts DataBand1.CountData = ht.Count; tmp = new int[ht.Count, 2]; int index = 0; foreach (System.Collections.DictionaryEntry item in ht) { tmp[index, 0] = int.Parse(item.Key.ToString()); tmp[index, 1] = int.Parse(item.Value.ToString()); index++; } Transparent 0,24,196,6 HeaderBand1 All;Black;1;Solid;False;4;Black Transparent 0,38,196,4 Transparent 12,0,32,4 Arial Narrow,9 8398c6e0594d4b8982422222773bbeee 0,0,0,0 Text1 {tmp[Line - 1, 0]} Black Expression Transparent 48,0,32,4 Arial Narrow,9 1e0ceee1e6ed46ac8e25b4fb00014b09 0,0,0,0 Text3 {tmp[Line - 1, 1]} Black Expression Hardware False 4e2c70fe629b40849a86da768719182f DataBand1 9a9c66def30a43c6853ed2be26b6f54f 10,10,10,10 Page1 279.4 216 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/22/2013 10:28:16 AM 5/25/2010 9:34:32 AM E:\Key Numbers_modified.mrt 667e29ca17ea4dff850f5d04f71990c8 Report Millimeters 2013.1.1509 CSharp Transparent For Standard Text Arial Narrow,10 Normal Black

Transparent For Header Text Arial Narrow,11,Bold Header Black

EmptyBrush For Report Title Text Verdana,16,Bold| Italic Report Title White Black Transparent For Page Header Text Verdana,10,Italic Page Header Black Transparent For Report Notes Text Verdana,6,Italic Report Notes Black Silver For Report Title Text Verdana,14,Bold| Italic Style1 Black Transparent Arial Narrow,10,Underline Hyperlink Blue Red For Report Title Text Verdana,16,Bold| Italic Report Title Red Black OrangeRed For Report Title Text Verdana,16,Bold| Italic Report Title Orange Black Yellow For Report Title Text Verdana,16,Bold| Italic Report Title Yellow Black Lime For Report Title Text Verdana,16,Bold| Italic Report Title Green Black DeepSkyBlue For Report Title Text Verdana,16,Bold| Italic Report Title Blue Black Plum For Report Title Text Verdana,16,Bold| Italic Report Title Pink Black DarkViolet For Report Title Text Verdana,16,Bold| Italic Report Title Purple Black DarkGray For Report Title Text Verdana,16,Bold| Italic Report Title Gray Black Red Arial Narrow,10,Underline Hyperlink Red Blue OrangeRed Arial Narrow,10,Underline Hyperlink Orange Blue Yellow Arial Narrow,10,Underline Hyperlink Yellow Blue Lime Arial Narrow,10,Underline Hyperlink Green Blue DeepSkyBlue Arial Narrow,10,Underline Hyperlink Blue Blue Plum Arial Narrow,10,Underline Hyperlink Pink Blue DarkViolet Arial Narrow,10,Underline Hyperlink Purple Blue DarkGray Arial Narrow,10,Underline Hyperlink Gray Blue