ReportName = Demo Unit Services - Outline
ReportGroup = Maintenance
object ppReport1: TppReport
  AutoStop = False
  DataPipeline = daADOQueryDataView1.ScheduledServices
  NoDataBehaviors = [ndBlankReport]
  PassSetting = psTwoPass
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Demo Unit Services - Outline'
  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 = 'Demo Unit Services - Outline'
  Template.DatabaseSettings.NameField = 'ReportName'
  Template.DatabaseSettings.TemplateField = 'NewDef'
  Template.FileName = 'Demo Unit Services - Outline.rtm'
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  AllowPrintToFile = True
  CachePages = True
  DeviceType = 'Screen'
  EmailSettings.ReportFormat = 'PDF'
  EmailSettings.Enabled = True
  EmailSettings.PreviewInEmailClient = False
  EmailSettings.ShowEmailDialog = True
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = True
  OutlineSettings.Visible = False
  PreviewFormSettings.ZoomSetting = zs100Percent
  SavePrinterSetup = True
  ShowAutoSearchDialog = True
  TextSearchSettings.DefaultString = '<FindText>'
  TextSearchSettings.Enabled = True
  Left = 218
  Top = 155
  Version = '10.04'
  mmColumnWidth = 0
  DataPipelineName = 'ScheduledServices'
  object ppTitleBand1: TppTitleBand
    mmBottomOffset = 0
    mmHeight = 35983
    mmPrintPosition = 0
    object ppLabel1: TppLabel
      UserName = 'Label1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Unit Scheduled Services'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 20
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 8202
      mmLeft = 2117
      mmTop = 2117
      mmWidth = 70644
      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 = 6615
      mmLeft = 160867
      mmTop = 2117
      mmWidth = 41804
      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 = 4233
      mmLeft = 2117
      mmTop = 10848
      mmWidth = 25400
      BandType = 1
    end
    object ppRichText1: TppRichText
      UserName = 'RichText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'RichText1'
      RichText = 
        '{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcha' +
        'rset0 MS Sans Serif;}{\f1\fnil MS Sans Serif;}}'#13#10'\viewkind4\uc1\' +
        'pard\f0\fs16 This report demonstrates the use of an outline on t' +
        'he left hand side of the Preview screen.  This allows\par'#13#10'you t' +
        'o click on the Unit and jump to the page containing the unit.  I' +
        'n the Data tab, the data is set to sort\par'#13#10'by UnitName.  In th' +
        'e Design tab, click on the menu Report / Groups to see the group' +
        ' setting by Unit Name.\par'#13#10'Note the fields in the Group Header ' +
        'band.  This serves for the outline.  To turn on outlining, click' +
        ' on the \par'#13#10'menu Report / Outline Settings and Enable outlinin' +
        'g.\f1\par'#13#10'}'#13#10
      mmHeight = 21431
      mmLeft = 35983
      mmTop = 12700
      mmWidth = 133615
      BandType = 1
      mmBottomOffset = 0
      mmOverFlowOffset = 0
      mmStopPosition = 0
    end
  end
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 12435
    mmPrintPosition = 0
    object ppLine3: TppLine
      UserName = 'Line3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Weight = 0.750000000000000000
      mmHeight = 1852
      mmLeft = 121444
      mmTop = 3704
      mmWidth = 35454
      BandType = 0
    end
    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 = 1323
      mmTop = 11113
      mmWidth = 200555
      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 = 10054
      mmTop = 5821
      mmWidth = 56621
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'Label4'
      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 = 10
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4233
      mmLeft = 90223
      mmTop = 5821
      mmWidth = 11642
      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 = 104511
      mmTop = 5821
      mmWidth = 9525
      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 = 120915
      mmTop = 5821
      mmWidth = 15081
      BandType = 0
    end
    object ppLabel7: TppLabel
      UserName = 'Label7'
      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 = 10
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4106
      mmLeft = 141891
      mmTop = 5821
      mmWidth = 15536
      BandType = 0
    end
    object ppLabel8: TppLabel
      UserName = 'Label8'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'FromNow'
      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 = 165100
      mmTop = 5821
      mmWidth = 14817
      BandType = 0
    end
    object ppLabel9: TppLabel
      UserName = 'Label9'
      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 = 10
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4106
      mmLeft = 186341
      mmTop = 5821
      mmWidth = 15536
      BandType = 0
    end
    object ppLabel10: TppLabel
      UserName = 'Label10'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Date Based'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 10
      Font.Style = [fsBold, fsItalic]
      mmHeight = 4106
      mmLeft = 129646
      mmTop = 1588
      mmWidth = 16552
      BandType = 0
    end
    object ppLine4: TppLine
      UserName = 'Line4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Weight = 0.750000000000000000
      mmHeight = 1852
      mmLeft = 165629
      mmTop = 3704
      mmWidth = 35719
      BandType = 0
    end
    object ppLabel11: TppLabel
      UserName = 'Label101'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Count Based'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 10
      Font.Style = [fsBold, fsItalic]
      mmHeight = 4233
      mmLeft = 173038
      mmTop = 1588
      mmWidth = 18785
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      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 = 4106
      mmLeft = 71702
      mmTop = 5821
      mmWidth = 8975
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 3969
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'DBText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Service'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3175
      mmLeft = 10054
      mmTop = 529
      mmWidth = 60325
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Interval'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3260
      mmLeft = 98731
      mmTop = 529
      mmWidth = 3133
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Period'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3260
      mmLeft = 104511
      mmTop = 529
      mmWidth = 6435
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'ScheduledDate'
      DataPipeline = daADOQueryDataView1.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 = 121444
      mmTop = 529
      mmWidth = 14139
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText6'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'LastPerformedDate'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      DisplayFormat = 'mm/dd/yyyy'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3260
      mmLeft = 143288
      mmTop = 529
      mmWidth = 14139
      BandType = 4
    end
    object ppDBText7: TppDBText
      UserName = 'DBText7'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'FromNow'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3260
      mmLeft = 171281
      mmTop = 529
      mmWidth = 8636
      BandType = 4
    end
    object ppDBText8: TppDBText
      UserName = 'DBText8'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'LastPerformedMiles'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      DisplayFormat = '#,0;-#,0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3260
      mmLeft = 176646
      mmTop = 529
      mmWidth = 25231
      BandType = 4
    end
    object ppDBText10: TppDBText
      UserName = 'DBText10'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Status'
      DataPipeline = daADOQueryDataView1.ScheduledServices
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ScheduledServices'
      mmHeight = 3175
      mmLeft = 71702
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    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 = 1323
      mmTop = 5821
      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 = 5292
    mmPrintPosition = 0
    object ppDBCalc1: TppDBCalc
      UserName = 'DBCalc1'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'Service'
      DataPipeline = daADOQueryDataView1.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 = 1588
      mmTop = 529
      mmWidth = 21463
      BandType = 7
    end
  end
  object ppGroup1: TppGroup
    BreakName = 'UnitName'
    DataPipeline = daADOQueryDataView1.ScheduledServices
    OutlineSettings.CreateNode = True
    NewPage = True
    UserName = 'Group1'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'ScheduledServices'
    object ppGroupHeaderBand1: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 6879
      mmPrintPosition = 0
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        AutoSize = True
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        DataField = 'Name'
        DataPipeline = daADOQueryDataView1.ScheduledServices
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlue
        Font.Name = 'ARIAL'
        Font.Size = 10
        Font.Style = [fsBold, fsItalic]
        Transparent = True
        DataPipelineName = 'ScheduledServices'
        mmHeight = 4106
        mmLeft = 1588
        mmTop = 2117
        mmWidth = 15833
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 1323
      mmPrintPosition = 0
    end
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_ScheduledServices'
      Height = 289
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 306
      AutoSearchTabOrder = 0
      object ScheduledServices: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'ScheduledServices'
        object ppField1: TppField
          FieldAlias = 'Name'
          FieldName = 'Name'
          FieldLength = 80
          DisplayWidth = 80
          Position = 0
          TableName = 'Units'
        end
        object ppField2: TppField
          FieldAlias = 'Unit'
          FieldName = 'Unit'
          FieldLength = 25
          DisplayWidth = 25
          Position = 1
          TableName = 'Units'
        end
        object ppField3: TppField
          FieldAlias = 'ItemSeq'
          FieldName = 'ItemSeq'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 2
          TableName = 'Servitem'
        end
        object ppField4: TppField
          FieldAlias = 'FromNow'
          FieldName = 'FromNow'
          FieldLength = 5
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 5
          Position = 3
          TableName = 'Servitem'
        end
        object ppField5: TppField
          FieldAlias = 'Interval'
          FieldName = 'Interval'
          FieldLength = 5
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 5
          Position = 4
          TableName = 'Servitem'
        end
        object ppField6: TppField
          FieldAlias = 'LastPerformedDate'
          FieldName = 'LastPerformedDate'
          FieldLength = 0
          IsDetail = True
          DataType = dtDateTime
          DisplayWidth = 0
          Position = 5
          TableName = 'Servitem'
        end
        object ppField7: TppField
          FieldAlias = 'LastPerformedMiles'
          FieldName = 'LastPerformedMiles'
          FieldLength = 5
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 5
          Position = 6
          TableName = 'Servitem'
        end
        object ppField8: TppField
          FieldAlias = 'Period'
          FieldName = 'Period'
          FieldLength = 6
          IsDetail = True
          DisplayWidth = 6
          Position = 7
          TableName = 'Servitem'
        end
        object ppField9: TppField
          FieldAlias = 'Scheduled'
          FieldName = 'Scheduled'
          FieldLength = 10
          IsDetail = True
          DisplayWidth = 10
          Position = 8
          TableName = 'Servitem'
        end
        object ppField10: TppField
          FieldAlias = 'ScheduledDate'
          FieldName = 'ScheduledDate'
          FieldLength = 0
          IsDetail = True
          DataType = dtDateTime
          DisplayWidth = 0
          Position = 9
          TableName = 'Servitem'
        end
        object ppField11: TppField
          FieldAlias = 'Service'
          FieldName = 'Service'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 10
          TableName = 'Servitem'
        end
        object ppField12: TppField
          FieldAlias = 'SeparateWO'
          FieldName = 'SeparateWO'
          FieldLength = 1
          IsDetail = True
          DisplayWidth = 1
          Position = 11
          TableName = 'Servitem'
        end
        object ppField13: TppField
          FieldAlias = 'UnitName'
          FieldName = 'UnitName'
          FieldLength = 80
          IsDetail = True
          DisplayWidth = 80
          Position = 12
          TableName = 'Servitem'
        end
        object ppField14: TppField
          FieldAlias = 'Status'
          FieldName = 'Status'
          FieldLength = 8
          IsDetail = True
          DisplayWidth = 8
          Position = 13
          TableName = 'Servitem'
        end
      end
      object daSQL1: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'ScheduledServices'
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT Units.Name, Units.Unit, Servitem.ItemSeq, '
          '       Servitem.FromNow, Servitem.Interval, '
          '       Servitem.LastPerformedDate, '
          '       Servitem.LastPerformedMiles, '
          '       Servitem.Period, Servitem.Scheduled, '
          '       Servitem.ScheduledDate, Servitem.Service, '
          '       Servitem.SeparateWO, Servitem.UnitName, '
          '       Servitem.Status'
          'FROM Units Units INNER JOIN Servitem Servitem ON '
          '     (Servitem.Unit = Units.RecordNumber)'
          'ORDER BY Units.Name, Servitem.ItemSeq, '
          '         Servitem.Scheduled')
        SQLType = sqSQL2
        object daField1: TdaField
          Alias = 'Name'
          DisplayWidth = 80
          FieldAlias = 'Name'
          FieldLength = 80
          FieldName = 'Name'
          SQLFieldName = 'Name'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField2: TdaField
          Alias = 'Unit'
          DisplayWidth = 25
          FieldAlias = 'Unit'
          FieldLength = 25
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField3: TdaField
          Alias = 'ItemSeq'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'ItemSeq'
          FieldLength = 0
          FieldName = 'ItemSeq'
          IsDetail = True
          SQLFieldName = 'ItemSeq'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField4: TdaField
          Alias = 'FromNow'
          DataType = dtDouble
          DisplayWidth = 5
          FieldAlias = 'FromNow'
          FieldLength = 5
          FieldName = 'FromNow'
          IsDetail = True
          SQLFieldName = 'FromNow'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField5: TdaField
          Alias = 'Interval'
          DataType = dtDouble
          DisplayWidth = 5
          FieldAlias = 'Interval'
          FieldLength = 5
          FieldName = 'Interval'
          IsDetail = True
          SQLFieldName = 'Interval'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField6: TdaField
          Alias = 'LastPerformedDate'
          DataType = dtDateTime
          DisplayWidth = 0
          FieldAlias = 'LastPerformedDate'
          FieldLength = 0
          FieldName = 'LastPerformedDate'
          IsDetail = True
          SQLFieldName = 'LastPerformedDate'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField7: TdaField
          Alias = 'LastPerformedMiles'
          DataType = dtDouble
          DisplayWidth = 5
          FieldAlias = 'LastPerformedMiles'
          FieldLength = 5
          FieldName = 'LastPerformedMiles'
          IsDetail = True
          SQLFieldName = 'LastPerformedMiles'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField8: TdaField
          Alias = 'Period'
          DisplayWidth = 6
          FieldAlias = 'Period'
          FieldLength = 6
          FieldName = 'Period'
          IsDetail = True
          SQLFieldName = 'Period'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField9: TdaField
          Alias = 'Scheduled'
          DisplayWidth = 10
          FieldAlias = 'Scheduled'
          FieldLength = 10
          FieldName = 'Scheduled'
          IsDetail = True
          SQLFieldName = 'Scheduled'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField10: TdaField
          Alias = 'ScheduledDate'
          DataType = dtDateTime
          DisplayWidth = 0
          FieldAlias = 'ScheduledDate'
          FieldLength = 0
          FieldName = 'ScheduledDate'
          IsDetail = True
          SQLFieldName = 'ScheduledDate'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField11: TdaField
          Alias = 'Service'
          DisplayWidth = 50
          FieldAlias = 'Service'
          FieldLength = 50
          FieldName = 'Service'
          IsDetail = True
          SQLFieldName = 'Service'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField12: TdaField
          Alias = 'SeparateWO'
          DisplayWidth = 1
          FieldAlias = 'SeparateWO'
          FieldLength = 1
          FieldName = 'SeparateWO'
          IsDetail = True
          SQLFieldName = 'SeparateWO'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField13: TdaField
          Alias = 'UnitName'
          DisplayWidth = 80
          FieldAlias = 'UnitName'
          FieldLength = 80
          FieldName = 'UnitName'
          IsDetail = True
          SQLFieldName = 'UnitName'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField14: TdaField
          Alias = 'Status'
          DisplayWidth = 8
          FieldAlias = 'Status'
          FieldLength = 8
          FieldName = 'Status'
          IsDetail = True
          SQLFieldName = 'Status'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField15: TdaField
          ChildType = 2
          Alias = 'Name'
          DisplayWidth = 80
          FieldAlias = 'Name'
          FieldLength = 80
          FieldName = 'Name'
          SQLFieldName = 'Name'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField16: TdaField
          ChildType = 2
          Alias = 'ItemSeq'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'ItemSeq'
          FieldLength = 0
          FieldName = 'ItemSeq'
          SQLFieldName = 'ItemSeq'
          TableAlias = 'Servitem'
          TableName = 'Servitem'
          TableSQLAlias = 'Servitem'
        end
        object daField17: TdaField
          ChildType = 2
          Alias = 'Scheduled'
          DisplayWidth = 10
          FieldAlias = 'Scheduled'
          FieldLength = 10
          FieldName = 'Scheduled'
          SQLFieldName = 'Scheduled'
          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 daField19: TdaField
              ChildType = 3
              Alias = 'Unit'
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = 'Unit'
              FieldLength = 0
              FieldName = 'Unit'
              SQLFieldName = 'Unit'
              TableAlias = 'Servitem'
              TableName = 'Servitem'
              TableSQLAlias = 'Servitem'
            end
            object daField18: TdaField
              ChildType = 4
              Alias = 'RecordNumber'
              DataType = dtDouble
              DisplayWidth = 0
              FieldAlias = 'RecordNumber'
              FieldLength = 0
              FieldName = 'RecordNumber'
              SQLFieldName = 'RecordNumber'
              TableAlias = 'Units'
              TableName = 'Units'
              TableSQLAlias = 'Units'
            end
          end
        end
      end
    end
  end
  object ppParameterList1: TppParameterList
  end
end