ReportName = PM Services Analysis Report
ReportGroup = Maintenance
object ppReport1: TppReport
  AutoStop = False
  DataPipeline = daADOQueryDataView1.WorkOrders
  NoDataBehaviors = [ndBlankReport]
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'PM Services Analysis Report'
  PrinterSetup.Orientation = poLandscape
  PrinterSetup.PaperName = 'Letter'
  PrinterSetup.PrinterName = 'HP LaserJet 1022'
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 215900
  PrinterSetup.mmPaperWidth = 279401
  PrinterSetup.PaperSize = 1
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = dpReports
  Template.DatabaseSettings.Name = 'PM Services Analysis Report'
  Template.DatabaseSettings.NameField = 'ReportName'
  Template.DatabaseSettings.TemplateField = 'NewDef'
  Template.FileName = 'PM Services Analysis Report.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 = '<FindText>'
  TextSearchSettings.Enabled = True
  Left = 218
  Top = 155
  Version = '10.07'
  mmColumnWidth = 0
  DataPipelineName = 'WorkOrders'
  object ppTitleBand1: TppTitleBand
    mmBottomOffset = 0
    mmHeight = 20902
    mmPrintPosition = 0
    object ppLabel1: TppLabel
      UserName = 'Label1'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'PM Services Analysis Report'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 14
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taCentered
      Transparent = True
      mmHeight = 5821
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 263261
      BandType = 1
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      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 = 14
      Font.Style = [fsBold, fsItalic]
      ParentDataPipeline = False
      TextAlignment = taCentered
      Transparent = True
      DataPipelineName = 'dpCompanyInfo'
      mmHeight = 5821
      mmLeft = 1323
      mmTop = 7144
      mmWidth = 262996
      BandType = 1
    end
    object ppLabel15: TppLabel
      UserName = 'params'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'CompletedDate: 2/27/2000- 2/27/2008'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 10
      Font.Style = []
      TextAlignment = taCentered
      Transparent = True
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 12965
      mmWidth = 263261
      BandType = 1
    end
  end
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 7408
    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 = 1588
      mmLeft = 265
      mmTop = 6085
      mmWidth = 262203
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = 'Label2'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'WO #'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 15081
      BandType = 0
    end
    object ppLabel6: TppLabel
      UserName = 'Label6'
      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 = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 17992
      mmTop = 1058
      mmWidth = 18785
      BandType = 0
    end
    object ppLabel7: TppLabel
      UserName = 'Label7'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Day Allowed'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 191823
      mmTop = 1058
      mmWidth = 21960
      BandType = 0
    end
    object ppLabel8: TppLabel
      UserName = 'Label8'
      AutoSize = False
      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 = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 109538
      mmTop = 1058
      mmWidth = 13229
      BandType = 0
    end
    object ppLabel9: TppLabel
      UserName = 'Label9'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Interval'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 128323
      mmTop = 1058
      mmWidth = 15610
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      AutoSize = False
      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 = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 147109
      mmTop = 1058
      mmWidth = 20108
      BandType = 0
    end
    object ppLabel5: TppLabel
      UserName = 'Label5'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Performed'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 170657
      mmTop = 1058
      mmWidth = 18785
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'Label4'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Days Taken'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 216165
      mmTop = 1058
      mmWidth = 21960
      BandType = 0
    end
    object ppLabel10: TppLabel
      UserName = 'Label10'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Over / Under'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 239713
      mmTop = 1058
      mmWidth = 21960
      BandType = 0
    end
    object ppLabel11: TppLabel
      UserName = 'Label11'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Unit'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 55827
      mmTop = 1058
      mmWidth = 18785
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    PrintHeight = phDynamic
    mmBottomOffset = 0
    mmHeight = 5292
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'DBText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      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 = 1323
      mmTop = 529
      mmWidth = 14817
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      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 = 147109
      mmTop = 529
      mmWidth = 20108
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Performed'
      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 = 170657
      mmTop = 529
      mmWidth = 18521
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Description'
      DataPipeline = daADOQueryDataView1.WorkOrders
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'WorkOrders'
      mmHeight = 3175
      mmLeft = 17463
      mmTop = 529
      mmWidth = 36513
      BandType = 4
    end
    object ppDBText7: TppDBText
      UserName = 'DBText7'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Period'
      DataPipeline = daADOQueryDataView2.Units
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'Units'
      mmHeight = 3175
      mmLeft = 109802
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    end
    object ppDBText8: TppDBText
      UserName = 'DBText8'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Interval'
      DataPipeline = daADOQueryDataView2.Units
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'Units'
      mmHeight = 3175
      mmLeft = 128323
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    end
    object ppVariable1: TppVariable
      UserName = 'Variable1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 0
      DataType = dtDouble
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3260
      mmLeft = 197909
      mmTop = 529
      mmWidth = 11938
      BandType = 4
    end
    object ppVariable2: TppVariable
      UserName = 'Variable2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 1
      DataType = dtDouble
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 220928
      mmTop = 529
      mmWidth = 11906
      BandType = 4
    end
    object ppVariable3: TppVariable
      UserName = 'Variable3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 2
      DataType = dtDouble
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 243153
      mmTop = 529
      mmWidth = 14023
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText6'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      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 = 55827
      mmTop = 529
      mmWidth = 51594
      BandType = 4
    end
  end
  object ppFooterBand1: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 6350
    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 = 1323
      mmTop = 5027
      mmWidth = 260880
      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 = 3725
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 29125
      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 = 3725
      mmLeft = 251619
      mmTop = 1323
      mmWidth = 8594
      BandType = 8
    end
  end
  object ppSummaryBand1: TppSummaryBand
    mmBottomOffset = 0
    mmHeight = 21431
    mmPrintPosition = 0
    object ppLabel12: TppLabel
      UserName = 'Label12'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'On Time:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3260
      mmLeft = 158666
      mmTop = 10054
      mmWidth = 11726
      BandType = 7
    end
    object ppLabel13: TppLabel
      UserName = 'Label13'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Not On Time:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3260
      mmLeft = 153459
      mmTop = 14288
      mmWidth = 16933
      BandType = 7
    end
    object ppLabel14: TppLabel
      UserName = 'Label14'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Total Services:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 151607
      mmTop = 6085
      mmWidth = 18785
      BandType = 7
    end
    object ppVariable4: TppVariable
      UserName = 'Variable4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 0
      DataType = dtDouble
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 171186
      mmTop = 6085
      mmWidth = 9525
      BandType = 7
    end
    object ppVariable5: TppVariable
      UserName = 'Variable5'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 1
      DataType = dtDouble
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 171186
      mmTop = 10054
      mmWidth = 9525
      BandType = 7
    end
    object ppLine3: TppLine
      UserName = 'Line3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Weight = 0.750000000000000000
      mmHeight = 2117
      mmLeft = 4763
      mmTop = 2117
      mmWidth = 257176
      BandType = 7
    end
    object ppVariable6: TppVariable
      UserName = 'Variable6'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 2
      DataType = dtDouble
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 171186
      mmTop = 14288
      mmWidth = 9525
      BandType = 7
    end
    object ppVariable7: TppVariable
      UserName = 'Variable7'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 3
      DataType = dtDouble
      DisplayFormat = '0.00 %'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 182034
      mmTop = 10054
      mmWidth = 11906
      BandType = 7
    end
    object ppVariable8: TppVariable
      UserName = 'Variable8'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 4
      DataType = dtDouble
      DisplayFormat = '0.00 %'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 182034
      mmTop = 14288
      mmWidth = 11906
      BandType = 7
    end
    object ppLabel16: TppLabel
      UserName = 'Label16'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Average Days To Complete:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 52917
      mmTop = 14288
      mmWidth = 35719
      BandType = 7
    end
    object ppVariable9: TppVariable
      UserName = 'Variable11'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 5
      DataType = dtDouble
      DisplayFormat = '#,0.00;(#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 89429
      mmTop = 14288
      mmWidth = 11906
      BandType = 7
    end
    object ppLabel17: TppLabel
      UserName = 'Label17'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Non Complete Services:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 57944
      mmTop = 6085
      mmWidth = 30692
      BandType = 7
    end
    object ppVariable10: TppVariable
      UserName = 'Variable9'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 6
      DataType = dtDouble
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 89429
      mmTop = 6085
      mmWidth = 11906
      BandType = 7
    end
    object ppLabel18: TppLabel
      UserName = 'Label18'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Complete Services:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 64029
      mmTop = 10054
      mmWidth = 24606
      BandType = 7
    end
    object ppVariable11: TppVariable
      UserName = 'Variable10'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 7
      DataType = dtDouble
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 89429
      mmTop = 10054
      mmWidth = 11906
      BandType = 7
    end
    object ppVariable12: TppVariable
      UserName = 'Variable12'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 8
      DataType = dtDouble
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      Visible = False
      mmHeight = 3175
      mmLeft = 102659
      mmTop = 10054
      mmWidth = 13494
      BandType = 7
    end
  end
  object ppGroup1: TppGroup
    BreakName = 'Completed'
    DataPipeline = daADOQueryDataView1.WorkOrders
    OutlineSettings.CreateNode = True
    ReprintOnSubsequentPage = False
    UserName = 'Group1'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'WorkOrders'
    object ppGroupHeaderBand1: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 6879
      mmPrintPosition = 0
      object myDBCheckBox1: TmyDBCheckBox
        UserName = 'DBCheckBox1'
        CheckBoxColor = clWindowText
        BooleanFalse = 'N'
        BooleanTrue = 'Y'
        DataPipeline = daADOQueryDataView1.WorkOrders
        DataField = 'Completed'
        DataPipelineName = 'WorkOrders'
        mmHeight = 4498
        mmLeft = 3704
        mmTop = 1852
        mmWidth = 3440
        BandType = 3
        GroupNo = 0
      end
      object ppVariable13: TppVariable
        UserName = 'varGroup'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        BlankWhenZero = False
        CalcOrder = 0
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3440
        mmLeft = 8996
        mmTop = 2117
        mmWidth = 52917
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
  end
  object raCodeModule1: TraCodeModule
    ProgramStream = {
      01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65061D
      5265706F72744265666F72654F70656E44617461506970656C696E65730B5072
      6F6772616D54797065070B747450726F63656475726506536F7572636506A570
      726F636564757265205265706F72744265666F72654F70656E44617461506970
      656C696E65733B0D0A626567696E0D0A2020556E6974732E4164644C696E6B28
      576F726B4F72646572732C2027556E6974272C20275265636F72644E756D6265
      7227293B0D0A2020556E6974732E4164644C696E6B28576F726B4F7264657273
      2C20274465736372697074696F6E272C20275365727669636527293B0D0A656E
      643B0D0A0D436F6D706F6E656E744E616D6506065265706F7274094576656E74
      4E616D6506174265666F72654F70656E44617461506970656C696E6573074576
      656E7449440386000001060F5472614576656E7448616E646C65720B50726F67
      72616D4E616D65060F5661726961626C65314F6E43616C630B50726F6772616D
      54797065070B747450726F63656475726506536F757263650C9001000070726F
      636564757265205661726961626C65314F6E43616C63287661722056616C7565
      3A2056617269616E74293B0D0A626567696E0D0A2020696620556E6974735B27
      506572696F64275D3D274461797327207468656E0D0A2020202056616C756520
      3A3D310D0A2020656C736520696620556E6974735B27506572696F64275D3D27
      5765656B7327207468656E0D0A2020202056616C7565203A3D310D0A2020656C
      736520696620556E6974735B27506572696F64275D3D274D6F6E746873272074
      68656E0D0A20202020626567696E0D0A202020202020696620556E6974735B27
      496E74657276616C275D3C33207468656E0D0A202020202020202056616C7565
      203A3D370D0A202020202020656C736520696620556E6974735B27496E746572
      76616C275D3C36207468656E0D0A202020202020202056616C7565203A3D3134
      0D0A202020202020656C73650D0A202020202020202056616C7565203A3D3330
      3B0D0A20202020656E640D0A2020656C73650D0A2020202056616C7565203A3D
      31303B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D650609566172
      6961626C6531094576656E744E616D6506064F6E43616C63074576656E744944
      02210001060F5472614576656E7448616E646C65720B50726F6772616D4E616D
      65060F5661726961626C65324F6E43616C630B50726F6772616D54797065070B
      747450726F63656475726506536F7572636506B070726F636564757265205661
      726961626C65324F6E43616C63287661722056616C75653A2056617269616E74
      293B0D0A626567696E0D0A696620576F726B4F72646572735B27506572666F72
      6D6564275D3E30207468656E0D0A202056616C7565203A3D576F726B4F726465
      72735B274461797354616B656E275D0D0A656C73650D0A202056616C7565203A
      3D576F726B4F72646572735B2744617973506173746564275D3B0D0A0D0A656E
      643B0D0A0D436F6D706F6E656E744E616D6506095661726961626C6532094576
      656E744E616D6506064F6E43616C63074576656E74494402210001060F547261
      4576656E7448616E646C65720B50726F6772616D4E616D65060F566172696162
      6C65334F6E43616C630B50726F6772616D54797065070B747450726F63656475
      726506536F757263650C7E02000070726F636564757265205661726961626C65
      334F6E43616C63287661722056616C75653A2056617269616E74293B0D0A6265
      67696E0D0A0D0A20205661726961626C65332E56616C7565203A3D5661726961
      626C65322E56616C75652D5661726961626C65312E56616C75653B0D0A202056
      61726961626C65342E56616C7565203A3D5661726961626C65342E56616C7565
      2B313B0D0A20206966205661726961626C65332E56616C75653C3D3020746865
      6E0D0A20202020626567696E0D0A2020202020205661726961626C65352E5661
      6C7565203A3D5661726961626C65352E56616C75652B313B0D0A202020202020
      5661726961626C65332E466F6E742E436F6C6F72203A3D636C426C61636B3B0D
      0A20202020656E640D0A2020656C73650D0A20202020626567696E0D0A202020
      2020205661726961626C65362E56616C7565203A3D5661726961626C65362E56
      616C75652B313B0D0A2020202020205661726961626C65332E466F6E742E436F
      6C6F72203A3D636C5265643B0D0A20202020656E643B0D0A2020696620576F72
      6B4F72646572735B27506572666F726D6564275D3E30207468656E0D0A202020
      20626567696E0D0A2020202020205661726961626C6531302E56616C7565203A
      3D5661726961626C6531302E56616C75652B313B0D0A20202020202056617269
      61626C6531322E56616C7565203A3D5661726961626C6531322E56616C75652B
      5661726961626C65322E56616C75653B0D0A20202020656E640D0A2020656C73
      650D0A20202020626567696E0D0A2020202020205661726961626C65392E5661
      6C7565203A3D5661726961626C65392E56616C75652B313B0D0A20202020656E
      643B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060956617269
      61626C6533094576656E744E616D6506064F6E43616C63074576656E74494402
      210001060F5472614576656E7448616E646C65720B50726F6772616D4E616D65
      060F5661726961626C65374F6E43616C630B50726F6772616D54797065070B74
      7450726F63656475726506536F75726365067370726F63656475726520566172
      6961626C65374F6E43616C63287661722056616C75653A2056617269616E7429
      3B0D0A626567696E0D0A0D0A202056616C7565203A3D285661726961626C6535
      2E56616C75652F5661726961626C65342E56616C7565292A3130303B0D0A0D0A
      656E643B0D0A0D436F6D706F6E656E744E616D6506095661726961626C653709
      4576656E744E616D6506064F6E43616C63074576656E74494402210001060F54
      72614576656E7448616E646C65720B50726F6772616D4E616D65060F56617269
      61626C65384F6E43616C630B50726F6772616D54797065070B747450726F6365
      6475726506536F75726365067370726F636564757265205661726961626C6538
      4F6E43616C63287661722056616C75653A2056617269616E74293B0D0A626567
      696E0D0A0D0A202056616C7565203A3D285661726961626C65362E56616C7565
      2F5661726961626C65342E56616C7565292A3130303B0D0A0D0A656E643B0D0A
      0D436F6D706F6E656E744E616D6506095661726961626C6538094576656E744E
      616D6506064F6E43616C63074576656E74494402210001060F5472614576656E
      7448616E646C65720B50726F6772616D4E616D6506105661726961626C653131
      4F6E43616C630B50726F6772616D54797065070B747450726F63656475726506
      536F75726365066E70726F636564757265205661726961626C6531314F6E4361
      6C63287661722056616C75653A2056617269616E74293B0D0A626567696E0D0A
      202056616C7565203A3D5661726961626C6531322E56616C75652F5661726961
      626C6531302E56616C75653B0D0A0D0A656E643B0D0A0D436F6D706F6E656E74
      4E616D65060A5661726961626C653131094576656E744E616D6506064F6E4361
      6C63074576656E74494402210001060F5472614576656E7448616E646C65720B
      50726F6772616D4E616D65060E76617247726F75704F6E43616C630B50726F67
      72616D54797065070B747450726F63656475726506536F7572636506AE70726F
      6365647572652076617247726F75704F6E43616C63287661722056616C75653A
      2056617269616E74293B0D0A626567696E0D0A696620576F726B4F7264657273
      5B27436F6D706C65746564275D3D275927207468656E0D0A202056616C756520
      3A3D27436F6D706C65746564205365727669636573270D0A656C73650D0A2020
      56616C7565203A3D274E6F6E2D436F6D706C6574656420536572766963657327
      3B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506087661724772
      6F7570094576656E744E616D6506064F6E43616C63074576656E744944022100
      00}
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_WorkOrders'
      Height = 331
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 244
      AutoSearchTabOrder = 0
      object WorkOrders: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'WorkOrders'
        object ppField1: TppField
          FieldAlias = 'ScheduledDate'
          FieldName = 'ScheduledDate'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 10
          Position = 0
          TableName = 'WoMaster'
        end
        object ppField2: TppField
          FieldAlias = 'CompletedDate'
          FieldName = 'CompletedDate'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 10
          Position = 1
          TableName = 'WoMaster'
        end
        object ppField3: TppField
          FieldAlias = 'Performed'
          FieldName = 'Performed'
          FieldLength = 0
          IsDetail = True
          DataType = dtDateTime
          DisplayWidth = 10
          Position = 2
          TableName = 'WoServices'
        end
        object ppField4: TppField
          FieldAlias = 'Numbered'
          FieldName = 'Numbered'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 3
          TableName = 'WoMaster'
        end
        object ppField5: TppField
          FieldAlias = 'Unit'
          FieldName = 'Unit'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 4
          TableName = 'WoMaster'
        end
        object ppField6: TppField
          FieldAlias = 'UnitName'
          FieldName = 'UnitName'
          FieldLength = 80
          DisplayWidth = 10
          Position = 5
          TableName = 'WoMaster'
        end
        object ppField7: TppField
          FieldAlias = 'Completed'
          FieldName = 'Completed'
          FieldLength = 1
          IsDetail = True
          DisplayWidth = 10
          Position = 6
          TableName = 'WoServices'
        end
        object ppField8: TppField
          FieldAlias = 'Description'
          FieldName = 'Description'
          FieldLength = 60
          IsDetail = True
          DisplayWidth = 10
          Position = 7
          TableName = 'WoServices'
        end
        object ppField9: TppField
          FieldAlias = 'DaysTaken'
          FieldName = 'DateDiff_day_WoMaster_Sch'
          FieldLength = 0
          Linkable = False
          DataType = dtInteger
          DisplayWidth = 10
          Position = 8
          TableName = 'WoServices'
        end
        object ppField10: TppField
          FieldAlias = 'DaysPasted'
          FieldName = 'DateDiff_day_WoMaster_S_2'
          FieldLength = 0
          Linkable = False
          DataType = dtInteger
          DisplayWidth = 10
          Position = 9
          TableName = 'WoMaster'
        end
      end
      object daSQL1: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'WorkOrders'
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT WoMaster.ScheduledDate, '
          '       WoMaster.CompletedDate, '
          '       WoServices.Performed, WoMaster.Numbered, '
          '       WoMaster.Unit, WoMaster.UnitName, '
          '       WoServices.Completed, '
          '       WoServices.Description, '
          
            '       DateDiff(day, WoMaster.ScheduledDate,  WoServices.Perform' +
            'ed) DateDiff_day_WoMaster_Sch, '
          
            '       DateDiff(day, WoMaster.ScheduledDate, getdate()) DateDiff' +
            '_day_WoMaster_S_2'
          'FROM WoMaster WoMaster'
          '      INNER JOIN WoServices WoServices ON '
          '     (WoServices.WorkOrder = WoMaster.Numbered)'
          'WHERE ('#39'c'#39' <> '#39'c'#39' )')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 'DaysTaken'
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = 'Performed'
          FieldLength = 0
          FieldName = 'Performed'
          Linkable = False
          SQLFieldName = 'DateDiff_day_WoMaster_Sch'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          TableSQLAlias = 'WoServices'
          CalcType = dacaExpression
          Expression = 'DateDiff(day, WoMaster.ScheduledDate,  WoServices.Performed)'
        end
        object daCalculation2: TdaCalculation
          ChildType = 8
          Alias = 'DaysPasted'
          DataType = dtInteger
          DisplayWidth = 10
          FieldAlias = 'Notes'
          FieldLength = 0
          FieldName = 'Notes'
          Linkable = False
          SQLFieldName = 'DateDiff_day_WoMaster_S_2'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
          CalcType = dacaExpression
          Expression = 'DateDiff(day, WoMaster.ScheduledDate, getdate())'
        end
        object daField1: TdaField
          Alias = 'ScheduledDate'
          DataType = dtDateTime
          DisplayWidth = 10
          FieldAlias = 'ScheduledDate'
          FieldLength = 0
          FieldName = 'ScheduledDate'
          SQLFieldName = 'ScheduledDate'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField2: TdaField
          Alias = 'CompletedDate'
          DataType = dtDateTime
          DisplayWidth = 10
          FieldAlias = 'CompletedDate'
          FieldLength = 0
          FieldName = 'CompletedDate'
          SQLFieldName = 'CompletedDate'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField3: TdaField
          Alias = 'Performed'
          DataType = dtDateTime
          DisplayWidth = 10
          FieldAlias = 'Performed'
          FieldLength = 0
          FieldName = 'Performed'
          IsDetail = True
          SQLFieldName = 'Performed'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          TableSQLAlias = 'WoServices'
        end
        object daField4: TdaField
          Alias = 'Numbered'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Numbered'
          FieldLength = 0
          FieldName = 'Numbered'
          SQLFieldName = 'Numbered'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField5: TdaField
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 0
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField6: TdaField
          Alias = 'UnitName'
          DisplayWidth = 10
          FieldAlias = 'UnitName'
          FieldLength = 80
          FieldName = 'UnitName'
          SQLFieldName = 'UnitName'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField7: TdaField
          Alias = 'Completed'
          DisplayWidth = 10
          FieldAlias = 'Completed'
          FieldLength = 1
          FieldName = 'Completed'
          IsDetail = True
          SQLFieldName = 'Completed'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          TableSQLAlias = 'WoServices'
        end
        object daField8: TdaField
          Alias = 'Description'
          DisplayWidth = 10
          FieldAlias = 'Description'
          FieldLength = 60
          FieldName = 'Description'
          IsDetail = True
          SQLFieldName = 'Description'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          TableSQLAlias = 'WoServices'
        end
        object daField9: TdaField
          ChildType = 2
          Alias = 'Completed'
          DisplayWidth = 10
          FieldAlias = 'Completed'
          FieldLength = 10
          FieldName = 'Completed'
          SQLFieldName = 'Completed'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          TableSQLAlias = 'WoServices'
        end
        object daField10: TdaField
          ChildType = 2
          Alias = 'Numbered'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Numbered'
          FieldLength = 10
          FieldName = 'Numbered'
          SQLFieldName = 'Numbered'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField11: TdaField
          ChildType = 2
          Alias = 'Description'
          DisplayWidth = 10
          FieldAlias = 'Description'
          FieldLength = 10
          FieldName = 'Description'
          SQLFieldName = 'Description'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          TableSQLAlias = 'WoServices'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'WoMaster'
          JoinType = dajtNone
          SQLAlias = 'WoMaster'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'WoServices'
          SQLAlias = 'WoServices'
          TableAlias = 'WoServices'
          TableName = 'WoServices'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField13: TdaField
              ChildType = 3
              Alias = 'WorkOrder'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'WorkOrder'
              FieldLength = 10
              FieldName = 'WorkOrder'
              SQLFieldName = 'WorkOrder'
              TableAlias = 'WoServices'
              TableName = 'WoServices'
              TableSQLAlias = 'WoServices'
            end
            object daField12: TdaField
              ChildType = 4
              Alias = 'Numbered'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'Numbered'
              FieldLength = 10
              FieldName = 'Numbered'
              SQLFieldName = 'Numbered'
              TableAlias = 'WoMaster'
              TableName = 'WoMaster'
              TableSQLAlias = 'WoMaster'
            end
          end
        end
      end
    end
    object daADOQueryDataView2: TdaADOQueryDataView
      UserName = 'Query_Units'
      Height = 160
      Left = 295
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 13
      TypeColumnWidth = 52
      Width = 243
      AutoSearchTabOrder = 0
      object Units: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'Units'
        object ppField1: TppField
          FieldAlias = 'RecordNumber'
          FieldName = 'RecordNumber'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 0
          TableName = 'Units'
        end
        object ppField2: TppField
          FieldAlias = 'Period'
          FieldName = 'Period'
          FieldLength = 6
          IsDetail = True
          DisplayWidth = 10
          Position = 1
          TableName = 'Servitem'
        end
        object ppField3: TppField
          FieldAlias = 'Interval'
          FieldName = 'Interval'
          FieldLength = 5
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 10
          Position = 2
          TableName = 'Servitem'
        end
        object ppField4: TppField
          FieldAlias = 'Service'
          FieldName = 'Service'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 10
          Position = 3
          TableName = 'Servitem'
        end
      end
      object daSQL2: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'Units'
        LinkColor = clNavy
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT Units.RecordNumber, Servitem.Period, '
          '       Servitem.Interval, Servitem.Service'
          'FROM Units Units INNER JOIN Servitem Servitem ON '
          '     (Servitem.Unit = Units.RecordNumber)'
          'WHERE ('#39'c'#39' <> '#39'c'#39' )')
        SQLType = sqSQL2
        object daField1: TdaField
          Alias = 'RecordNumber'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'RecordNumber'
          FieldLength = 0
          FieldName = 'RecordNumber'
          SQLFieldName = 'RecordNumber'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField2: TdaField
          Alias = 'Period'
          DisplayWidth = 10
          FieldAlias = 'Period'
          FieldLength = 6
          FieldName = 'Period'
          IsDetail = True
          SQLFieldName = 'Period'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField3: TdaField
          Alias = 'Interval'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Interval'
          FieldLength = 5
          FieldName = 'Interval'
          IsDetail = True
          SQLFieldName = 'Interval'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField4: TdaField
          Alias = 'Service'
          DisplayWidth = 10
          FieldAlias = 'Service'
          FieldLength = 50
          FieldName = 'Service'
          IsDetail = True
          SQLFieldName = 'Service'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField5: TdaField
          ChildType = 2
          Alias = 'RecordNumber'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'RecordNumber'
          FieldLength = 10
          FieldName = 'RecordNumber'
          SQLFieldName = 'RecordNumber'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField6: TdaField
          ChildType = 2
          Alias = 'Service'
          DisplayWidth = 10
          FieldAlias = 'Service'
          FieldLength = 10
          FieldName = 'Service'
          SQLFieldName = 'Service'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'Units'
          JoinType = dajtNone
          SQLAlias = 'Units'
          TableAlias = 'Units'
          TableName = 'Units'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'Servitem'
          SQLAlias = 'Servitem'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField8: TdaField
              ChildType = 3
              Alias = 'Unit'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'Unit'
              FieldLength = 10
              FieldName = 'Unit'
              SQLFieldName = 'Unit'
              TableAlias = 'Servitem'
              TableName = 'Servitem'
              TableSQLAlias = 'Servitem'
            end
            object daField7: TdaField
              ChildType = 4
              Alias = 'RecordNumber'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'RecordNumber'
              FieldLength = 10
              FieldName = 'RecordNumber'
              SQLFieldName = 'RecordNumber'
              TableAlias = 'Units'
              TableName = 'Units'
              TableSQLAlias = 'Units'
            end
          end
        end
      end
    end
  end
  object ppParameterList1: TppParameterList
  end
end