ReportName = Work Orders - Completed With Unit Notes - Company ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WoMaster PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' 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 = 'Work Orders - Completed With Unit Notes - Company' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Work Orders - Completed With Unit Notes - Company.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 TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 0 DataPipelineName = 'WoMaster' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 34396 mmPrintPosition = 0 object ppDBText8: TppDBText UserName = 'DBText8' DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] ParentDataPipeline = False Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 4995 mmLeft = 6615 mmTop = 3440 mmWidth = 70644 BandType = 0 end object ppDBText9: TppDBText UserName = 'DBText9' DataField = 'Address' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 4868 mmLeft = 6615 mmTop = 8467 mmWidth = 70644 BandType = 0 end object ppDBText10: TppDBText UserName = 'DBText10' DataField = 'CityStateZip' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 4868 mmLeft = 6615 mmTop = 13229 mmWidth = 70644 BandType = 0 end object ppDBText11: TppDBText UserName = 'DBText11' DataField = 'Phone' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 4868 mmLeft = 19050 mmTop = 17992 mmWidth = 58208 BandType = 0 end object ppDBText12: TppDBText UserName = 'DBText12' DataField = 'Fax' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 4868 mmLeft = 15346 mmTop = 22754 mmWidth = 61913 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Caption = 'Phone: ' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True mmHeight = 4868 mmLeft = 6615 mmTop = 17992 mmWidth = 14690 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' Caption = 'Fax: ' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True mmHeight = 4868 mmLeft = 6615 mmTop = 22754 mmWidth = 9398 BandType = 0 end object ppDBText5: TppDBText UserName = 'DBText5' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4498 mmLeft = 121973 mmTop = 16404 mmWidth = 51858 BandType = 0 end object ppLabel33: TppLabel UserName = 'Label33' Caption = 'Work Order' Font.Charset = ANSI_CHARSET Font.Color = clBlue Font.Name = 'Imprint MT Shadow' Font.Size = 28 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 10054 mmLeft = 121973 mmTop = 6615 mmWidth = 51858 BandType = 0 end object ppDBText32: TppDBText UserName = 'DBText32' DataField = 'FullName' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 79640 mmTop = 3969 mmWidth = 38365 BandType = 0 end object ppDBText33: TppDBText UserName = 'DBText33' DataField = 'AddressLine1' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 79640 mmTop = 8731 mmWidth = 38894 BandType = 0 end object ppDBText34: TppDBText UserName = 'DBText34' DataField = 'AddressLine2P' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 79640 mmTop = 13758 mmWidth = 38629 BandType = 0 end object ppDBText35: TppDBText UserName = 'DBText35' DataField = 'AddressLine3P' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 79375 mmTop = 18256 mmWidth = 38894 BandType = 0 end object ppDBText36: TppDBText UserName = 'DBText36' DataField = 'Phone' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 79375 mmTop = 23019 mmWidth = 39952 BandType = 0 end end object ppDetailBand1: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0 object ppSubReport2: TppSubReport UserName = 'SubReport2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'WoParts' mmHeight = 5027 mmLeft = 8996 mmTop = 1058 mmWidth = 186267 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object ppChildReport2: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView3.WoParts PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' 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.03' mmColumnWidth = 0 DataPipelineName = 'WoParts' object ppTitleBand3: TppTitleBand mmBottomOffset = 0 mmHeight = 7673 mmPrintPosition = 0 object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4022 mmLeft = 20108 mmTop = 2381 mmWidth = 14023 BandType = 1 end object ppLabel28: TppLabel UserName = 'Label28' Caption = 'Part Description' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 38365 mmTop = 2381 mmWidth = 24977 BandType = 1 end object ppLabel29: TppLabel UserName = 'Label29' Caption = 'Quantity' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4021 mmLeft = 106680 mmTop = 2380 mmWidth = 19050 BandType = 1 end object ppLabel30: TppLabel UserName = 'Label30' Caption = 'Cost Each' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4021 mmLeft = 132080 mmTop = 2380 mmWidth = 19050 BandType = 1 end object ppLabel31: TppLabel UserName = 'Label31' Caption = 'Extended Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4021 mmLeft = 154940 mmTop = 2380 mmWidth = 25400 BandType = 1 end object ppShape3: TppShape UserName = 'Shape3' mmHeight = 5292 mmLeft = 529 mmTop = 1588 mmWidth = 11642 BandType = 1 end object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 1323 mmLeft = 794 mmTop = 6350 mmWidth = 186002 BandType = 1 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Caption = 'Parts ' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 11 Font.Style = [fsBold, fsItalic] mmHeight = 4498 mmLeft = 794 mmTop = 1852 mmWidth = 10848 BandType = 1 end end object ppDetailBand3: TppDetailBand mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText4: TppDBText UserName = 'DBText4' ReprintOnOverFlow = True DataField = 'Description' DataPipeline = daADOQueryDataView3.WoParts Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoParts' mmHeight = 4022 mmLeft = 38365 mmTop = 0 mmWidth = 66411 BandType = 4 end object ppDBText28: TppDBText UserName = 'DBText28' ReprintOnOverFlow = True AutoSize = True DataField = 'Quantity' DataPipeline = daADOQueryDataView3.WoParts DisplayFormat = '#,0.00;-#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoParts' mmHeight = 3969 mmLeft = 112713 mmTop = 0 mmWidth = 12965 BandType = 4 end object ppDBText29: TppDBText UserName = 'DBText29' AutoSize = True DataField = 'UnitCost' DataPipeline = daADOQueryDataView3.WoParts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoParts' mmHeight = 3969 mmLeft = 137584 mmTop = 0 mmWidth = 13494 BandType = 4 end object ppDBText30: TppDBText UserName = 'DBText30' AutoSize = True DataField = 'SubTotal' DataPipeline = daADOQueryDataView3.WoParts DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoParts' mmHeight = 3969 mmLeft = 166423 mmTop = 0 mmWidth = 14023 BandType = 4 end object ppDBText31: TppDBText UserName = 'DBText31' ReprintOnOverFlow = True AutoSize = True DataField = 'Numbered' DataPipeline = daADOQueryDataView5.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Parts' mmHeight = 4022 mmLeft = 17663 mmTop = 0 mmWidth = 16468 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.5 mmHeight = 3969 mmLeft = 1323 mmTop = 5821 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 ppGroup1: TppGroup BreakName = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster OutlineSettings.CreateNode = True NewPage = True ResetPageNo = True ReprintOnSubsequentPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WoMaster' object ppGroupHeaderBand1: TppGroupHeaderBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 47625 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'UnitName' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 29369 mmTop = 3704 mmWidth = 121179 BandType = 3 GroupNo = 0 end object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Unit Name:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 3704 mmWidth = 17611 BandType = 3 GroupNo = 0 end object ppLabel2: TppLabel UserName = 'Label2' Caption = 'Number:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 8467 mmWidth = 13547 BandType = 3 GroupNo = 0 end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Make:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 13494 mmWidth = 9610 BandType = 3 GroupNo = 0 end object ppLabel8: TppLabel UserName = 'Label8' Caption = 'Employee:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 23019 mmWidth = 16510 BandType = 3 GroupNo = 0 end object ppLabel11: TppLabel UserName = 'Label11' Caption = 'Model:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 18256 mmWidth = 10499 BandType = 3 GroupNo = 0 end object ppLabel12: TppLabel UserName = 'Label12' Caption = 'Hub / Count:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 32808 mmWidth = 19685 BandType = 3 GroupNo = 0 end object ppLabel13: TppLabel UserName = 'Label13' Caption = 'Site:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 94192 mmTop = 8467 mmWidth = 7144 BandType = 3 GroupNo = 0 end object ppLabel14: TppLabel UserName = 'Label14' Caption = 'Location:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 94192 mmTop = 13494 mmWidth = 14552 BandType = 3 GroupNo = 0 end object ppLabel15: TppLabel UserName = 'Label15' Caption = 'Scheduled:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 94192 mmTop = 18256 mmWidth = 17727 BandType = 3 GroupNo = 0 end object ppLabel16: TppLabel UserName = 'Label16' Caption = 'Completed:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 94192 mmTop = 23019 mmWidth = 18256 BandType = 3 GroupNo = 0 end object ppLabel19: TppLabel UserName = 'Label19' Caption = 'Work Group:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4022 mmLeft = 8996 mmTop = 28046 mmWidth = 20193 BandType = 3 GroupNo = 0 end object ppSubReport1: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'WoServices' mmHeight = 5027 mmLeft = 8996 mmTop = 41540 mmWidth = 186267 BandType = 3 GroupNo = 0 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.WoServices PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' 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.03' mmColumnWidth = 0 DataPipelineName = 'WoServices' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Complete' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 4022 mmLeft = 26723 mmTop = 2117 mmWidth = 15071 BandType = 1 end object ppLabel23: TppLabel UserName = 'Label23' Caption = 'Service' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 4022 mmLeft = 44979 mmTop = 2117 mmWidth = 11684 BandType = 1 end object ppLabel24: TppLabel UserName = 'Label24' Caption = 'Labor Time' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4021 mmLeft = 106680 mmTop = 2116 mmWidth = 19050 BandType = 1 end object ppLabel25: TppLabel UserName = 'Label25' Caption = 'Cost Each' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4021 mmLeft = 132080 mmTop = 2116 mmWidth = 19050 BandType = 1 end object ppLabel26: TppLabel UserName = 'Label26' Caption = 'Extended Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4021 mmLeft = 154940 mmTop = 2116 mmWidth = 25400 BandType = 1 end object ppShape2: TppShape UserName = 'Shape2' mmHeight = 5556 mmLeft = 794 mmTop = 794 mmWidth = 17992 BandType = 1 end object ppLine3: TppLine UserName = 'Line3' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 1323 mmLeft = 1058 mmTop = 6085 mmWidth = 186002 BandType = 1 end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Caption = 'Services ' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 11 Font.Style = [fsBold, fsItalic] mmHeight = 4498 mmLeft = 1058 mmTop = 1323 mmWidth = 17198 BandType = 1 end end object ppDetailBand2: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 10054 mmPrintPosition = 0 object ppDBText3: TppDBText UserName = 'DBText3' ReprintOnOverFlow = True DataField = 'Description' DataPipeline = daADOQueryDataView2.WoServices Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'WoServices' mmHeight = 4022 mmLeft = 44979 mmTop = 0 mmWidth = 66411 BandType = 4 end object ppDBText25: TppDBText UserName = 'DBText25' ReprintOnOverFlow = True AutoSize = True DataField = 'Quantity' DataPipeline = daADOQueryDataView2.WoServices DisplayFormat = '#,0.00;-#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoServices' mmHeight = 3969 mmLeft = 112713 mmTop = 0 mmWidth = 12965 BandType = 4 end object ppDBText26: TppDBText UserName = 'DBText26' AutoSize = True DataField = 'UnitCost' DataPipeline = daADOQueryDataView2.WoServices DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoServices' mmHeight = 3969 mmLeft = 137584 mmTop = 0 mmWidth = 13494 BandType = 4 end object ppDBText27: TppDBText UserName = 'DBText27' AutoSize = True DataField = 'SubTotal' DataPipeline = daADOQueryDataView2.WoServices DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoServices' mmHeight = 3969 mmLeft = 166423 mmTop = 0 mmWidth = 14023 BandType = 4 end object myDBCheckBox1: TmyDBCheckBox UserName = 'DBCheckBox1' BooleanFalse = 'N' BooleanTrue = 'Y' DataPipeline = daADOQueryDataView2.WoServices DataField = 'Completed' Transparent = True DataPipelineName = 'WoServices' mmHeight = 5027 mmLeft = 32279 mmTop = 0 mmWidth = 5027 BandType = 4 end object ppDBRichText2: TppDBRichText UserName = 'DBRichText2' DataField = 'Notes_UnitSpecific' DataPipeline = daADOQueryDataView2.WoServices Stretch = True DataPipelineName = 'WoServices' mmHeight = 3969 mmLeft = 1588 mmTop = 5027 mmWidth = 191823 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 end end end end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'Unit' DataPipeline = daADOQueryDataView4.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'Units' mmHeight = 3969 mmLeft = 29369 mmTop = 8467 mmWidth = 62177 BandType = 3 GroupNo = 0 end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'Make' DataPipeline = daADOQueryDataView4.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'Units' mmHeight = 3969 mmLeft = 29369 mmTop = 13494 mmWidth = 62177 BandType = 3 GroupNo = 0 end object ppDBText7: TppDBText UserName = 'DBText7' DataField = 'Model' DataPipeline = daADOQueryDataView4.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'Units' mmHeight = 3969 mmLeft = 29369 mmTop = 18256 mmWidth = 62177 BandType = 3 GroupNo = 0 end object ppDBText13: TppDBText UserName = 'DBText13' DataField = 'Employee' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 29369 mmTop = 23019 mmWidth = 62177 BandType = 3 GroupNo = 0 end object ppDBText14: TppDBText UserName = 'DBText14' DataField = 'WorkGroup' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 29369 mmTop = 28046 mmWidth = 62177 BandType = 3 GroupNo = 0 end object ppDBText15: TppDBText UserName = 'DBText15' DataField = 'HubReading' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 29369 mmTop = 32808 mmWidth = 62177 BandType = 3 GroupNo = 0 end object ppDBText16: TppDBText UserName = 'DBText16' DataField = 'Site' DataPipeline = daADOQueryDataView1.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3969 mmLeft = 112184 mmTop = 8467 mmWidth = 38365 BandType = 3 GroupNo = 0 end object ppDBText17: TppDBText UserName = 'DBText17' DataField = 'Location' DataPipeline = daADOQueryDataView4.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'Units' mmHeight = 3969 mmLeft = 112184 mmTop = 13494 mmWidth = 38365 BandType = 3 GroupNo = 0 end object ppDBText18: TppDBText UserName = 'DBText18' AutoSize = True DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4022 mmLeft = 112184 mmTop = 18256 mmWidth = 23961 BandType = 3 GroupNo = 0 end object ppDBText19: TppDBText UserName = 'DBText19' AutoSize = True DataField = 'CompletedDate' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] ParentDataPipeline = False Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4022 mmLeft = 112184 mmTop = 23019 mmWidth = 24426 BandType = 3 GroupNo = 0 end object ppShape1: TppShape UserName = 'Shape1' mmHeight = 34660 mmLeft = 152400 mmTop = 3175 mmWidth = 42598 BandType = 3 GroupNo = 0 end object ppLabel17: TppLabel UserName = 'Label17' Caption = 'Labor:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsItalic] Transparent = True mmHeight = 4064 mmLeft = 153988 mmTop = 4763 mmWidth = 9948 BandType = 3 GroupNo = 0 end object ppLabel18: TppLabel UserName = 'Label18' Caption = 'Parts:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsItalic] Transparent = True mmHeight = 4064 mmLeft = 153988 mmTop = 11377 mmWidth = 9186 BandType = 3 GroupNo = 0 end object ppLabel20: TppLabel UserName = 'Label20' Caption = 'Other:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsItalic] Transparent = True mmHeight = 4064 mmLeft = 153988 mmTop = 18256 mmWidth = 9779 BandType = 3 GroupNo = 0 end object ppLabel21: TppLabel UserName = 'Label21' Caption = 'Taxes:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsItalic] Transparent = True mmHeight = 4064 mmLeft = 153988 mmTop = 25400 mmWidth = 10583 BandType = 3 GroupNo = 0 end object ppLabel22: TppLabel UserName = 'Label22' Caption = 'Total:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4106 mmLeft = 153988 mmTop = 32279 mmWidth = 9610 BandType = 3 GroupNo = 0 end object ppLine2: TppLine UserName = 'Line2' Weight = 0.75 mmHeight = 1058 mmLeft = 152400 mmTop = 10319 mmWidth = 42598 BandType = 3 GroupNo = 0 end object ppLine5: TppLine UserName = 'Line5' Weight = 0.75 mmHeight = 1058 mmLeft = 152400 mmTop = 16933 mmWidth = 42598 BandType = 3 GroupNo = 0 end object ppLine6: TppLine UserName = 'Line6' Weight = 0.75 mmHeight = 1058 mmLeft = 152400 mmTop = 23813 mmWidth = 42598 BandType = 3 GroupNo = 0 end object ppLine7: TppLine UserName = 'Line7' Weight = 0.75 mmHeight = 1058 mmLeft = 152400 mmTop = 30956 mmWidth = 42598 BandType = 3 GroupNo = 0 end object ppDBText20: TppDBText UserName = 'DBText20' AutoSize = True DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4022 mmLeft = 177229 mmTop = 4763 mmWidth = 16214 BandType = 3 GroupNo = 0 end object ppDBText21: TppDBText UserName = 'DBText201' AutoSize = True DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4022 mmLeft = 177991 mmTop = 11377 mmWidth = 15452 BandType = 3 GroupNo = 0 end object ppDBText22: TppDBText UserName = 'DBText22' AutoSize = True DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4022 mmLeft = 177357 mmTop = 18256 mmWidth = 16044 BandType = 3 GroupNo = 0 end object ppDBText23: TppDBText UserName = 'DBText23' AutoSize = True DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4022 mmLeft = 180192 mmTop = 25400 mmWidth = 13166 BandType = 3 GroupNo = 0 end object ppDBText24: TppDBText UserName = 'DBText24' AutoSize = True DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 4191 mmLeft = 177145 mmTop = 32279 mmWidth = 16298 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppDBRichText1: TppDBRichText UserName = 'DBRichText1' DataField = 'Notes' DataPipeline = daADOQueryDataView1.WoMaster Stretch = True DataPipelineName = 'WoMaster' mmHeight = 4233 mmLeft = 9525 mmTop = 1323 mmWidth = 183092 BandType = 5 GroupNo = 0 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 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 = 'AddressLine1' FieldName = 'AddressLine1' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 23 TableName = 'Company' end object ppField25: TppField FieldAlias = 'AddressLine2P' FieldName = 'AddressLine2P' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 24 TableName = 'Company' end object ppField26: TppField FieldAlias = 'AddressLine3P' FieldName = 'AddressLine3P' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 25 TableName = 'Company' end object ppField27: TppField FieldAlias = 'Fax' FieldName = 'Fax' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 26 TableName = 'Company' end object ppField28: TppField FieldAlias = 'FullName' FieldName = 'FullName' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 27 TableName = 'Company' end object ppField29: TppField FieldAlias = 'Phone' FieldName = 'Phone' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 28 TableName = 'Company' 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, ' ' Company.AddressLine1, ' ' Company.AddressLine2P, ' ' Company.AddressLine3P, Company.Fax, ' ' Company.FullName, Company.Phone' 'FROM WoMaster WoMaster' ' LEFT OUTER JOIN Company Company ON ' ' (Company.FullName = WoMaster.Company)' 'ORDER BY WoMaster.Numbered') SQLType = sqSQL2 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 = 'AddressLine1' DisplayWidth = 50 FieldAlias = 'AddressLine1' FieldLength = 50 FieldName = 'AddressLine1' IsDetail = True SQLFieldName = 'AddressLine1' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField25: TdaField Alias = 'AddressLine2P' DisplayWidth = 50 FieldAlias = 'AddressLine2P' FieldLength = 50 FieldName = 'AddressLine2P' IsDetail = True SQLFieldName = 'AddressLine2P' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField26: TdaField Alias = 'AddressLine3P' DisplayWidth = 50 FieldAlias = 'AddressLine3P' FieldLength = 50 FieldName = 'AddressLine3P' IsDetail = True SQLFieldName = 'AddressLine3P' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField27: TdaField Alias = 'Fax' DisplayWidth = 20 FieldAlias = 'Fax' FieldLength = 20 FieldName = 'Fax' IsDetail = True SQLFieldName = 'Fax' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField28: TdaField Alias = 'FullName' DisplayWidth = 50 FieldAlias = 'FullName' FieldLength = 50 FieldName = 'FullName' IsDetail = True SQLFieldName = 'FullName' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField29: TdaField Alias = 'Phone' DisplayWidth = 20 FieldAlias = 'Phone' FieldLength = 20 FieldName = 'Phone' IsDetail = True SQLFieldName = 'Phone' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField30: 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 = 'Company' JoinType = dajtLeftOuter SQLAlias = 'Company' TableAlias = 'Company' TableName = 'Company' object daTableJoin1: TdaTableJoin ChildType = 6 object daField32: TdaField ChildType = 3 Alias = 'FullName' DisplayWidth = 50 FieldAlias = 'FullName' FieldLength = 50 FieldName = 'FullName' SQLFieldName = 'FullName' TableAlias = 'Company' TableName = 'Company' TableSQLAlias = 'Company' end object daField31: TdaField ChildType = 4 Alias = 'Company' DisplayWidth = 50 FieldAlias = 'Company' FieldLength = 50 FieldName = 'Company' SQLFieldName = 'Company' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_WoServices' Height = 420 Left = 227 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 13 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 = '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 = '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 = 'Numbered' DetailFieldName = 'Numbered' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'Unit' DetailFieldName = 'RecordNumber' 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 object daADOQueryDataView5: TdaADOQueryDataView UserName = 'Query_Parts' Height = 109 Left = 670 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 230 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_WoParts' object Parts: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'Parts' MasterDataPipelineName = 'WoParts' object ppField1: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 50 DisplayWidth = 50 Position = 0 TableName = 'Parts' end object ppField2: TppField FieldAlias = 'RecordNumber' FieldName = 'RecordNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 1 TableName = 'Parts' end object TppMasterFieldLink MasterFieldName = 'Numbered' DetailFieldName = 'Numbered_2' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'ItemNumber' DetailFieldName = 'RecordNumber' DetailSortOrder = soAscending end end object daSQL5: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Parts' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Parts.Numbered, Parts.RecordNumber' 'FROM Parts Parts') SQLType = sqSQL2 object daField1: TdaField Alias = 'Numbered' DisplayWidth = 50 FieldAlias = 'Numbered' FieldLength = 50 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField2: TdaField Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daTable1: TdaTable ChildType = 5 Alias = 'Parts' JoinType = dajtNone SQLAlias = 'Parts' TableAlias = 'Parts' TableName = 'Parts' end object daSQLLink1: TdaSQLLink ChildType = 9 object daField1: TdaField ChildType = 10 Alias = 'ItemNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ItemNumber' FieldLength = 0 FieldName = 'ItemNumber' SQLFieldName = 'ItemNumber' TableAlias = 'WoParts' TableName = 'WoParts' TableSQLAlias = 'WoParts' end object daField2: TdaField ChildType = 11 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end end end end end object ppParameterList1: TppParameterList end end