ReportName = Work Order Performance By Employee ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WorkOrders NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Work Order Performance By Employee' 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 Performance By Employee' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Work Order Performance By Employee.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 SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 0 DataPipelineName = 'WorkOrders' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 12171 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Work Order Performance By Employee' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6604 mmLeft = 1323 mmTop = 1058 mmWidth = 93218 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 = 166338 mmTop = 1058 mmWidth = 35010 BandType = 1 end object ppLabel12: TppLabel UserName = 'Params' Caption = 'CompletedDate: 05/20/04- 05/20/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 = 7938 mmWidth = 51181 BandType = 1 end end object ppHeaderBand1: TppHeaderBand Visible = False mmBottomOffset = 0 mmHeight = 7673 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 1852 mmLeft = 1323 mmTop = 5821 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3683 mmLeft = 3704 mmTop = 1323 mmWidth = 10837 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Caption = 'Unit Name' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 15346 mmTop = 1323 mmWidth = 60854 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Caption = 'Employee' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 79111 mmTop = 1323 mmWidth = 29104 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' Caption = 'Scheduled' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3895 mmLeft = 129382 mmTop = 1323 mmWidth = 13801 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' 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 = 150548 mmTop = 1323 mmWidth = 14023 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Caption = 'Days Past Due' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3969 mmLeft = 172244 mmTop = 1323 mmWidth = 19579 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 = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3969 mmLeft = 109538 mmTop = 1323 mmWidth = 17463 BandType = 0 end end object ppDetailBand1: TppDetailBand Visible = False PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 3969 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 = 3175 mmLeft = 3704 mmTop = 529 mmWidth = 9525 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'UnitName' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 15346 mmTop = 529 mmWidth = 60854 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'Employee' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 79111 mmTop = 529 mmWidth = 29104 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True 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 = 3302 mmLeft = 129382 mmTop = 529 mmWidth = 13716 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' AutoSize = True 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 = 3302 mmLeft = 150548 mmTop = 529 mmWidth = 13716 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'LaborHours' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 109538 mmTop = 529 mmWidth = 17198 BandType = 4 end object ppDBText10: TppDBText UserName = 'DBText10' DataField = 'DATEDIFF_day_WoMaster_Sch' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 172773 mmTop = 529 mmWidth = 17198 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 = 1323 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 = 5821 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = 'Total Number of Records: #####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True DBCalcType = dcCount DataPipelineName = 'WorkOrders' mmHeight = 3725 mmLeft = 1588 mmTop = 1323 mmWidth = 23326 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'Employee' DataPipeline = daADOQueryDataView1.WorkOrders KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WorkOrders' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBText9: TppDBText UserName = 'DBText9' AutoSize = True DataField = 'Employee' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 4233 mmLeft = 17463 mmTop = 1058 mmWidth = 14901 BandType = 3 GroupNo = 0 end object ppLabel10: TppLabel UserName = 'Label10' AutoSize = False Caption = 'Employee:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 1588 mmTop = 1058 mmWidth = 15081 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 35190 mmPrintPosition = 0 object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Summary for Employee' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4149 mmLeft = 10625 mmTop = 3175 mmWidth = 34883 BandType = 5 GroupNo = 0 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'Employee' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 4233 mmLeft = 46567 mmTop = 3175 mmWidth = 14901 BandType = 5 GroupNo = 0 end object ppLabel11: TppLabel UserName = 'Label11' Caption = 'Total Labor Hours' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 89694 mmTop = 8202 mmWidth = 25135 BandType = 5 GroupNo = 0 end object ppLabel13: TppLabel UserName = 'Label13' Caption = 'Date Range:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 98161 mmTop = 3175 mmWidth = 16669 BandType = 5 GroupNo = 0 end object ppLabel16: TppLabel UserName = 'Params1' Caption = 'CompletedDate: 05/20/04- 05/20/04' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 117211 mmTop = 3175 mmWidth = 46313 BandType = 5 GroupNo = 0 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' DataField = 'LaborHours' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetGroup = ppGroup1 Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3440 mmLeft = 117211 mmTop = 8467 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppLabel18: TppLabel UserName = 'Label18' Caption = 'On Time Work Orders:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 83873 mmTop = 13229 mmWidth = 31221 BandType = 5 GroupNo = 0 end object ppLabel20: TppLabel UserName = 'Label20' Caption = 'Late Work Orders:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 90223 mmTop = 18785 mmWidth = 25135 BandType = 5 GroupNo = 0 end object ppLabel15: TppLabel UserName = 'Label15' Caption = '% Completed On Time:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 84138 mmTop = 23813 mmWidth = 31485 BandType = 5 GroupNo = 0 end object ppDBCalc7: TppDBCalc UserName = 'DBCalc7' DataField = 'DATEDIFF_day_WoMaster_Sch' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetGroup = ppGroup1 Transparent = True DBCalcType = dcMaximum DataPipelineName = 'WorkOrders' mmHeight = 3704 mmLeft = 117211 mmTop = 28575 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppLabel17: TppLabel UserName = 'Label17' Caption = 'Max Days past due:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 89165 mmTop = 28575 mmWidth = 26458 BandType = 5 GroupNo = 0 end object ppVariable1: TppVariable UserName = 'Variable1' CalcOrder = 0 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetComponent = ppGroup1 ResetType = veGroupStart Transparent = True mmHeight = 3704 mmLeft = 117211 mmTop = 13229 mmWidth = 12700 BandType = 5 GroupNo = 0 end object ppVariable2: TppVariable UserName = 'Variable2' CalcOrder = 1 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetComponent = ppGroup1 ResetType = veGroupStart Transparent = True mmHeight = 3704 mmLeft = 117211 mmTop = 18785 mmWidth = 12700 BandType = 5 GroupNo = 0 end object ppVariable3: TppVariable UserName = 'Variable3' CalcOrder = 2 DisplayFormat = '####%' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetType = veGroupStart Transparent = True mmHeight = 3704 mmLeft = 117211 mmTop = 23813 mmWidth = 12700 BandType = 5 GroupNo = 0 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetGroup = ppGroup1 Transparent = True Visible = False DBCalcType = dcCount DataPipelineName = 'WorkOrders' mmHeight = 3810 mmLeft = 39688 mmTop = 23283 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppLine3: TppLine UserName = 'Line3' Pen.Color = clGray Pen.Width = 2 Weight = 1.5 mmHeight = 1588 mmLeft = 794 mmTop = 1323 mmWidth = 200555 BandType = 5 GroupNo = 0 end object ppLine4: TppLine UserName = 'Line4' Pen.Color = clGray Pen.Width = 2 Weight = 1.5 mmHeight = 1588 mmLeft = 1323 mmTop = 33602 mmWidth = 200555 BandType = 5 GroupNo = 0 end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_WorkOrders' Height = 277 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 = 'Employee' FieldName = 'Employee' FieldLength = 35 DisplayWidth = 35 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'Company' FieldName = 'Company' FieldLength = 50 DisplayWidth = 50 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 25 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 5 TableName = 'WoMaster' end object ppField7: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 6 TableName = 'WoMaster' end object ppField8: TppField FieldAlias = 'WOCategoryID' FieldName = 'WOCategoryID' FieldLength = 25 DisplayWidth = 25 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 = 'WorkGroup' FieldName = 'WorkGroup' FieldLength = 25 DisplayWidth = 25 Position = 9 TableName = 'WoMaster' end object ppField11: TppField FieldAlias = 'DaysDiff ' FieldName = 'DATEDIFF_day_WoMaster_Sch' FieldLength = 0 Linkable = False DataType = dtInteger DisplayWidth = 0 Position = 10 TableName = 'WoMaster' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WorkOrders' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT WoMaster.Numbered, WoMaster.UnitName, ' ' WoMaster.Employee, WoMaster.Company, ' ' WoMaster.Site, WoMaster.ScheduledDate, ' ' WoMaster.CompletedDate, ' ' WoMaster.WOCategoryID, ' ' WoMaster.LaborHours, WoMaster.WorkGroup, ' ' DATEDIFF(day, WoMaster.ScheduledDate, WoMaster.CompletedD' + 'ate) DATEDIFF_day_WoMaster_Sch' 'FROM WoMaster WoMaster' 'ORDER BY WoMaster.Employee, WoMaster.Numbered, ' ' WoMaster.ScheduledDate, ' ' WoMaster.CompletedDate') SQLType = sqSQL2 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'DaysDiff ' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' Linkable = False SQLFieldName = 'DATEDIFF_day_WoMaster_Sch' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' CalcType = dacaExpression Expression = 'DATEDIFF(day, WoMaster.ScheduledDate, WoMaster.CompletedDate) ' 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 = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'Company' DisplayWidth = 50 FieldAlias = 'Company' FieldLength = 50 FieldName = 'Company' SQLFieldName = 'Company' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'Site' DisplayWidth = 25 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField8: TdaField Alias = 'WOCategoryID' DisplayWidth = 25 FieldAlias = 'WOCategoryID' FieldLength = 25 FieldName = 'WOCategoryID' SQLFieldName = 'WOCategoryID' 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 = 'WorkGroup' DisplayWidth = 25 FieldAlias = 'WorkGroup' FieldLength = 25 FieldName = 'WorkGroup' SQLFieldName = 'WorkGroup' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField11: TdaField ChildType = 2 Alias = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' 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 daField13: TdaField ChildType = 2 Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField14: TdaField ChildType = 2 Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' 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 raCodeModule1: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F 5661726961626C65314F6E43616C630B50726F6772616D54797065070B747450 726F63656475726506536F7572636506C470726F636564757265205661726961 626C65314F6E43616C63287661722056616C75653A2056617269616E74293B0D 0A626567696E0D0A696620576F726B4F72646572735B27446179734469666620 275D3C3D30207468656E0D0A095661726961626C65312E4173496E7465676572 203A3D5661726961626C65312E4173496E74656765722B310D0A656C73650D0A 095661726961626C65322E4173496E7465676572203A3D5661726961626C6532 2E4173496E74656765722B313B0D0A656E643B0D0A0D436F6D706F6E656E744E 616D6506095661726961626C6531094576656E744E616D6506064F6E43616C63 074576656E74494402210001060F5472614576656E7448616E646C65720B5072 6F6772616D4E616D65060F5661726961626C65334F6E43616C630B50726F6772 616D54797065070B747450726F63656475726506536F75726365067F70726F63 6564757265205661726961626C65334F6E43616C63287661722056616C75653A 2056617269616E74293B0D0A626567696E0D0A205661726961626C65332E4173 446F75626C65203A3D5661726961626C65312E4173496E7465676572202F2044 4243616C63332E56616C7565202A203130303B0D0A656E643B0D0A0D436F6D70 6F6E656E744E616D6506095661726961626C6533094576656E744E616D650606 4F6E43616C63074576656E74494402210001060F5472614576656E7448616E64 6C65720B50726F6772616D4E616D65060F5661726961626C65324F6E43616C63 0B50726F6772616D54797065070B747450726F63656475726506536F75726365 064E70726F636564757265205661726961626C65324F6E43616C632876617220 56616C75653A2056617269616E74293B0D0A626567696E0D0A0D0A202056616C 7565203A3D200D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D650609 5661726961626C6532094576656E744E616D6506064F6E43616C63074576656E 74494402210000} end object ppParameterList1: TppParameterList end end