object FExportaciones: TFExportaciones
  Left = 196
  Top = 113
  Caption = 'Reportes'
  ClientHeight = 493
  ClientWidth = 874
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 41
    Top = 109
    Width = 102
    Height = 20
    Caption = 'Ordenar por:'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
  end
  object BitBtn1: TBitBtn
    Left = 358
    Top = 445
    Width = 153
    Height = 39
    Caption = 'Exportar a Excel'
    TabOrder = 0
    OnClick = BitBtn1Click
  end
  object CheckBox1: TCheckBox
    Left = 14
    Top = 20
    Width = 138
    Height = 17
    Caption = 'Por direcci'#243'n'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 1
  end
  object DBLookupComboBox1: TDBLookupComboBox
    Left = 218
    Top = 16
    Width = 503
    Height = 21
    KeyField = 'ide'
    ListField = 'Area'
    ListSource = DSArea
    TabOrder = 2
  end
  object BitBtn2: TBitBtn
    Left = 395
    Top = 138
    Width = 75
    Height = 25
    Caption = 'Buscar'
    TabOrder = 3
    OnClick = BitBtn2Click
  end
  object ComboBox1: TComboBox
    Left = 155
    Top = 109
    Width = 145
    Height = 21
    TabOrder = 4
    Text = 'Area'
    Items.Strings = (
      'Area'
      'Nombre')
  end
  object CheckBox2: TCheckBox
    Left = 11
    Top = 55
    Width = 192
    Height = 17
    Caption = 'Por Tipo de Contrato'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 6
  end
  object DBLookupComboBox2: TDBLookupComboBox
    Left = 216
    Top = 50
    Width = 508
    Height = 21
    KeyField = 'ide'
    ListField = 'TipoEmpleo'
    ListSource = DSTipoEmpleo
    TabOrder = 5
  end
  object JvDBUltimGrid1: TJvDBUltimGrid
    Left = 14
    Top = 169
    Width = 852
    Height = 241
    DataSource = DSExportar
    TabOrder = 7
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    SelectColumnsDialogStrings.Caption = 'Select columns'
    SelectColumnsDialogStrings.OK = '&OK'
    SelectColumnsDialogStrings.NoSelectionWarning = 'At least one column must be visible!'
    EditControls = <>
    RowsHeight = 17
    TitleRowHeight = 17
  end
  object DSExportar: TDataSource
    DataSet = QExportar
    Left = 649
    Top = 75
  end
  object QExportar: TADOQuery
    Connection = dm.Conector
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'SELECT Personal.ide, Personal.Nombre+'#39' '#39'+Personal.Apaterno+'#39' '#39'+P' +
        'ersonal.AMaterno AS Empleado, Personal.Calle, Personal.[No], Per' +
        'sonal.Colonia, Personal.CP, Personal.Titulo, CatPuestos.Puesto, ' +
        'CatProgramas.Programa, CatAreas.Area, TipoEmpleo.TipoEmpleo'
      
        'FROM (((Personal LEFT JOIN CatPuestos ON Personal.Puesto = CatPu' +
        'estos.ide) LEFT JOIN CatProgramas ON Personal.Programa = CatProg' +
        'ramas.ide) LEFT JOIN TipoEmpleo ON Personal.TipoEmpleo = TipoEmp' +
        'leo.ide) LEFT JOIN CatAreas ON Personal.Area = CatAreas.ide ')
    Left = 733
    Top = 4
  end
  object SaveDialog1: TSaveDialog
    Filter = 'Hoja de C'#225'lculo de Excel|*.xlsx'
    Left = 766
    Top = 4
  end
  object TArea: TADOTable
    Connection = dm.Conector
    TableName = 'CatAreas'
    Left = 799
    Top = 4
  end
  object DSArea: TDataSource
    DataSet = TArea
    Left = 830
    Top = 4
  end
  object TtipoEmpleo: TADOTable
    Connection = dm.Conector
    TableName = 'TipoEmpleo'
    Left = 817
    Top = 67
  end
  object DSTipoEmpleo: TDataSource
    DataSet = TtipoEmpleo
    Left = 772
    Top = 98
  end
  object Excel: TJvDBGridExcelExport
    Caption = 'Exportando a Excel...'
    Grid = JvDBUltimGrid1
    AutoFit = False
    Left = 560
    Top = 104
  end
end
