ReportName = Units Expense Detailed Services ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WoMaster PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Units Expense Detailed Services' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' 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 = 'Units Expense Detailed Services' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Units Expense Detailed Services.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True DeviceType = 'Screen' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.04' mmColumnWidth = 0 DataPipelineName = 'WoMaster' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 14817 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 1323 mmWidth = 200555 BandType = 1 end object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Units Expense Detailed Servicees' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6615 mmLeft = 1323 mmTop = 3175 mmWidth = 77523 BandType = 1 end object ppDBText8: TppDBText UserName = 'DBText8' AutoSize = True DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 165809 mmTop = 3175 mmWidth = 35010 BandType = 1 end object ppLabel16: TppLabel UserName = 'Params' Caption = 'CompletedDate: 01/01/00- 09/30/04, Type: Pickup' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 10054 mmWidth = 71840 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 7408 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 2117 mmLeft = 1323 mmTop = 6615 mmWidth = 200555 BandType = 0 end object ppLine2: TppLine UserName = 'Line2' Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 2910 mmLeft = 1323 mmTop = 1058 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Caption = 'WO Number' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 8202 mmTop = 2117 mmWidth = 18521 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Caption = 'Labor Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 55563 mmTop = 2117 mmWidth = 17992 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Caption = 'Parts Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 74877 mmTop = 2117 mmWidth = 16933 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Caption = 'Other Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 93134 mmTop = 2117 mmWidth = 17727 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' AutoSize = False Caption = 'Tax Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 112184 mmTop = 2117 mmWidth = 14817 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Caption = 'Total Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 128323 mmTop = 2117 mmWidth = 16669 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' AutoSize = False Caption = 'Quantity' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 146844 mmTop = 2117 mmWidth = 17727 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' AutoSize = False Caption = 'Cost Ea.' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 166952 mmTop = 2117 mmWidth = 14817 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' AutoSize = False Caption = 'Sub Total' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 184150 mmTop = 2117 mmWidth = 16669 BandType = 0 end object ppLabel13: TppLabel UserName = 'Label13' AutoSize = False Caption = 'Completed' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 32279 mmTop = 2117 mmWidth = 17992 BandType = 0 end end object ppDetailBand1: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5556 mmPrintPosition = 0 object ppSubReport1: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True TraverseAllData = False DataPipelineName = 'WoServices' mmHeight = 5027 mmLeft = 0 mmTop = 265 mmWidth = 203200 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.WoServices PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Units Expense Detailed Services' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' 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 = '7.04' mmColumnWidth = 0 DataPipelineName = 'WoServices' object ppDetailBand2: TppDetailBand mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText9: TppDBText UserName = 'DBText9' DataField = 'Quantity' DataPipeline = daADOQueryDataView2.WoServices DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoServices' mmHeight = 3175 mmLeft = 147902 mmTop = 794 mmWidth = 17198 BandType = 4 end object ppDBText10: TppDBText UserName = 'DBText10' DataField = 'UnitCost' DataPipeline = daADOQueryDataView2.WoServices DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoServices' mmHeight = 3175 mmLeft = 165894 mmTop = 794 mmWidth = 17198 BandType = 4 end object ppDBText11: TppDBText UserName = 'DBText11' DataField = 'SubTotal' DataPipeline = daADOQueryDataView2.WoServices DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoServices' mmHeight = 3175 mmLeft = 184415 mmTop = 794 mmWidth = 17198 BandType = 4 end object ppDBText12: TppDBText UserName = 'DBText12' DataField = 'Description' DataPipeline = daADOQueryDataView2.WoServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoServices' mmHeight = 3175 mmLeft = 101600 mmTop = 794 mmWidth = 45244 BandType = 4 end object ppLabel11: TppLabel UserName = 'Label11' Caption = 'Service:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3175 mmLeft = 88900 mmTop = 794 mmWidth = 10583 BandType = 4 end end end end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine4: TppLine UserName = 'Line4' Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 2381 mmLeft = 1323 mmTop = 6085 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 4487 mmLeft = 1323 mmTop = 1323 mmWidth = 17187 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4487 mmLeft = 184680 mmTop = 1323 mmWidth = 17187 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 5556 mmPrintPosition = 0 object ppDBCalc6: TppDBCalc UserName = 'DBCalc6' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 127794 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppLine6: TppLine UserName = 'Line6' Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 53975 mmTop = 1058 mmWidth = 90752 BandType = 7 end object ppLabel15: TppLabel UserName = 'Label15' Caption = 'Totals All Units' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] Transparent = True mmHeight = 3387 mmLeft = 3440 mmTop = 1852 mmWidth = 20489 BandType = 7 end object ppDBCalc7: TppDBCalc UserName = 'DBCalc7' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 112448 mmTop = 1852 mmWidth = 14552 BandType = 7 end object ppDBCalc8: TppDBCalc UserName = 'DBCalc8' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 93663 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppDBCalc9: TppDBCalc UserName = 'DBCalc9' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 74613 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppDBCalc10: TppDBCalc UserName = 'DBCalc10' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 56356 mmTop = 1852 mmWidth = 17198 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'UnitName' DataPipeline = daADOQueryDataView1.WoMaster KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WoMaster' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'UnitName' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4106 mmLeft = 3440 mmTop = 2646 mmWidth = 73025 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 5821 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 127794 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppLine5: TppLine UserName = 'Line5' Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 53975 mmTop = 1058 mmWidth = 90752 BandType = 5 GroupNo = 0 end object ppLabel14: TppLabel UserName = 'Label14' Caption = 'Totals This Unit' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] Transparent = True mmHeight = 3387 mmLeft = 3440 mmTop = 1852 mmWidth = 21209 BandType = 5 GroupNo = 0 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 112448 mmTop = 1852 mmWidth = 14552 BandType = 5 GroupNo = 0 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 93663 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 74613 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppDBCalc5: TppDBCalc UserName = 'DBCalc5' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 56356 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 end end end object ppGroup2: TppGroup BreakName = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WoMaster' object ppGroupHeaderBand2: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBText2' AutoSize = True DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '#######0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 20458 mmTop = 2117 mmWidth = 6265 BandType = 3 GroupNo = 1 end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 55563 mmTop = 2117 mmWidth = 17992 BandType = 3 GroupNo = 1 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 74877 mmTop = 2117 mmWidth = 16933 BandType = 3 GroupNo = 1 end object ppDBText5: TppDBText UserName = 'DBText5' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 93134 mmTop = 2117 mmWidth = 17727 BandType = 3 GroupNo = 1 end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 112184 mmTop = 2117 mmWidth = 14817 BandType = 3 GroupNo = 1 end object ppDBText7: TppDBText UserName = 'DBText7' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 128323 mmTop = 2117 mmWidth = 16669 BandType = 3 GroupNo = 1 end object ppDBText17: TppDBText UserName = 'DBText17' DataField = 'CompletedDate' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3387 mmLeft = 32279 mmTop = 2117 mmWidth = 17198 BandType = 3 GroupNo = 1 end end object ppGroupFooterBand2: TppGroupFooterBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppSubReport2: TppSubReport UserName = 'SubReport2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True TraverseAllData = False DataPipelineName = 'WoParts' mmHeight = 5027 mmLeft = 0 mmTop = 265 mmWidth = 203200 BandType = 5 GroupNo = 1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object ppChildReport2: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView3.WoParts PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Units Expense Detailed Services' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' 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 = '7.04' mmColumnWidth = 0 DataPipelineName = 'WoParts' object ppDetailBand3: TppDetailBand mmBottomOffset = 0 mmHeight = 4763 mmPrintPosition = 0 object ppLabel12: TppLabel UserName = 'Label12' Caption = 'Part:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 88900 mmTop = 1058 mmWidth = 6011 BandType = 4 end object ppDBText13: TppDBText UserName = 'DBText13' DataField = 'Description' DataPipeline = daADOQueryDataView3.WoParts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoParts' mmHeight = 3175 mmLeft = 101600 mmTop = 1058 mmWidth = 45773 BandType = 4 end object ppDBText14: TppDBText UserName = 'DBText14' DataField = 'Quantity' DataPipeline = daADOQueryDataView3.WoParts DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoParts' mmHeight = 3175 mmLeft = 148167 mmTop = 1058 mmWidth = 17198 BandType = 4 end object ppDBText15: TppDBText UserName = 'DBText101' DataField = 'UnitCost' DataPipeline = daADOQueryDataView3.WoParts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoParts' mmHeight = 3175 mmLeft = 166159 mmTop = 1058 mmWidth = 17198 BandType = 4 end object ppDBText16: TppDBText UserName = 'DBText16' DataField = 'SubTotal' DataPipeline = daADOQueryDataView3.WoParts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoParts' mmHeight = 3175 mmLeft = 184415 mmTop = 1058 mmWidth = 17198 BandType = 4 end end end end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_WoMaster' Height = 573 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object WoMaster: TppChildDBPipeline AutoCreateFields = False UserName = 'WoMaster' object ppField1: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 0 TableName = 'WoMaster' end object ppField2: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 DisplayWidth = 80 Position = 1 TableName = 'WoMaster' end object ppField3: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'Company' FieldName = 'Company' FieldLength = 50 DisplayWidth = 50 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'Employee' FieldName = 'Employee' FieldLength = 35 DisplayWidth = 35 Position = 5 TableName = 'WoMaster' end object ppField7: TppField FieldAlias = 'InvoiceNumber' FieldName = 'InvoiceNumber' FieldLength = 25 DisplayWidth = 25 Position = 6 TableName = 'WoMaster' end object ppField8: TppField FieldAlias = 'LaborCost' FieldName = 'LaborCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 7 TableName = 'WoMaster' end object ppField9: TppField FieldAlias = 'LaborHours' FieldName = 'LaborHours' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 8 TableName = 'WoMaster' end object ppField10: TppField FieldAlias = 'LaborRate' FieldName = 'LaborRate' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 9 TableName = 'WoMaster' end object ppField11: TppField FieldAlias = 'OtherCost' FieldName = 'OtherCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 10 TableName = 'WoMaster' end object ppField12: TppField FieldAlias = 'PartsCost' FieldName = 'PartsCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 11 TableName = 'WoMaster' end object ppField13: TppField FieldAlias = 'Reference' FieldName = 'Reference' FieldLength = 25 DisplayWidth = 25 Position = 12 TableName = 'WoMaster' end object ppField14: TppField FieldAlias = 'Requester' FieldName = 'Requester' FieldLength = 35 DisplayWidth = 35 Position = 13 TableName = 'WoMaster' end object ppField15: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 25 Position = 14 TableName = 'WoMaster' end object ppField16: TppField FieldAlias = 'TaxCost' FieldName = 'TaxCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 15 TableName = 'WoMaster' end object ppField17: TppField FieldAlias = 'TotalCost' FieldName = 'TotalCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 16 TableName = 'WoMaster' end object ppField18: TppField FieldAlias = 'WOCategoryID' FieldName = 'WOCategoryID' FieldLength = 25 DisplayWidth = 25 Position = 17 TableName = 'WoMaster' end object ppField19: TppField FieldAlias = 'WorkGroup' FieldName = 'WorkGroup' FieldLength = 25 DisplayWidth = 25 Position = 18 TableName = 'WoMaster' end object ppField20: TppField FieldAlias = 'WoTaxRate' FieldName = 'WoTaxRate' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 19 TableName = 'WoMaster' end object ppField21: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 20 TableName = 'WoMaster' end object ppField22: TppField FieldAlias = 'HubReading' FieldName = 'HubReading' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 21 TableName = 'WoMaster' end object ppField23: TppField FieldAlias = 'Notes' FieldName = 'Notes' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 22 TableName = 'WoMaster' end object ppField24: TppField FieldAlias = 'CategoryID' FieldName = 'CategoryID' FieldLength = 25 IsDetail = True DisplayWidth = 25 Position = 23 TableName = 'Units' end object ppField25: TppField FieldAlias = 'Type' FieldName = 'Type' FieldLength = 25 IsDetail = True DisplayWidth = 25 Position = 24 TableName = 'Units' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WoMaster' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT WoMaster.Numbered, WoMaster.UnitName, ' ' WoMaster.ScheduledDate, ' ' WoMaster.CompletedDate, WoMaster.Company, ' ' WoMaster.Employee, WoMaster.InvoiceNumber, ' ' WoMaster.LaborCost, WoMaster.LaborHours, ' ' WoMaster.LaborRate, WoMaster.OtherCost, ' ' WoMaster.PartsCost, WoMaster.Reference, ' ' WoMaster.Requester, WoMaster.Site, ' ' WoMaster.TaxCost, WoMaster.TotalCost, ' ' WoMaster.WOCategoryID, WoMaster.WorkGroup, ' ' WoMaster.WoTaxRate, WoMaster.Unit, ' ' WoMaster.HubReading, WoMaster.Notes, ' ' Units.CategoryID, Units.Type' 'FROM WoMaster WoMaster INNER JOIN Units Units ON ' ' (Units.RecordNumber = WoMaster.Unit)' 'WHERE ( WoMaster.CompletedDate IS NOT NULL )' 'ORDER BY WoMaster.UnitName, WoMaster.Unit, ' ' WoMaster.Numbered') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotBlank Value = '10/09/03 1:15:46 PM' object TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end object daField1: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField3: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'Company' DisplayWidth = 50 FieldAlias = 'Company' FieldLength = 50 FieldName = 'Company' SQLFieldName = 'Company' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField Alias = 'InvoiceNumber' DisplayWidth = 25 FieldAlias = 'InvoiceNumber' FieldLength = 25 FieldName = 'InvoiceNumber' SQLFieldName = 'InvoiceNumber' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField8: TdaField Alias = 'LaborCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'LaborCost' FieldLength = 2 FieldName = 'LaborCost' SQLFieldName = 'LaborCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField9: TdaField Alias = 'LaborHours' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborHours' FieldLength = 5 FieldName = 'LaborHours' SQLFieldName = 'LaborHours' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField10: TdaField Alias = 'LaborRate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborRate' FieldLength = 5 FieldName = 'LaborRate' SQLFieldName = 'LaborRate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField11: TdaField Alias = 'OtherCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'OtherCost' FieldLength = 2 FieldName = 'OtherCost' SQLFieldName = 'OtherCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField12: TdaField Alias = 'PartsCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'PartsCost' FieldLength = 2 FieldName = 'PartsCost' SQLFieldName = 'PartsCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField13: TdaField Alias = 'Reference' DisplayWidth = 25 FieldAlias = 'Reference' FieldLength = 25 FieldName = 'Reference' SQLFieldName = 'Reference' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField14: TdaField Alias = 'Requester' DisplayWidth = 35 FieldAlias = 'Requester' FieldLength = 35 FieldName = 'Requester' SQLFieldName = 'Requester' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField15: TdaField Alias = 'Site' DisplayWidth = 25 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField16: TdaField Alias = 'TaxCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'TaxCost' FieldLength = 2 FieldName = 'TaxCost' SQLFieldName = 'TaxCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField17: TdaField Alias = 'TotalCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'TotalCost' FieldLength = 2 FieldName = 'TotalCost' SQLFieldName = 'TotalCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField18: TdaField Alias = 'WOCategoryID' DisplayWidth = 25 FieldAlias = 'WOCategoryID' FieldLength = 25 FieldName = 'WOCategoryID' SQLFieldName = 'WOCategoryID' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField19: TdaField Alias = 'WorkGroup' DisplayWidth = 25 FieldAlias = 'WorkGroup' FieldLength = 25 FieldName = 'WorkGroup' SQLFieldName = 'WorkGroup' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField20: TdaField Alias = 'WoTaxRate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'WoTaxRate' FieldLength = 5 FieldName = 'WoTaxRate' SQLFieldName = 'WoTaxRate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField21: TdaField Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField22: TdaField Alias = 'HubReading' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'HubReading' FieldLength = 5 FieldName = 'HubReading' SQLFieldName = 'HubReading' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField23: TdaField Alias = 'Notes' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes' FieldLength = 0 FieldName = 'Notes' Linkable = False SQLFieldName = 'Notes' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField24: TdaField Alias = 'CategoryID' DisplayWidth = 25 FieldAlias = 'CategoryID' FieldLength = 25 FieldName = 'CategoryID' IsDetail = True SQLFieldName = 'CategoryID' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField25: TdaField Alias = 'Type' DisplayWidth = 25 FieldAlias = 'Type' FieldLength = 25 FieldName = 'Type' IsDetail = True SQLFieldName = 'Type' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField26: TdaField ChildType = 2 Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField27: TdaField ChildType = 2 Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField28: TdaField ChildType = 2 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daTable1: TdaTable ChildType = 5 Alias = 'WoMaster' JoinType = dajtNone SQLAlias = 'WoMaster' TableAlias = 'WoMaster' TableName = 'WoMaster' end object daTable2: TdaTable ChildType = 5 Alias = 'Units' SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' object daTableJoin1: TdaTableJoin ChildType = 6 object daField30: TdaField ChildType = 3 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField29: TdaField ChildType = 4 Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_WoServices' Height = 420 Left = 228 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_WoMaster' object WoServices: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'WoServices' MasterDataPipelineName = 'WoMaster' object ppField1: TppField FieldAlias = 'Completed' FieldName = 'Completed' FieldLength = 1 DisplayWidth = 1 Position = 0 TableName = 'WoServices' end object ppField2: TppField FieldAlias = 'CostCenter' FieldName = 'CostCenter' FieldLength = 15 DisplayWidth = 15 Position = 1 TableName = 'WoServices' end object ppField3: TppField FieldAlias = 'CostEstimate' FieldName = 'CostEstimate' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 2 TableName = 'WoServices' end object ppField4: TppField FieldAlias = 'Description' FieldName = 'Description' FieldLength = 60 DisplayWidth = 60 Position = 3 TableName = 'WoServices' end object ppField5: TppField FieldAlias = 'Employee' FieldName = 'Employee' FieldLength = 35 DisplayWidth = 35 Position = 4 TableName = 'WoServices' end object ppField6: TppField FieldAlias = 'ItemNumber' FieldName = 'ItemNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 5 TableName = 'WoServices' end object ppField7: TppField FieldAlias = 'LaborEstimate' FieldName = 'LaborEstimate' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 6 TableName = 'WoServices' end object ppField8: TppField FieldAlias = 'Notes_General' FieldName = 'Notes_General' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 7 TableName = 'WoServices' end object ppField9: TppField FieldAlias = 'Notes_Safety' FieldName = 'Notes_Safety' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 8 TableName = 'WoServices' end object ppField10: TppField FieldAlias = 'Notes_UnitSpecific' FieldName = 'Notes_UnitSpecific' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 9 TableName = 'WoServices' end object ppField11: TppField FieldAlias = 'Quantity' FieldName = 'Quantity' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 10 TableName = 'WoServices' end object ppField12: TppField FieldAlias = 'RecordNumber' FieldName = 'RecordNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 11 TableName = 'WoServices' end object ppField13: TppField FieldAlias = 'RecordTypeName' FieldName = 'RecordTypeName' FieldLength = 25 DisplayWidth = 25 Position = 12 TableName = 'WoServices' end object ppField14: TppField FieldAlias = 'RecordTypeNumber' FieldName = 'RecordTypeNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 13 TableName = 'WoServices' end object ppField15: TppField FieldAlias = 'SubTotal' FieldName = 'SubTotal' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 14 TableName = 'WoServices' end object ppField16: TppField FieldAlias = 'Taxable' FieldName = 'Taxable' FieldLength = 1 DisplayWidth = 1 Position = 15 TableName = 'WoServices' end object ppField17: TppField FieldAlias = 'UnitCost' FieldName = 'UnitCost' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 16 TableName = 'WoServices' end object ppField18: TppField FieldAlias = 'WorkOrder' FieldName = 'WorkOrder' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 17 TableName = 'WoServices' end object TppMasterFieldLink MasterFieldName = 'UnitName' DetailFieldName = 'UnitName' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Unit' DetailFieldName = 'Unit' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Numbered' DetailFieldName = 'Numbered' DetailSortOrder = soAscending end end object daSQL2: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WoServices' LinkColor = clNavy MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT WoServices.Completed, ' ' WoServices.CostCenter, ' ' WoServices.CostEstimate, ' ' WoServices.Description, ' ' WoServices.Employee, ' ' WoServices.ItemNumber, ' ' WoServices.LaborEstimate, ' ' WoServices.Notes_General, ' ' WoServices.Notes_Safety, ' ' WoServices.Notes_UnitSpecific, ' ' WoServices.Quantity, ' ' WoServices.RecordNumber, ' ' WoServices.RecordTypeName, ' ' WoServices.RecordTypeNumber, ' ' WoServices.SubTotal, WoServices.Taxable, ' ' WoServices.UnitCost, WoServices.WorkOrder' 'FROM WoServices WoServices') SQLType = sqSQL2 object daField1: TdaField Alias = 'Completed' DisplayWidth = 1 FieldAlias = 'Completed' FieldLength = 1 FieldName = 'Completed' SQLFieldName = 'Completed' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField2: TdaField Alias = 'CostCenter' DisplayWidth = 15 FieldAlias = 'CostCenter' FieldLength = 15 FieldName = 'CostCenter' SQLFieldName = 'CostCenter' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField3: TdaField Alias = 'CostEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'CostEstimate' FieldLength = 5 FieldName = 'CostEstimate' SQLFieldName = 'CostEstimate' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField4: TdaField Alias = 'Description' DisplayWidth = 60 FieldAlias = 'Description' FieldLength = 60 FieldName = 'Description' SQLFieldName = 'Description' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField5: TdaField Alias = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField6: TdaField Alias = 'ItemNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ItemNumber' FieldLength = 0 FieldName = 'ItemNumber' SQLFieldName = 'ItemNumber' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField7: TdaField Alias = 'LaborEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborEstimate' FieldLength = 5 FieldName = 'LaborEstimate' SQLFieldName = 'LaborEstimate' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField8: TdaField Alias = 'Notes_General' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes_General' FieldLength = 0 FieldName = 'Notes_General' Linkable = False SQLFieldName = 'Notes_General' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField9: TdaField Alias = 'Notes_Safety' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes_Safety' FieldLength = 0 FieldName = 'Notes_Safety' Linkable = False SQLFieldName = 'Notes_Safety' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField10: TdaField Alias = 'Notes_UnitSpecific' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes_UnitSpecific' FieldLength = 0 FieldName = 'Notes_UnitSpecific' Linkable = False SQLFieldName = 'Notes_UnitSpecific' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField11: TdaField Alias = 'Quantity' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'Quantity' FieldLength = 5 FieldName = 'Quantity' SQLFieldName = 'Quantity' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField12: TdaField Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField13: TdaField Alias = 'RecordTypeName' DisplayWidth = 25 FieldAlias = 'RecordTypeName' FieldLength = 25 FieldName = 'RecordTypeName' SQLFieldName = 'RecordTypeName' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField14: TdaField Alias = 'RecordTypeNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordTypeNumber' FieldLength = 0 FieldName = 'RecordTypeNumber' SQLFieldName = 'RecordTypeNumber' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField15: TdaField Alias = 'SubTotal' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'SubTotal' FieldLength = 2 FieldName = 'SubTotal' SQLFieldName = 'SubTotal' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField16: TdaField Alias = 'Taxable' DisplayWidth = 1 FieldAlias = 'Taxable' FieldLength = 1 FieldName = 'Taxable' SQLFieldName = 'Taxable' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField17: TdaField Alias = 'UnitCost' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'UnitCost' FieldLength = 5 FieldName = 'UnitCost' SQLFieldName = 'UnitCost' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daField18: TdaField Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' SQLFieldName = 'WorkOrder' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end object daTable1: TdaTable ChildType = 5 Alias = 'WoServices' JoinType = dajtNone SQLAlias = 'WoServices' TableAlias = 'WoServices' TableName = 'WoServices' end object daSQLLink1: TdaSQLLink ChildType = 9 object daField1: TdaField ChildType = 10 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField ChildType = 11 Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' SQLFieldName = 'WorkOrder' TableAlias = 'WoServices' TableName = 'WoServices' TableSQLAlias = 'WoServices' end end end end object daADOQueryDataView3: TdaADOQueryDataView UserName = 'Query_WoParts' Height = 419 Left = 446 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 16 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_WoMaster' object WoParts: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'WoParts' MasterDataPipelineName = 'WoMaster' object ppField1: TppField FieldAlias = 'Completed' FieldName = 'Completed' FieldLength = 1 DisplayWidth = 1 Position = 0 TableName = 'WoParts' end object ppField2: TppField FieldAlias = 'CostCenter' FieldName = 'CostCenter' FieldLength = 15 DisplayWidth = 15 Position = 1 TableName = 'WoParts' end object ppField3: TppField FieldAlias = 'CostEstimate' FieldName = 'CostEstimate' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 2 TableName = 'WoParts' end object ppField4: TppField FieldAlias = 'Description' FieldName = 'Description' FieldLength = 60 DisplayWidth = 60 Position = 3 TableName = 'WoParts' end object ppField5: TppField FieldAlias = 'Employee' FieldName = 'Employee' FieldLength = 35 DisplayWidth = 35 Position = 4 TableName = 'WoParts' end object ppField6: TppField FieldAlias = 'ItemNumber' FieldName = 'ItemNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 5 TableName = 'WoParts' end object ppField7: TppField FieldAlias = 'LaborEstimate' FieldName = 'LaborEstimate' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 6 TableName = 'WoParts' end object ppField8: TppField FieldAlias = 'Notes_General' FieldName = 'Notes_General' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 7 TableName = 'WoParts' end object ppField9: TppField FieldAlias = 'Notes_Safety' FieldName = 'Notes_Safety' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 8 TableName = 'WoParts' end object ppField10: TppField FieldAlias = 'Notes_UnitSpecific' FieldName = 'Notes_UnitSpecific' FieldLength = 0 Linkable = False DataType = dtMemo DisplayWidth = 0 Position = 9 TableName = 'WoParts' end object ppField11: TppField FieldAlias = 'Quantity' FieldName = 'Quantity' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 10 TableName = 'WoParts' end object ppField12: TppField FieldAlias = 'RecordNumber' FieldName = 'RecordNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 11 TableName = 'WoParts' end object ppField13: TppField FieldAlias = 'RecordTypeName' FieldName = 'RecordTypeName' FieldLength = 25 DisplayWidth = 25 Position = 12 TableName = 'WoParts' end object ppField14: TppField FieldAlias = 'RecordTypeNumber' FieldName = 'RecordTypeNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 13 TableName = 'WoParts' end object ppField15: TppField FieldAlias = 'SubTotal' FieldName = 'SubTotal' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 14 TableName = 'WoParts' end object ppField16: TppField FieldAlias = 'Taxable' FieldName = 'Taxable' FieldLength = 1 DisplayWidth = 1 Position = 15 TableName = 'WoParts' end object ppField17: TppField FieldAlias = 'UnitCost' FieldName = 'UnitCost' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 16 TableName = 'WoParts' end object ppField18: TppField FieldAlias = 'WorkOrder' FieldName = 'WorkOrder' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 17 TableName = 'WoParts' end object TppMasterFieldLink MasterFieldName = 'UnitName' DetailFieldName = 'UnitName' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Unit' DetailFieldName = 'Unit' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Numbered' DetailFieldName = 'Numbered' DetailSortOrder = soAscending end end object daSQL3: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WoParts' LinkColor = clGreen MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT WoParts.Completed, WoParts.CostCenter, ' ' WoParts.CostEstimate, WoParts.Description, ' ' WoParts.Employee, WoParts.ItemNumber, ' ' WoParts.LaborEstimate, ' ' WoParts.Notes_General, ' ' WoParts.Notes_Safety, ' ' WoParts.Notes_UnitSpecific, ' ' WoParts.Quantity, WoParts.RecordNumber, ' ' WoParts.RecordTypeName, ' ' WoParts.RecordTypeNumber, ' ' WoParts.SubTotal, WoParts.Taxable, ' ' WoParts.UnitCost, WoParts.WorkOrder' 'FROM WoParts WoParts') SQLType = sqSQL2 object daField1: TdaField Alias = 'Completed' DisplayWidth = 1 FieldAlias = 'Completed' FieldLength = 1 FieldName = 'Completed' SQLFieldName = 'Completed' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField2: TdaField Alias = 'CostCenter' DisplayWidth = 15 FieldAlias = 'CostCenter' FieldLength = 15 FieldName = 'CostCenter' SQLFieldName = 'CostCenter' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField3: TdaField Alias = 'CostEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'CostEstimate' FieldLength = 5 FieldName = 'CostEstimate' SQLFieldName = 'CostEstimate' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField4: TdaField Alias = 'Description' DisplayWidth = 60 FieldAlias = 'Description' FieldLength = 60 FieldName = 'Description' SQLFieldName = 'Description' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField5: TdaField Alias = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField6: TdaField Alias = 'ItemNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ItemNumber' FieldLength = 0 FieldName = 'ItemNumber' SQLFieldName = 'ItemNumber' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField7: TdaField Alias = 'LaborEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborEstimate' FieldLength = 5 FieldName = 'LaborEstimate' SQLFieldName = 'LaborEstimate' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField8: TdaField Alias = 'Notes_General' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes_General' FieldLength = 0 FieldName = 'Notes_General' Linkable = False SQLFieldName = 'Notes_General' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField9: TdaField Alias = 'Notes_Safety' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes_Safety' FieldLength = 0 FieldName = 'Notes_Safety' Linkable = False SQLFieldName = 'Notes_Safety' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField10: TdaField Alias = 'Notes_UnitSpecific' DataType = dtMemo DisplayWidth = 0 FieldAlias = 'Notes_UnitSpecific' FieldLength = 0 FieldName = 'Notes_UnitSpecific' Linkable = False SQLFieldName = 'Notes_UnitSpecific' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField11: TdaField Alias = 'Quantity' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'Quantity' FieldLength = 5 FieldName = 'Quantity' SQLFieldName = 'Quantity' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField12: TdaField Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField13: TdaField Alias = 'RecordTypeName' DisplayWidth = 25 FieldAlias = 'RecordTypeName' FieldLength = 25 FieldName = 'RecordTypeName' SQLFieldName = 'RecordTypeName' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField14: TdaField Alias = 'RecordTypeNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordTypeNumber' FieldLength = 0 FieldName = 'RecordTypeNumber' SQLFieldName = 'RecordTypeNumber' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField15: TdaField Alias = 'SubTotal' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'SubTotal' FieldLength = 2 FieldName = 'SubTotal' SQLFieldName = 'SubTotal' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField16: TdaField Alias = 'Taxable' DisplayWidth = 1 FieldAlias = 'Taxable' FieldLength = 1 FieldName = 'Taxable' SQLFieldName = 'Taxable' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField17: TdaField Alias = 'UnitCost' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'UnitCost' FieldLength = 5 FieldName = 'UnitCost' SQLFieldName = 'UnitCost' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField18: TdaField Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' SQLFieldName = 'WorkOrder' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daTable1: TdaTable ChildType = 5 Alias = 'WoParts' JoinType = dajtNone SQLAlias = 'WoParts' TableAlias = 'WoParts' TableName = 'WoParts' end object daSQLLink1: TdaSQLLink ChildType = 9 object daField1: TdaField ChildType = 10 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField ChildType = 11 Alias = 'WorkOrder' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'WorkOrder' FieldLength = 0 FieldName = 'WorkOrder' SQLFieldName = 'WorkOrder' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end end end end object daADOQueryDataView4: TdaADOQueryDataView UserName = 'Query_Units' Height = 194 Left = 666 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 18 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_WoMaster' object Units: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'Units' MasterDataPipelineName = 'WoMaster' object ppField1: TppField FieldAlias = 'Location' FieldName = 'Location' FieldLength = 25 DisplayWidth = 25 Position = 0 TableName = 'Units' end object ppField2: TppField FieldAlias = 'Make' FieldName = 'Make' FieldLength = 25 DisplayWidth = 25 Position = 1 TableName = 'Units' end object ppField3: TppField FieldAlias = 'Model' FieldName = 'Model' FieldLength = 25 DisplayWidth = 25 Position = 2 TableName = 'Units' end object ppField4: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 80 DisplayWidth = 80 Position = 3 TableName = 'Units' end object ppField5: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 25 Position = 4 TableName = 'Units' end object ppField6: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 25 DisplayWidth = 25 Position = 5 TableName = 'Units' end object ppField7: TppField FieldAlias = 'RecordNumber' FieldName = 'RecordNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 6 TableName = 'Units' end object TppMasterFieldLink MasterFieldName = 'UnitName' DetailFieldName = 'UnitName' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Unit' DetailFieldName = 'Unit_2' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Numbered' DetailFieldName = 'Numbered' DetailSortOrder = soAscending end end object daSQL4: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Units' LinkColor = clPurple MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Units.Location, Units.Make, Units.Model, ' ' Units.Name, Units.Site, Units.Unit, ' ' Units.RecordNumber' 'FROM Units Units') SQLType = sqSQL2 object daField1: TdaField Alias = 'Location' DisplayWidth = 25 FieldAlias = 'Location' FieldLength = 25 FieldName = 'Location' SQLFieldName = 'Location' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField2: TdaField Alias = 'Make' DisplayWidth = 25 FieldAlias = 'Make' FieldLength = 25 FieldName = 'Make' SQLFieldName = 'Make' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField3: TdaField Alias = 'Model' DisplayWidth = 25 FieldAlias = 'Model' FieldLength = 25 FieldName = 'Model' SQLFieldName = 'Model' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField4: TdaField Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField5: TdaField Alias = 'Site' DisplayWidth = 25 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField6: TdaField Alias = 'Unit' DisplayWidth = 25 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField7: TdaField Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daTable1: TdaTable ChildType = 5 Alias = 'Units' JoinType = dajtNone SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' end object daSQLLink1: TdaSQLLink ChildType = 9 object daField1: TdaField ChildType = 10 Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField ChildType = 11 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end end end end end object ppParameterList1: TppParameterList end end