ReportName = Employee List
ReportGroup = Maintenance
object ppReport1: TppReport
  AutoStop = False
  DataPipeline = daADOQueryDataView1.Employees
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Report'
  PrinterSetup.PaperName = 'Letter'
  PrinterSetup.PrinterName = 'Default'
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 279401
  PrinterSetup.mmPaperWidth = 215900
  PrinterSetup.PaperSize = 1
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = dpReports
  Template.DatabaseSettings.Name = 'Employee List'
  Template.DatabaseSettings.NameField = 'ReportName'
  Template.DatabaseSettings.TemplateField = 'NewDef'
  Template.FileName = 'Employee List.rtm'
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  AllowPrintToArchive = True
  AllowPrintToFile = True
  DeviceType = 'Screen'
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = True
  OutlineSettings.Visible = True
  PreviewFormSettings.ZoomSetting = zs100Percent
  TextSearchSettings.DefaultString = '<FindText>'
  TextSearchSettings.Enabled = True
  Left = 218
  Top = 155
  Version = '7.03'
  mmColumnWidth = 0
  DataPipelineName = 'Employees'
  object ppTitleBand1: TppTitleBand
    mmBottomOffset = 0
    mmHeight = 8996
    mmPrintPosition = 0
    object ppLabel1: TppLabel
      UserName = 'Label1'
      Caption = 'Employee List'
      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 = 1323
      mmWidth = 33020
      BandType = 1
    end
    object ppDBText7: TppDBText
      UserName = 'DBText7'
      AutoSize = True
      DataField = 'CompanyName'
      DataPipeline = dpCompanyInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 16
      Font.Style = [fsBold, fsItalic]
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'dpCompanyInfo'
      mmHeight = 6562
      mmLeft = 164486
      mmTop = 1323
      mmWidth = 35010
      BandType = 1
    end
  end
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 8731
    mmPrintPosition = 0
    object ppLine1: TppLine
      UserName = 'Line1'
      Pen.Color = clNavy
      Pen.Width = 2
      Weight = 1.5
      mmHeight = 1588
      mmLeft = 794
      mmTop = 7142
      mmWidth = 200555
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = 'Label2'
      AutoSize = False
      Caption = 'Employee Name'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 1588
      mmTop = 1588
      mmWidth = 51329
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      AutoSize = False
      Caption = 'Position'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 59796
      mmTop = 1588
      mmWidth = 14023
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'Label4'
      AutoSize = False
      Caption = 'Phone'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 90488
      mmTop = 1588
      mmWidth = 11377
      BandType = 0
    end
    object ppLabel5: TppLabel
      UserName = 'Label5'
      AutoSize = False
      Caption = 'Pager'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 118004
      mmTop = 1588
      mmWidth = 11113
      BandType = 0
    end
    object ppLabel6: TppLabel
      UserName = 'Label6'
      AutoSize = False
      Caption = 'Cell Phone'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 143404
      mmTop = 1588
      mmWidth = 23813
      BandType = 0
    end
    object ppLabel7: TppLabel
      UserName = 'Label7'
      AutoSize = False
      Caption = 'Birthdate'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 181505
      mmTop = 1588
      mmWidth = 16669
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 4498
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'DBText1'
      DataField = 'ShortName'
      DataPipeline = daADOQueryDataView1.Employees
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Employees'
      mmHeight = 3175
      mmLeft = 1588
      mmTop = 794
      mmWidth = 51594
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      DataField = 'Position'
      DataPipeline = daADOQueryDataView1.Employees
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Employees'
      mmHeight = 3175
      mmLeft = 59796
      mmTop = 794
      mmWidth = 28575
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      DataField = 'Phone'
      DataPipeline = daADOQueryDataView1.Employees
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Employees'
      mmHeight = 3175
      mmLeft = 90488
      mmTop = 794
      mmWidth = 24871
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      DataField = 'Pager'
      DataPipeline = daADOQueryDataView1.Employees
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Employees'
      mmHeight = 3175
      mmLeft = 118004
      mmTop = 794
      mmWidth = 22490
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      DataField = 'CelluarPhone'
      DataPipeline = daADOQueryDataView1.Employees
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Employees'
      mmHeight = 3175
      mmLeft = 143404
      mmTop = 794
      mmWidth = 27252
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText6'
      DataField = 'Birthdate'
      DataPipeline = daADOQueryDataView1.Employees
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Employees'
      mmHeight = 3175
      mmLeft = 179123
      mmTop = 794
      mmWidth = 21431
      BandType = 4
    end
  end
  object ppFooterBand1: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 7144
    mmPrintPosition = 0
    object ppLine2: TppLine
      UserName = 'Line2'
      Pen.Color = clGray
      Pen.Width = 2
      Weight = 1.5
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 5821
      mmWidth = 200555
      BandType = 8
    end
    object ppSystemVariable1: TppSystemVariable
      UserName = 'SystemVariable1'
      VarType = vtPrintDateTime
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 9
      Font.Style = []
      Transparent = True
      mmHeight = 4487
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 17187
      BandType = 8
    end
    object ppSystemVariable2: TppSystemVariable
      UserName = 'SystemVariable2'
      VarType = vtPageNoDesc
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 9
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4487
      mmLeft = 184680
      mmTop = 1323
      mmWidth = 17187
      BandType = 8
    end
  end
  object ppSummaryBand1: TppSummaryBand
    mmBottomOffset = 0
    mmHeight = 6879
    mmPrintPosition = 0
    object ppDBCalc1: TppDBCalc
      UserName = 'DBCalc1'
      AutoSize = True
      DataField = 'LastName'
      DataPipeline = daADOQueryDataView1.Employees
      DisplayFormat = 'Total Number of Records: #####0'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlue
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DBCalcType = dcCount
      DataPipelineName = 'Employees'
      mmHeight = 3260
      mmLeft = 1588
      mmTop = 2910
      mmWidth = 22352
      BandType = 7
    end
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_Employees'
      Height = 262
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 298
      AutoSearchTabOrder = 0
      object Employees: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'Employees'
        object ppField1: TppField
          FieldAlias = 'LastName'
          FieldName = 'LastName'
          FieldLength = 20
          DisplayWidth = 20
          Position = 0
          TableName = 'Employees'
        end
        object ppField2: TppField
          FieldAlias = 'FirstName'
          FieldName = 'FirstName'
          FieldLength = 20
          DisplayWidth = 20
          Position = 1
          TableName = 'Employees'
        end
        object ppField3: TppField
          FieldAlias = 'Position'
          FieldName = 'Position'
          FieldLength = 25
          DisplayWidth = 25
          Position = 2
          TableName = 'Employees'
        end
        object ppField4: TppField
          FieldAlias = 'Phone'
          FieldName = 'Phone'
          FieldLength = 20
          DisplayWidth = 20
          Position = 3
          TableName = 'Employees'
        end
        object ppField5: TppField
          FieldAlias = 'Pager'
          FieldName = 'Pager'
          FieldLength = 20
          DisplayWidth = 20
          Position = 4
          TableName = 'Employees'
        end
        object ppField6: TppField
          FieldAlias = 'CelluarPhone'
          FieldName = 'CelluarPhone'
          FieldLength = 20
          DisplayWidth = 20
          Position = 5
          TableName = 'Employees'
        end
        object ppField7: TppField
          FieldAlias = 'Birthdate'
          FieldName = 'Birthdate'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 0
          Position = 6
          TableName = 'Employees'
        end
        object ppField8: TppField
          FieldAlias = 'Status'
          FieldName = 'Status'
          FieldLength = 1
          DisplayWidth = 1
          Position = 7
          TableName = 'Employees'
        end
        object ppField9: TppField
          FieldAlias = 'WorkGroup'
          FieldName = 'WorkGroup'
          FieldLength = 25
          DisplayWidth = 25
          Position = 8
          TableName = 'Employees'
        end
        object ppField10: TppField
          FieldAlias = 'MiddleInitial'
          FieldName = 'MiddleInitial'
          FieldLength = 1
          DisplayWidth = 1
          Position = 9
          TableName = 'Employees'
        end
        object ppField11: TppField
          FieldAlias = 'ShortName'
          FieldName = 'ShortName'
          FieldLength = 35
          DisplayWidth = 35
          Position = 10
          TableName = 'Employees'
        end
        object ppField12: TppField
          FieldAlias = 'LastName+'#39', '#39'+FirstName+'#39' '#39'+MiddleInitial'
          FieldName = 'LastName_FirstName_Middle'
          FieldLength = 20
          Linkable = False
          DisplayWidth = 20
          Position = 11
          TableName = 'Employees'
        end
      end
      object daSQL1: TdaSQL
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'Employees'
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT Employees.LastName, Employees.FirstName, '
          '       Employees.Position, Employees.Phone, '
          '       Employees.Pager, Employees.CelluarPhone, '
          '       Employees.Birthdate, Employees.Status, '
          '       Employees.WorkGroup, '
          '       Employees.MiddleInitial, '
          '       Employees.ShortName, '
          
            '       LastName+'#39', '#39'+FirstName+'#39' '#39'+MiddleInitial LastName_FirstN' +
            'ame_Middle'
          'FROM Employees Employees'
          'ORDER BY Employees.LastName, Employees.FirstName, '
          '         Employees.MiddleInitial')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 'LastName+'#39', '#39'+FirstName+'#39' '#39'+MiddleInitial'
          DisplayWidth = 20
          FieldAlias = 'LastName'
          FieldLength = 20
          FieldName = 'LastName'
          Linkable = False
          SQLFieldName = 'LastName_FirstName_Middle'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
          CalcType = dacaExpression
          Expression = 'LastName+'#39', '#39'+FirstName+'#39' '#39'+MiddleInitial'
        end
        object daField1: TdaField
          Alias = 'LastName'
          DisplayWidth = 20
          FieldAlias = 'LastName'
          FieldLength = 20
          FieldName = 'LastName'
          SQLFieldName = 'LastName'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField2: TdaField
          Alias = 'FirstName'
          DisplayWidth = 20
          FieldAlias = 'FirstName'
          FieldLength = 20
          FieldName = 'FirstName'
          SQLFieldName = 'FirstName'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField3: TdaField
          Alias = 'Position'
          DisplayWidth = 25
          FieldAlias = 'Position'
          FieldLength = 25
          FieldName = 'Position'
          SQLFieldName = 'Position'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField4: TdaField
          Alias = 'Phone'
          DisplayWidth = 20
          FieldAlias = 'Phone'
          FieldLength = 20
          FieldName = 'Phone'
          SQLFieldName = 'Phone'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField5: TdaField
          Alias = 'Pager'
          DisplayWidth = 20
          FieldAlias = 'Pager'
          FieldLength = 20
          FieldName = 'Pager'
          SQLFieldName = 'Pager'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField6: TdaField
          Alias = 'CelluarPhone'
          DisplayWidth = 20
          FieldAlias = 'CelluarPhone'
          FieldLength = 20
          FieldName = 'CelluarPhone'
          SQLFieldName = 'CelluarPhone'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField7: TdaField
          Alias = 'Birthdate'
          DataType = dtDateTime
          DisplayWidth = 0
          FieldAlias = 'Birthdate'
          FieldLength = 0
          FieldName = 'Birthdate'
          SQLFieldName = 'Birthdate'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField8: TdaField
          Alias = 'Status'
          DisplayWidth = 1
          FieldAlias = 'Status'
          FieldLength = 1
          FieldName = 'Status'
          SQLFieldName = 'Status'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField9: TdaField
          Alias = 'WorkGroup'
          DisplayWidth = 25
          FieldAlias = 'WorkGroup'
          FieldLength = 25
          FieldName = 'WorkGroup'
          SQLFieldName = 'WorkGroup'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField10: TdaField
          Alias = 'MiddleInitial'
          DisplayWidth = 1
          FieldAlias = 'MiddleInitial'
          FieldLength = 1
          FieldName = 'MiddleInitial'
          SQLFieldName = 'MiddleInitial'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField11: TdaField
          Alias = 'ShortName'
          DisplayWidth = 35
          FieldAlias = 'ShortName'
          FieldLength = 35
          FieldName = 'ShortName'
          SQLFieldName = 'ShortName'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField12: TdaField
          ChildType = 2
          Alias = 'LastName'
          DisplayWidth = 20
          FieldAlias = 'LastName'
          FieldLength = 20
          FieldName = 'LastName'
          SQLFieldName = 'LastName'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField13: TdaField
          ChildType = 2
          Alias = 'FirstName'
          DisplayWidth = 20
          FieldAlias = 'FirstName'
          FieldLength = 20
          FieldName = 'FirstName'
          SQLFieldName = 'FirstName'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daField14: TdaField
          ChildType = 2
          Alias = 'MiddleInitial'
          DisplayWidth = 1
          FieldAlias = 'MiddleInitial'
          FieldLength = 1
          FieldName = 'MiddleInitial'
          SQLFieldName = 'MiddleInitial'
          TableAlias = 'Employees'
          TableName = 'Employees'
          TableSQLAlias = 'Employees'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'Employees'
          JoinType = dajtNone
          SQLAlias = 'Employees'
          TableAlias = 'Employees'
          TableName = 'Employees'
        end
      end
    end
  end
  object ppParameterList1: TppParameterList
  end
end