ReportName = PO and WO Analsys ReportGroup = Purchase Orders object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Porders NoDataBehaviors = [ndBlankReport] PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'PO and WO Analsys' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'HP LaserJet 1022' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'PO and WO Analsys' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'PO and WO Analsys.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True CachePages = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False Left = 218 Top = 155 Version = '10.07' mmColumnWidth = 0 DataPipelineName = 'Porders' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 22754 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'PO and WO Analsys' Font.Charset = DEFAULT_CHARSET Font.Color = 10040115 Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 4995 mmLeft = 1058 mmTop = 529 mmWidth = 200555 BandType = 0 end object ppDBText16: TppDBText UserName = 'DBText16' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = 10040115 Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold] ParentDataPipeline = False TextAlignment = taCentered Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 4995 mmLeft = 1058 mmTop = 5292 mmWidth = 200555 BandType = 0 end object ppLabel3: TppLabel UserName = 'params' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'DateClosed: 2/28/2008- 2/28/2008' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 3344 mmLeft = 1058 mmTop = 10848 mmWidth = 200555 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Site' Font.Charset = DEFAULT_CHARSET Font.Color = 10040115 Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold, fsUnderline] TextAlignment = taCentered Transparent = True mmHeight = 4995 mmLeft = 2117 mmTop = 17992 mmWidth = 6816 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Vendor' Font.Charset = DEFAULT_CHARSET Font.Color = 10040115 Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold, fsUnderline] TextAlignment = taCentered Transparent = True mmHeight = 4995 mmLeft = 24009 mmTop = 17992 mmWidth = 13631 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Employee' Font.Charset = DEFAULT_CHARSET Font.Color = 10040115 Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold, fsUnderline] TextAlignment = taCentered Transparent = True mmHeight = 4995 mmLeft = 69538 mmTop = 17992 mmWidth = 17822 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Unit' Font.Charset = DEFAULT_CHARSET Font.Color = 10040115 Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold, fsUnderline] TextAlignment = taCentered Transparent = True mmHeight = 4995 mmLeft = 93235 mmTop = 17992 mmWidth = 8001 BandType = 0 end end object ppDetailBand1: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 3969 mmPrintPosition = 0 object ppDBText6: TppDBText UserName = 'DBText6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Item' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 6350 mmTop = 265 mmWidth = 32544 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Quantity' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 41010 mmTop = 265 mmWidth = 8731 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Price' DataPipeline = daADOQueryDataView1.Porders DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 51329 mmTop = 265 mmWidth = 17198 BandType = 4 end object ppDBText9: TppDBText UserName = 'DBText9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Subtotal' DataPipeline = daADOQueryDataView1.Porders DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 69321 mmTop = 265 mmWidth = 17198 BandType = 4 end object ppDBText10: TppDBText UserName = 'DBText10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'WorkOrder' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 87842 mmTop = 265 mmWidth = 10848 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup1: TppGroup BreakName = 'Site' DataPipeline = daADOQueryDataView1.Porders OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Porders' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Site' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 2117 mmTop = 1588 mmWidth = 53181 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup2: TppGroup BreakName = 'Numbered' DataPipeline = daADOQueryDataView1.Porders OutlineSettings.CreateNode = True ReprintOnSubsequentPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Porders' object ppGroupHeaderBand2: TppGroupHeaderBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5821 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 5556 mmTop = 1323 mmWidth = 17198 BandType = 3 GroupNo = 1 end object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'VendorName' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 24606 mmTop = 1323 mmWidth = 46302 BandType = 3 GroupNo = 1 end object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'RequestedBy' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 72231 mmTop = 1323 mmWidth = 17198 BandType = 3 GroupNo = 1 end object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'UnitName' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3440 mmLeft = 91017 mmTop = 1323 mmWidth = 43127 BandType = 3 GroupNo = 1 end end object ppGroupFooterBand2: TppGroupFooterBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2117 mmLeft = 32544 mmTop = 529 mmWidth = 54240 BandType = 5 GroupNo = 1 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Item' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup2 TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'Porders' mmHeight = 3344 mmLeft = 32544 mmTop = 1323 mmWidth = 17198 BandType = 5 GroupNo = 1 end object ppSubReport1: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'WoMaster' mmHeight = 4233 mmLeft = 94192 mmTop = 529 mmWidth = 107421 BandType = 5 GroupNo = 1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.WoMaster PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'PO and WO Analsys' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'HP LaserJet 1022' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.SaveTo = stDatabase Template.Format = ftASCII Version = '10.07' mmColumnWidth = 0 DataPipelineName = 'WoMaster' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 4763 mmPrintPosition = 0 object ppLabel2: TppLabel UserName = 'Label2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Work Order Data' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsUnderline] Transparent = True mmHeight = 3440 mmLeft = 9790 mmTop = 794 mmWidth = 19844 BandType = 1 end end object ppDetailBand2: TppDetailBand mmBottomOffset = 0 mmHeight = 3969 mmPrintPosition = 0 object ppDBText11: TppDBText UserName = 'DBText11' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Description' DataPipeline = daADOQueryDataView2.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3344 mmLeft = 9790 mmTop = 0 mmWidth = 37306 BandType = 4 end object ppDBText12: TppDBText UserName = 'DBText12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Quantity' DataPipeline = daADOQueryDataView2.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 48419 mmTop = 0 mmWidth = 7408 BandType = 4 end object ppDBText13: TppDBText UserName = 'DBText13' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'UnitCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 57944 mmTop = 0 mmWidth = 14552 BandType = 4 end object ppDBText14: TppDBText UserName = 'DBText14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'SubTotal' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 74613 mmTop = 0 mmWidth = 17198 BandType = 4 end object ppDBText15: TppDBText UserName = 'DBText15' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView2.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3344 mmLeft = 93398 mmTop = 265 mmWidth = 11377 BandType = 4 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 7938 mmPrintPosition = 0 object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Description' DataPipeline = daADOQueryDataView2.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 38365 mmTop = 1058 mmWidth = 17198 BandType = 7 end object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 2910 mmLeft = 32015 mmTop = 265 mmWidth = 25135 BandType = 7 end end end end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Porders' Height = 371 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 286 AutoSearchTabOrder = 0 object Porders: TppChildDBPipeline AutoCreateFields = False UserName = 'Porders' object ppField1: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 0 TableName = 'Porders' end object ppField2: TppField FieldAlias = 'RequestedBy' FieldName = 'RequestedBy' FieldLength = 35 DisplayWidth = 10 Position = 1 TableName = 'Porders' end object ppField3: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 2 TableName = 'Porders' end object ppField4: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 DisplayWidth = 10 Position = 3 TableName = 'Porders' end object ppField5: TppField FieldAlias = 'VendorName' FieldName = 'VendorName' FieldLength = 50 DisplayWidth = 10 Position = 4 TableName = 'Porders' end object ppField6: TppField FieldAlias = 'PartNumber' FieldName = 'PartNumber' FieldLength = 50 IsDetail = True DisplayWidth = 10 Position = 5 TableName = 'Porders2' end object ppField7: TppField FieldAlias = 'Item' FieldName = 'Item' FieldLength = 60 IsDetail = True DisplayWidth = 10 Position = 6 TableName = 'Porders2' end object ppField8: TppField FieldAlias = 'Quantity' FieldName = 'Quantity' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 7 TableName = 'Porders2' end object ppField9: TppField FieldAlias = 'Price' FieldName = 'Price' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 8 TableName = 'Porders2' end object ppField10: TppField FieldAlias = 'Subtotal' FieldName = 'Subtotal' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 9 TableName = 'Porders2' end object ppField11: TppField FieldAlias = 'DateOrdered' FieldName = 'DateOrdered' FieldLength = 0 DataType = dtDateTime DisplayWidth = 10 Position = 10 TableName = 'Porders' end object ppField12: TppField FieldAlias = 'DateClosed' FieldName = 'DateClosed' FieldLength = 0 DataType = dtDateTime DisplayWidth = 10 Position = 11 TableName = 'Porders' end object ppField13: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 10 Position = 12 TableName = 'Porders' end object ppField14: TppField FieldAlias = 'WorkOrder' FieldName = 'WorkOrder' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 13 TableName = 'Porders2' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Porders' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Porders.Numbered, Porders.RequestedBy, ' ' Porders.Unit, Porders.UnitName, ' ' Porders.VendorName, Porders2.PartNumber, ' ' Porders2.Item, Porders2.Quantity, ' ' Porders2.Price, Porders2.Subtotal, ' ' Porders.DateOrdered, Porders.DateClosed, ' ' Porders.Site, Porders2.WorkOrder' 'FROM Porders Porders' ' INNER JOIN Porders2 Porders2 ON ' ' (Porders2.Joining = Porders.Joining)' 'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND (( Porders.Unit > 0 ))') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoGreaterThan Value = '0' object TdaField Alias = 'Unit' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Unit' FieldLength = 10 FieldName = 'Unit' Mandatory = True SQLFieldName = 'Unit' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object TdaNumericValue end end object daField1: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField2: TdaField Alias = 'RequestedBy' DisplayWidth = 10 FieldAlias = 'RequestedBy' FieldLength = 35 FieldName = 'RequestedBy' SQLFieldName = 'RequestedBy' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField3: TdaField Alias = 'Unit' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField4: TdaField Alias = 'UnitName' DisplayWidth = 10 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField5: TdaField Alias = 'VendorName' DisplayWidth = 10 FieldAlias = 'VendorName' FieldLength = 50 FieldName = 'VendorName' SQLFieldName = 'VendorName' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField6: TdaField Alias = 'PartNumber' DisplayWidth = 10 FieldAlias = 'PartNumber' FieldLength = 50 FieldName = 'PartNumber' IsDetail = True SQLFieldName = 'PartNumber' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField7: TdaField Alias = 'Item' DisplayWidth = 10 FieldAlias = 'Item' FieldLength = 60 FieldName = 'Item' IsDetail = True SQLFieldName = 'Item' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField8: TdaField Alias = 'Quantity' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Quantity' FieldLength = 5 FieldName = 'Quantity' IsDetail = True SQLFieldName = 'Quantity' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField9: TdaField Alias = 'Price' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Price' FieldLength = 5 FieldName = 'Price' IsDetail = True SQLFieldName = 'Price' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField10: TdaField Alias = 'Subtotal' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Subtotal' FieldLength = 2 FieldName = 'Subtotal' IsDetail = True SQLFieldName = 'Subtotal' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField11: TdaField Alias = 'DateOrdered' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'DateOrdered' FieldLength = 0 FieldName = 'DateOrdered' SQLFieldName = 'DateOrdered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField12: TdaField Alias = 'DateClosed' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'DateClosed' FieldLength = 0 FieldName = 'DateClosed' SQLFieldName = 'DateClosed' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField13: TdaField Alias = 'Site' DisplayWidth = 10 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField14: TdaField Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' IsDetail = True SQLFieldName = 'WorkOrder' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField15: TdaField ChildType = 2 Alias = 'Site' DisplayWidth = 10 FieldAlias = 'Site' FieldLength = 10 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField16: TdaField ChildType = 2 Alias = 'UnitName' DisplayWidth = 10 FieldAlias = 'UnitName' FieldLength = 10 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField17: TdaField ChildType = 2 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 10 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField18: TdaField ChildType = 2 Alias = 'Item' DisplayWidth = 10 FieldAlias = 'Item' FieldLength = 10 FieldName = 'Item' SQLFieldName = 'Item' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daTable1: TdaTable ChildType = 5 Alias = 'Porders' JoinType = dajtNone SQLAlias = 'Porders' TableAlias = 'Porders' TableName = 'Porders' end object daTable2: TdaTable ChildType = 5 Alias = 'Porders2' SQLAlias = 'Porders2' TableAlias = 'Porders2' TableName = 'Porders2' object daTableJoin1: TdaTableJoin ChildType = 6 object daField20: TdaField ChildType = 3 Alias = 'Joining' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Joining' FieldLength = 10 FieldName = 'Joining' SQLFieldName = 'Joining' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField19: TdaField ChildType = 4 Alias = 'Joining' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Joining' FieldLength = 10 FieldName = 'Joining' SQLFieldName = 'Joining' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_WoMaster' Height = 296 Left = 367 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 12 TypeColumnWidth = 52 Width = 256 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Porders' object WoMaster: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'WoMaster' MasterDataPipelineName = 'Porders' object ppField1: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 0 TableName = 'WoMaster' end object ppField2: TppField FieldAlias = 'Description' FieldName = 'Description' FieldLength = 60 IsDetail = True DisplayWidth = 10 Position = 1 TableName = 'WoParts' end object ppField3: TppField FieldAlias = 'Quantity' FieldName = 'Quantity' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 2 TableName = 'WoParts' end object ppField4: TppField FieldAlias = 'UnitCost' FieldName = 'UnitCost' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 3 TableName = 'WoParts' end object ppField5: TppField FieldAlias = 'SubTotal' FieldName = 'SubTotal' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 4 TableName = 'WoParts' end object TppMasterFieldLink MasterFieldName = 'Site' GuidCollationType = gcMSSQLServer DetailFieldName = 'Site' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'UnitName' GuidCollationType = gcMSSQLServer DetailFieldName = 'UnitName' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Numbered' GuidCollationType = gcMSSQLServer DetailFieldName = 'Numbered_2' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Item' GuidCollationType = gcMSSQLServer DetailFieldName = 'Item' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'WorkOrder' GuidCollationType = gcMSSQLServer DetailFieldName = 'Numbered' DetailSortOrder = soAscending end end object daSQL2: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WoMaster' LinkColor = clNavy MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT WoMaster.Numbered, WoParts.Description, ' ' WoParts.Quantity, WoParts.UnitCost, ' ' WoParts.SubTotal' 'FROM WoMaster WoMaster' ' INNER JOIN WoParts WoParts ON ' ' (WoParts.WorkOrder = WoMaster.Numbered)' 'WHERE ('#39'c'#39' <> '#39'c'#39' )') SQLType = sqSQL2 object daField1: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField Alias = 'Description' DisplayWidth = 10 FieldAlias = 'Description' FieldLength = 60 FieldName = 'Description' IsDetail = True SQLFieldName = 'Description' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField3: TdaField Alias = 'Quantity' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Quantity' FieldLength = 5 FieldName = 'Quantity' IsDetail = True SQLFieldName = 'Quantity' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField4: TdaField Alias = 'UnitCost' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'UnitCost' FieldLength = 5 FieldName = 'UnitCost' IsDetail = True SQLFieldName = 'UnitCost' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField5: TdaField Alias = 'SubTotal' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'SubTotal' FieldLength = 2 FieldName = 'SubTotal' IsDetail = True SQLFieldName = 'SubTotal' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField6: TdaField ChildType = 2 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 10 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField ChildType = 2 Alias = 'Description' DisplayWidth = 10 FieldAlias = 'Description' FieldLength = 10 FieldName = 'Description' SQLFieldName = 'Description' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daTable1: TdaTable ChildType = 5 Alias = 'WoMaster' JoinType = dajtNone SQLAlias = 'WoMaster' TableAlias = 'WoMaster' TableName = 'WoMaster' end object daTable2: TdaTable ChildType = 5 Alias = 'WoParts' SQLAlias = 'WoParts' TableAlias = 'WoParts' TableName = 'WoParts' object daTableJoin1: TdaTableJoin ChildType = 6 object daField9: TdaField ChildType = 3 Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'WorkOrder' FieldLength = 10 FieldName = 'WorkOrder' SQLFieldName = 'WorkOrder' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField8: TdaField ChildType = 4 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 10 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end end object daSQLLink1: TdaSQLLink ChildType = 9 object daField1: TdaField ChildType = 10 Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' IsDetail = True SQLFieldName = 'WorkOrder' TableAlias = 'Porders2' TableName = 'Porders2' TableSQLAlias = 'Porders2' end object daField2: TdaField ChildType = 11 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end end end end end