ReportName = Work Order Expense Detail By Unit ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WorkOrders NoDataBehaviors = [ndBlankReport] 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 Order Expense Detail By Unit' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Work Order Expense Detail By Unit.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True DeviceType = 'Screen' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 0 DataPipelineName = 'WorkOrders' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 14023 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Work Order - Expenses Detail By Unit' 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 = 1588 mmWidth = 89578 BandType = 1 end object ppDBText10: TppDBText UserName = 'DBText10' 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 Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 167217 mmTop = 1588 mmWidth = 35010 BandType = 1 end object ppLabel13: TppLabel UserName = 'Params' Caption = 'Params' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4233 mmLeft = 1323 mmTop = 8731 mmWidth = 73819 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 7408 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 3969 mmLeft = 1323 mmTop = 6350 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' Caption = 'WO Number' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4106 mmLeft = 7144 mmTop = 1323 mmWidth = 18542 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Completed' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4106 mmLeft = 52652 mmTop = 1323 mmWidth = 15536 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' Caption = 'Labor Hours' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 75406 mmTop = 1323 mmWidth = 18923 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Labor Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 102394 mmTop = 1323 mmWidth = 16171 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' Caption = 'Parts Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4233 mmLeft = 124354 mmTop = 1323 mmWidth = 14817 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' Caption = 'Taxes' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 146844 mmTop = 1323 mmWidth = 8636 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Caption = 'Other Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 162190 mmTop = 1323 mmWidth = 15706 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' Caption = 'Total Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4106 mmLeft = 186172 mmTop = 1323 mmWidth = 14986 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Scheduled' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 28046 mmTop = 1323 mmWidth = 15081 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 4233 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3260 mmLeft = 7144 mmTop = 529 mmWidth = 12700 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'CompletedDate' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3260 mmLeft = 52652 mmTop = 529 mmWidth = 18256 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'LaborHours' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 79904 mmTop = 529 mmWidth = 14552 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3260 mmLeft = 105569 mmTop = 529 mmWidth = 13039 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3260 mmLeft = 126736 mmTop = 529 mmWidth = 12488 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' AutoSize = True DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3260 mmLeft = 144992 mmTop = 529 mmWidth = 10499 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' AutoSize = True DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3260 mmLeft = 164836 mmTop = 529 mmWidth = 12912 BandType = 4 end object ppDBText9: TppDBText UserName = 'DBText9' AutoSize = True DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3260 mmLeft = 188934 mmTop = 529 mmWidth = 12150 BandType = 4 end object ppDBText11: TppDBText UserName = 'DBText11' DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 28046 mmTop = 529 mmWidth = 18256 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' 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 ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 5556 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Weight = 0.75 mmHeight = 529 mmLeft = 88106 mmTop = 794 mmWidth = 112977 BandType = 7 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 183886 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 160602 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 144198 mmTop = 1852 mmWidth = 11377 BandType = 7 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 121973 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppDBCalc5: TppDBCalc UserName = 'DBCalc5' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 101336 mmTop = 1852 mmWidth = 17198 BandType = 7 end object ppDBCalc6: TppDBCalc UserName = 'DBCalc6' DataField = 'LaborHours' DataPipeline = daADOQueryDataView1.WorkOrders 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 = 'WorkOrders' mmHeight = 3175 mmLeft = 80698 mmTop = 1852 mmWidth = 13758 BandType = 7 end object ppLabel11: TppLabel UserName = 'Label11' Caption = 'Totals This Report:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3175 mmLeft = 1058 mmTop = 1852 mmWidth = 24077 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'UnitName' DataPipeline = daADOQueryDataView1.WorkOrders KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WorkOrders' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'UnitName' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold, fsItalic] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3302 mmLeft = 1058 mmTop = 1852 mmWidth = 60325 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBCalc7: TppDBCalc UserName = 'DBCalc7' DataField = 'LaborHours' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '#,0.00;-#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 81492 mmTop = 1323 mmWidth = 13758 BandType = 5 GroupNo = 0 end object ppLabel12: TppLabel UserName = 'Label12' Caption = 'Totals This Unit:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 1852 mmTop = 1323 mmWidth = 20574 BandType = 5 GroupNo = 0 end object ppLine4: TppLine UserName = 'Line4' Weight = 0.75 mmHeight = 529 mmLeft = 88106 mmTop = 794 mmWidth = 112977 BandType = 5 GroupNo = 0 end object ppDBCalc8: TppDBCalc UserName = 'DBCalc8' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 101336 mmTop = 1323 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppDBCalc9: TppDBCalc UserName = 'DBCalc9' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 121973 mmTop = 1323 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppDBCalc10: TppDBCalc UserName = 'DBCalc10' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 144198 mmTop = 1323 mmWidth = 11377 BandType = 5 GroupNo = 0 end object ppDBCalc11: TppDBCalc UserName = 'DBCalc11' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 160602 mmTop = 1323 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppDBCalc12: TppDBCalc UserName = 'DBCalc12' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '$#,0.00;-$#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 183886 mmTop = 1323 mmWidth = 17198 BandType = 5 GroupNo = 0 end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_WorkOrders' Height = 245 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object WorkOrders: TppChildDBPipeline AutoCreateFields = False UserName = 'WorkOrders' 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 = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'LaborHours' FieldName = 'LaborHours' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'LaborCost' FieldName = 'LaborCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'PartsCost' FieldName = 'PartsCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 5 TableName = 'WoMaster' end object ppField7: TppField FieldAlias = 'TaxCost' FieldName = 'TaxCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 6 TableName = 'WoMaster' end object ppField8: TppField FieldAlias = 'OtherCost' FieldName = 'OtherCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 7 TableName = 'WoMaster' end object ppField9: TppField FieldAlias = 'TotalCost' FieldName = 'TotalCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 8 TableName = 'WoMaster' end object ppField10: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 9 TableName = 'WoMaster' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WorkOrders' IsCaseSensitive = True LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT WoMaster.Numbered, WoMaster.UnitName, ' ' WoMaster.CompletedDate, ' ' WoMaster.LaborHours, WoMaster.LaborCost, ' ' WoMaster.PartsCost, WoMaster.TaxCost, ' ' WoMaster.OtherCost, WoMaster.TotalCost, ' ' WoMaster.ScheduledDate' 'FROM WoMaster WoMaster' 'ORDER BY WoMaster.UnitName, WoMaster.Numbered') SQLType = sqSQL1 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 = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'LaborHours' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborHours' FieldLength = 5 FieldName = 'LaborHours' SQLFieldName = 'LaborHours' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'LaborCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'LaborCost' FieldLength = 2 FieldName = 'LaborCost' SQLFieldName = 'LaborCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'PartsCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'PartsCost' FieldLength = 2 FieldName = 'PartsCost' SQLFieldName = 'PartsCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField Alias = 'TaxCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'TaxCost' FieldLength = 2 FieldName = 'TaxCost' SQLFieldName = 'TaxCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField8: TdaField Alias = 'OtherCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'OtherCost' FieldLength = 2 FieldName = 'OtherCost' SQLFieldName = 'OtherCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField9: TdaField Alias = 'TotalCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'TotalCost' FieldLength = 2 FieldName = 'TotalCost' SQLFieldName = 'TotalCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField10: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField11: TdaField ChildType = 2 Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField12: 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 end end end object ppParameterList1: TppParameterList end end