ReportName = BACKLOG BRICK Services Scheduled By Date ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView3.ScheduledServices NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'BACKLOG - BRICK Services Scheduled By Date' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = '\\400print2\MFGENG4650' 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 = 'BACKLOG - BRICK Services Scheduled By Date' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'BACKLOG - BRICK Services Scheduled By Date.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = False PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '10.07' mmColumnWidth = 0 DataPipelineName = 'ScheduledServices' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 10848 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'BRICK PMs - Services Scheduled By Date' 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 = 529 mmWidth = 99992 BandType = 1 end object ppDBText9: TppDBText UserName = 'DBText9' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False 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 = 156158 mmTop = 529 mmWidth = 45720 BandType = 1 end object ppLabel12: TppLabel UserName = 'Params' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 6615 mmWidth = 36491 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 12435 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 265 mmTop = 10848 mmWidth = 201877 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Service' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 1588 mmTop = 5821 mmWidth = 45773 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'UnitName' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 54240 mmTop = 5821 mmWidth = 31750 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = '#' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 4233 mmLeft = 139700 mmTop = 5821 mmWidth = 4763 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Period' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 128059 mmTop = 5821 mmWidth = 10319 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False 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 = 160867 mmTop = 5821 mmWidth = 15081 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Days Late' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True WordWrap = True mmHeight = 8731 mmLeft = 177800 mmTop = 1323 mmWidth = 10319 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Priority' 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 = 189442 mmTop = 5821 mmWidth = 11113 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'PM Due REPORT' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4911 mmLeft = 1588 mmTop = 794 mmWidth = 54240 BandType = 0 end object ppLabel11: TppLabel UserName = 'Label11' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Status' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 146315 mmTop = 5821 mmWidth = 13229 BandType = 0 end object ppLabel13: TppLabel UserName = 'Label13' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Shift' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 116417 mmTop = 5821 mmWidth = 7144 BandType = 0 end object ppLabel14: TppLabel UserName = 'Label12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Est Labor' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'Times New Roman' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 99484 mmTop = 5821 mmWidth = 14288 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 4233 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Service' DataPipeline = daADOQueryDataView3.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 7 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 2910 mmLeft = 1588 mmTop = 529 mmWidth = 52388 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'UnitName' DataPipeline = daADOQueryDataView3.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 7 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 2910 mmLeft = 54240 mmTop = 529 mmWidth = 47890 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Interval' DataPipeline = daADOQueryDataView3.ScheduledServices DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 141299 mmTop = 529 mmWidth = 1566 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Period' DataPipeline = daADOQueryDataView3.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 128059 mmTop = 529 mmWidth = 8805 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView3.ScheduledServices DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3260 mmLeft = 160867 mmTop = 265 mmWidth = 14139 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Status' DataPipeline = daADOQueryDataView3.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3175 mmLeft = 146844 mmTop = 529 mmWidth = 12965 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'WorkGroup' DataPipeline = daADOQueryDataView3.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 3175 mmLeft = 116681 mmTop = 529 mmWidth = 10319 BandType = 4 end object ppDBText10: TppDBText UserName = 'DBText10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborEstimate' DataPipeline = daADOQueryDataView3.ScheduledServices DisplayFormat = '#,0.00;-#,0.00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Times New Roman' Font.Size = 10 Font.Style = [fsItalic] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 4233 mmLeft = 102659 mmTop = 0 mmWidth = 11113 BandType = 4 end object ppDBRichView1: TppDBRichView UserName = 'DBRichText1' Caption = 'cast_GetDate_ScheduledDat' DataField = 'cast_GetDate_ScheduledDat' DataPipeline = daADOQueryDataView3.ScheduledServices ShiftWithParent = False DataPipelineName = 'ScheduledServices' mmHeight = 3704 mmLeft = 176742 mmTop = 265 mmWidth = 15346 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 Document = { AA0200002D38203120330D0A2D372030202D3120302030203020302035333638 37303931310D0A2D392032203020302032203020310D0A0D0A930100000E0109 5374796C654E616D65060B4E6F726D616C207465787408466F6E744E616D6506 05417269616C0001095374796C654E616D65060748656164696E6708466F6E74 4E616D650605417269616C055374796C650B066673426F6C640005436F6C6F72 0706636C426C75650001095374796C654E616D65060A53756268656164696E67 08466F6E744E616D650605417269616C055374796C650B066673426F6C640005 436F6C6F720706636C4E6176790001095374796C654E616D6506084B6579776F 72647308466F6E744E616D650605417269616C055374796C650B086673497461 6C69630005436F6C6F720708636C4D61726F6F6E0001095374796C654E616D65 06064A756D70203108466F6E744E616D650605417269616C055374796C650B0B 6673556E6465726C696E650005436F6C6F720707636C477265656E044A756D70 090001095374796C654E616D6506064A756D70203208466F6E744E616D650605 417269616C055374796C650B0B6673556E6465726C696E650005436F6C6F7207 07636C477265656E044A756D700900002D392032203020302032203020320D0A 0D0A580000000E01095374796C654E616D65060F506172616772617068205374 796C6504546162730E000001095374796C654E616D65060843656E7465726564 09416C69676E6D656E74070972766143656E74657204546162730E0000002D39 2032203020302032203020340D0A0D0A020000000E002D392030203020302030 203020370D0A2D392032203020302032203020330D0A0D0A2100000000000000 1900000005000000050000000000000000000000300000003000000000302031 20302030203020300D0A2D320D0A} end object ppDBRichView2: TppDBRichView UserName = 'DBRichText2' Caption = 'CostEstimate' DataField = 'CostEstimate' DataPipeline = daADOQueryDataView3.ScheduledServices ShiftWithParent = False DataPipelineName = 'ScheduledServices' mmHeight = 3704 mmLeft = 193146 mmTop = 265 mmWidth = 7673 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 Document = { A90200002D38203120330D0A2D372030202D3120302030203020302035333638 37303931310D0A2D392032203020302032203020310D0A0D0A930100000E0109 5374796C654E616D65060B4E6F726D616C207465787408466F6E744E616D6506 05417269616C0001095374796C654E616D65060748656164696E6708466F6E74 4E616D650605417269616C055374796C650B066673426F6C640005436F6C6F72 0706636C426C75650001095374796C654E616D65060A53756268656164696E67 08466F6E744E616D650605417269616C055374796C650B066673426F6C640005 436F6C6F720706636C4E6176790001095374796C654E616D6506084B6579776F 72647308466F6E744E616D650605417269616C055374796C650B086673497461 6C69630005436F6C6F720708636C4D61726F6F6E0001095374796C654E616D65 06064A756D70203108466F6E744E616D650605417269616C055374796C650B0B 6673556E6465726C696E650005436F6C6F720707636C477265656E044A756D70 090001095374796C654E616D6506064A756D70203208466F6E744E616D650605 417269616C055374796C650B0B6673556E6465726C696E650005436F6C6F7207 07636C477265656E044A756D700900002D392032203020302032203020320D0A 0D0A580000000E01095374796C654E616D65060F506172616772617068205374 796C6504546162730E000001095374796C654E616D65060843656E7465726564 09416C69676E6D656E74070972766143656E74657204546162730E0000002D39 2032203020302032203020340D0A0D0A020000000E002D392030203020302030 203020370D0A2D392032203020302032203020330D0A0D0A2100000000000000 1900000005000000050000000000000000000000130000001300000000302031 20302030203020300D0A320D0A} end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 2117 mmTop = 794 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False 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' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False 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 = 7673 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Service' DataPipeline = daADOQueryDataView3.ScheduledServices DisplayFormat = 'Total Number of Records: #####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True DBCalcType = dcCount DataPipelineName = 'ScheduledServices' mmHeight = 4149 mmLeft = 1323 mmTop = 2910 mmWidth = 21463 BandType = 7 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborEstimate' DataPipeline = daADOQueryDataView3.ScheduledServices Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'Times New Roman' Font.Size = 10 Font.Style = [fsItalic] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'ScheduledServices' mmHeight = 4233 mmLeft = 100013 mmTop = 3440 mmWidth = 13494 BandType = 7 end object ppLabel15: TppLabel UserName = 'Label14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Total Labor Hrs' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Times New Roman' Font.Size = 10 Font.Style = [fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4233 mmLeft = 74613 mmTop = 3440 mmWidth = 23019 BandType = 7 end end object daDataModule3: TdaDataModule object daADOQueryDataView3: TdaADOQueryDataView UserName = 'Query_ScheduledServices' Height = 378 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 373 AutoSearchTabOrder = 1 object ScheduledServices: TppChildDBPipeline AutoCreateFields = False UserName = 'ScheduledServices' object ppField1: TppField FieldAlias = 'Service' FieldName = 'Service' FieldLength = 50 DisplayWidth = 50 Position = 0 TableName = 'Servitem' end object ppField2: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 DisplayWidth = 80 Position = 1 TableName = 'Servitem' end object ppField3: TppField FieldAlias = 'Interval' FieldName = 'Interval' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 2 TableName = 'Servitem' end object ppField4: TppField FieldAlias = 'Period' FieldName = 'Period' FieldLength = 6 DisplayWidth = 6 Position = 3 TableName = 'Servitem' end object ppField5: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 4 TableName = 'Servitem' end object ppField6: TppField FieldAlias = 'LastPerformedDate' FieldName = 'LastPerformedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 5 TableName = 'Servitem' end object ppField7: TppField FieldAlias = 'FromNow' FieldName = 'FromNow' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 6 TableName = 'Servitem' end object ppField8: TppField FieldAlias = 'LastPerformedMiles' FieldName = 'LastPerformedMiles' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 7 TableName = 'Servitem' end object ppField9: TppField FieldAlias = 'Priority' FieldName = 'CostEstimate' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 8 TableName = 'Services' end object ppField10: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 8 DisplayWidth = 8 Position = 9 TableName = 'Servitem' end object ppField11: TppField FieldAlias = 'Picked' FieldName = 'Picked' FieldLength = 1 DisplayWidth = 1 Position = 10 TableName = 'Servitem' end object ppField12: TppField FieldAlias = 'LaborEstimate' FieldName = 'LaborEstimate' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 5 Position = 11 TableName = 'Services' end object ppField13: TppField FieldAlias = 'WorkGroup' FieldName = 'WorkGroup' FieldLength = 25 DisplayWidth = 10 Position = 12 TableName = 'Servitem' end object ppField14: TppField FieldAlias = 'DaysLate' FieldName = 'cast_GetDate_ScheduledDat' FieldLength = 0 Linkable = False DataType = dtDouble DisplayWidth = 0 Position = 13 TableName = 'Servitem' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'ScheduledServices' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Servitem.Service, Servitem.UnitName, ' ' Servitem.Interval, Servitem.Period, ' ' Servitem.ScheduledDate, ' ' Servitem.LastPerformedDate, ' ' Servitem.FromNow, ' ' Servitem.LastPerformedMiles, ' ' Services.CostEstimate, Servitem.Status, ' ' Servitem.Picked, Services.LaborEstimate, ' ' Servitem.WorkGroup, ' ' cast(GetDate()-ScheduledDate as numeric(18,0))*-1 cast_Ge' + 'tDate_ScheduledDat' 'FROM Servitem Servitem INNER JOIN Units Units ON ' ' (Units.RecordNumber = Servitem.Unit)' ' INNER JOIN Services Services ON ' ' (Services.Service = Servitem.Service)' 'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND (' ' ( cast(GetDate()-ScheduledDate as numeric(18,0))*-1 <= -1 ' + ')' ' AND ( Units.Status = '#39'A'#39' )' ' AND ( Units.Location NOT LIKE '#39'Vic%'#39' )' ' AND ( Services.Service NOT LIKE '#39'operator%'#39' )' ' )') SQLType = sqSQL2 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'DaysLate' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' Linkable = False SQLFieldName = 'cast_GetDate_ScheduledDat' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' CalcType = dacaExpression Expression = 'cast(GetDate()-ScheduledDate as numeric(18,0))*-1' end object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoLessThanOrEqualTo Value = '-1' object TdaCalculation ChildType = 8 Alias = 'DaysLate' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' Linkable = False SQLFieldName = 'cast_GetDate_ScheduledDat' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' CalcType = dacaExpression Expression = 'cast(GetDate()-ScheduledDate as numeric(18,0))*-1' end object TdaNumericValue Value = -1.000000000000000000 end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Value = 'A' object TdaField Alias = 'Status' DisplayWidth = 1 FieldAlias = 'Status' FieldLength = 1 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotLike Value = 'Vic' object TdaField Alias = 'Location' DisplayWidth = 10 FieldAlias = 'Location' FieldLength = 10 FieldName = 'Location' Mandatory = True SQLFieldName = 'Location' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotLike Value = 'operator' object TdaField Alias = 'Service' DisplayWidth = 10 FieldAlias = 'Service' FieldLength = 10 FieldName = 'Service' Mandatory = True SQLFieldName = 'Service' TableAlias = 'Services' TableName = 'Services' TableSQLAlias = 'Services' end end object daField1: TdaField Alias = 'Service' DisplayWidth = 50 FieldAlias = 'Service' FieldLength = 50 FieldName = 'Service' SQLFieldName = 'Service' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField2: TdaField Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField3: TdaField Alias = 'Interval' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'Interval' FieldLength = 5 FieldName = 'Interval' SQLFieldName = 'Interval' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField4: TdaField Alias = 'Period' DisplayWidth = 6 FieldAlias = 'Period' FieldLength = 6 FieldName = 'Period' SQLFieldName = 'Period' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField5: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField6: TdaField Alias = 'LastPerformedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'LastPerformedDate' FieldLength = 0 FieldName = 'LastPerformedDate' SQLFieldName = 'LastPerformedDate' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField7: TdaField Alias = 'FromNow' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'FromNow' FieldLength = 5 FieldName = 'FromNow' SQLFieldName = 'FromNow' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField8: TdaField Alias = 'LastPerformedMiles' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LastPerformedMiles' FieldLength = 5 FieldName = 'LastPerformedMiles' SQLFieldName = 'LastPerformedMiles' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField9: TdaField Alias = 'Priority' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'CostEstimate' FieldLength = 5 FieldName = 'CostEstimate' IsDetail = True SQLFieldName = 'CostEstimate' TableAlias = 'Services' TableName = 'Services' TableSQLAlias = 'Services' end object daField10: TdaField Alias = 'Status' DisplayWidth = 8 FieldAlias = 'Status' FieldLength = 8 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField11: TdaField Alias = 'Picked' DisplayWidth = 1 FieldAlias = 'Picked' FieldLength = 1 FieldName = 'Picked' SQLFieldName = 'Picked' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField12: TdaField Alias = 'LaborEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborEstimate' FieldLength = 5 FieldName = 'LaborEstimate' IsDetail = True SQLFieldName = 'LaborEstimate' TableAlias = 'Services' TableName = 'Services' TableSQLAlias = 'Services' end object daField13: TdaField Alias = 'WorkGroup' DisplayWidth = 10 FieldAlias = 'WorkGroup' FieldLength = 25 FieldName = 'WorkGroup' SQLFieldName = 'WorkGroup' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField14: TdaField ChildType = 2 Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField15: TdaField ChildType = 2 Alias = 'CostEstimate' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'CostEstimate' FieldLength = 5 FieldName = 'CostEstimate' SQLFieldName = 'CostEstimate' TableAlias = 'Services' TableName = 'Services' TableSQLAlias = 'Services' end object daField16: TdaField ChildType = 2 Alias = 'Service' DisplayWidth = 50 FieldAlias = 'Service' FieldLength = 50 FieldName = 'Service' SQLFieldName = 'Service' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daField17: TdaField ChildType = 2 Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end object daTable1: TdaTable ChildType = 5 Alias = 'Servitem' JoinType = dajtNone SQLAlias = 'Servitem' TableAlias = 'Servitem' TableName = 'Servitem' end object daTable2: TdaTable ChildType = 5 Alias = 'Units' SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' object daTableJoin1: TdaTableJoin ChildType = 6 object daField19: 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 daField18: TdaField ChildType = 4 Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end end end object daTable3: TdaTable ChildType = 5 Alias = 'Services' SQLAlias = 'Services' TableAlias = 'Services' TableName = 'Services' object daTableJoin2: TdaTableJoin ChildType = 6 object daField21: TdaField ChildType = 3 Alias = 'Service' DisplayWidth = 50 FieldAlias = 'Service' FieldLength = 50 FieldName = 'Service' SQLFieldName = 'Service' TableAlias = 'Services' TableName = 'Services' TableSQLAlias = 'Services' end object daField20: TdaField ChildType = 4 Alias = 'Service' DisplayWidth = 50 FieldAlias = 'Service' FieldLength = 50 FieldName = 'Service' SQLFieldName = 'Service' TableAlias = 'Servitem' TableName = 'Servitem' TableSQLAlias = 'Servitem' end end end end end end object ppParameterList1: TppParameterList end end