ReportName = Units Expense Detailed Work Orders ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WoMaster PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Units Expense Detailed Work Orders' 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 Work Orders' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Units Expense Detailed Work Orders.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 ShowAutoSearchDialog = 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 Work Orders' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6562 mmLeft = 1323 mmTop = 3175 mmWidth = 86191 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 ppLabel12: TppLabel UserName = 'Params' Caption = 'CompletedDate: 01/01/00- 09/30/04' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 9790 mmWidth = 51181 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 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 = 3969 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 = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 14309 mmTop = 265 mmWidth = 13208 BandType = 4 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 = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 33073 mmTop = 265 mmWidth = 17198 BandType = 4 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 = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 56356 mmTop = 265 mmWidth = 17992 BandType = 4 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 = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 75671 mmTop = 265 mmWidth = 16933 BandType = 4 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 = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 93927 mmTop = 265 mmWidth = 17727 BandType = 4 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 = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 112977 mmTop = 265 mmWidth = 14817 BandType = 4 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 = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3260 mmLeft = 129117 mmTop = 265 mmWidth = 16669 BandType = 4 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 = 3440 mmLeft = 3440 mmTop = 1852 mmWidth = 20373 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 object ppDBCalc12: TppDBCalc UserName = 'DBCalc12' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] Transparent = True DBCalcType = dcCount DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 33073 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 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 ppLine5: TppLine UserName = 'Line5' Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 53975 mmTop = 1058 mmWidth = 90752 BandType = 5 GroupNo = 0 end object ppDBCalc5: TppDBCalc UserName = 'DBCalc101' 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 = 3440 mmLeft = 57150 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppLabel8: TppLabel UserName = 'Label8' 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 ppDBCalc11: TppDBCalc UserName = 'DBCalc5' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WoMaster DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] ResetGroup = ppGroup1 Transparent = True DBCalcType = dcCount DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 33073 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 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 = 'Type' FieldName = 'Type' FieldLength = 25 IsDetail = True DisplayWidth = 25 Position = 23 TableName = 'Units' end object ppField25: TppField FieldAlias = 'CategoryID' FieldName = 'CategoryID' 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.Type, Units.CategoryID' 'FROM WoMaster WoMaster INNER JOIN Units Units ON ' ' (Units.RecordNumber = WoMaster.Unit)' 'WHERE ( WoMaster.CompletedDate IS NOT NULL )' ' AND ( WoMaster.CompletedDate BETWEEN CONVERT(DATETIME,'#39'20' + '00-01-01'#39',120) AND CONVERT(DATETIME,'#39'2004-09-30'#39',120) )' 'ORDER BY WoMaster.UnitName, WoMaster.Unit, ' ' WoMaster.Numbered') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotBlank Value = '10/09/03 11:06:48 AM' 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 daCriteria2: TdaCriteria ChildType = 7 Level = 0 Operator = dacoBetween Value = '01/01/00, 09/30/04' object TdaField Alias = 'CompletedDate' AutoSearch = True 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 = 'Type' DisplayWidth = 25 FieldAlias = 'Type' FieldLength = 25 FieldName = 'Type' IsDetail = True SQLFieldName = 'Type' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField25: TdaField Alias = 'CategoryID' DisplayWidth = 25 FieldAlias = 'CategoryID' FieldLength = 25 FieldName = 'CategoryID' IsDetail = True SQLFieldName = 'CategoryID' 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 end object ppParameterList1: TppParameterList end end