object FExportaciones: TFExportaciones
  Left = 196
  Top = 113
  Width = 890
  Height = 531
  Caption = 'Reportes'
  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 ExpGrid: TDBAdvStringGrid
    Left = 7
    Top = 173
    Width = 872
    Height = 248
    Cursor = crDefault
    ColCount = 12
    DefaultRowHeight = 21
    DefaultDrawing = False
    FixedCols = 1
    RowCount = 2
    FixedRows = 1
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Tahoma'
    Font.Style = []
    GridLineWidth = 1
    Options = [goFixedVertLine, goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goDrawFocusSelected, goColSizing]
    ParentFont = False
    ScrollBars = ssBoth
    TabOrder = 0
    GridLineColor = clSilver
    ActiveCellShow = False
    ActiveCellFont.Charset = DEFAULT_CHARSET
    ActiveCellFont.Color = clWindowText
    ActiveCellFont.Height = -11
    ActiveCellFont.Name = 'Tahoma'
    ActiveCellFont.Style = [fsBold]
    ActiveCellColor = clGray
    Bands.PrimaryColor = clInfoBk
    Bands.PrimaryLength = 1
    Bands.SecondaryColor = clWindow
    Bands.SecondaryLength = 1
    Bands.Print = False
    AutoNumAlign = False
    AutoSize = False
    VAlignment = vtaTop
    EnhTextSize = False
    EnhRowColMove = True
    SizeWithForm = False
    Multilinecells = False
    DragDropSettings.OleAcceptFiles = True
    DragDropSettings.OleAcceptText = True
    SortSettings.AutoColumnMerge = False
    SortSettings.Column = 0
    SortSettings.Show = False
    SortSettings.IndexShow = False
    SortSettings.IndexColor = clYellow
    SortSettings.Full = True
    SortSettings.SingleColumn = False
    SortSettings.IgnoreBlanks = False
    SortSettings.BlankPos = blFirst
    SortSettings.AutoFormat = True
    SortSettings.Direction = sdAscending
    SortSettings.InitSortDirection = sdAscending
    SortSettings.FixedCols = False
    SortSettings.NormalCellsOnly = False
    SortSettings.Row = 0
    SortSettings.UndoSort = False
    FloatingFooter.Color = clBtnFace
    FloatingFooter.Column = 0
    FloatingFooter.FooterStyle = fsFixedLastRow
    FloatingFooter.Visible = False
    ControlLook.Color = clBlack
    ControlLook.CheckSize = 15
    ControlLook.RadioSize = 10
    ControlLook.ControlStyle = csWinXP
    ControlLook.DropDownAlwaysVisible = False
    ControlLook.ProgressMarginX = 2
    ControlLook.ProgressMarginY = 2
    EnableBlink = False
    EnableHTML = True
    EnableWheel = True
    Flat = False
    Look = glXP
    HintColor = clInfoBk
    SelectionColor = 15387318
    SelectionTextColor = clBlack
    SelectionRectangle = False
    SelectionResizer = False
    SelectionRTFKeep = False
    HintShowCells = False
    HintShowLargeText = False
    HintShowSizing = False
    PrintSettings.FooterSize = 0
    PrintSettings.HeaderSize = 0
    PrintSettings.Time = ppNone
    PrintSettings.Date = ppNone
    PrintSettings.DateFormat = 'dd/mm/yyyy'
    PrintSettings.PageNr = ppNone
    PrintSettings.Title = ppNone
    PrintSettings.Font.Charset = DEFAULT_CHARSET
    PrintSettings.Font.Color = clWindowText
    PrintSettings.Font.Height = -11
    PrintSettings.Font.Name = 'MS Sans Serif'
    PrintSettings.Font.Style = []
    PrintSettings.FixedFont.Charset = DEFAULT_CHARSET
    PrintSettings.FixedFont.Color = clWindowText
    PrintSettings.FixedFont.Height = -11
    PrintSettings.FixedFont.Name = 'MS Sans Serif'
    PrintSettings.FixedFont.Style = []
    PrintSettings.HeaderFont.Charset = DEFAULT_CHARSET
    PrintSettings.HeaderFont.Color = clWindowText
    PrintSettings.HeaderFont.Height = -11
    PrintSettings.HeaderFont.Name = 'MS Sans Serif'
    PrintSettings.HeaderFont.Style = []
    PrintSettings.FooterFont.Charset = DEFAULT_CHARSET
    PrintSettings.FooterFont.Color = clWindowText
    PrintSettings.FooterFont.Height = -11
    PrintSettings.FooterFont.Name = 'MS Sans Serif'
    PrintSettings.FooterFont.Style = []
    PrintSettings.Borders = pbSingle
    PrintSettings.BorderStyle = psSolid
    PrintSettings.Centered = True
    PrintSettings.RepeatFixedRows = False
    PrintSettings.RepeatFixedCols = False
    PrintSettings.LeftSize = 0
    PrintSettings.RightSize = 0
    PrintSettings.ColumnSpacing = 0
    PrintSettings.RowSpacing = 0
    PrintSettings.TitleSpacing = 0
    PrintSettings.Orientation = poPortrait
    PrintSettings.PageNumberOffset = 0
    PrintSettings.MaxPagesOffset = 0
    PrintSettings.FixedWidth = 0
    PrintSettings.FixedHeight = 0
    PrintSettings.UseFixedHeight = False
    PrintSettings.UseFixedWidth = False
    PrintSettings.FitToPage = fpNever
    PrintSettings.PageNumSep = '/'
    PrintSettings.NoAutoSize = False
    PrintSettings.NoAutoSizeRow = False
    PrintSettings.PrintGraphics = False
    PrintSettings.UseDisplayFont = True
    HTMLSettings.Width = 100
    HTMLSettings.XHTML = False
    Navigation.AdvanceDirection = adLeftRight
    Navigation.InsertPosition = pInsertBefore
    Navigation.HomeEndKey = heFirstLastColumn
    Navigation.TabToNextAtEnd = False
    Navigation.TabAdvanceDirection = adLeftRight
    ColumnSize.Location = clRegistry
    CellNode.Color = clSilver
    CellNode.ExpandOne = False
    CellNode.NodeColor = clBlack
    CellNode.NodeIndent = 12
    CellNode.ShowTree = True
    CellNode.TreeColor = clSilver
    MaxEditLength = 0
    Grouping.HeaderColor = clNone
    Grouping.HeaderColorTo = clNone
    Grouping.HeaderTextColor = clNone
    Grouping.MergeHeader = False
    Grouping.MergeSummary = False
    Grouping.Summary = False
    Grouping.SummaryColor = clNone
    Grouping.SummaryColorTo = clNone
    Grouping.SummaryTextColor = clNone
    IntelliPan = ipVertical
    URLColor = clBlue
    URLShow = False
    URLFull = False
    URLEdit = False
    ScrollType = ssNormal
    ScrollColor = clNone
    ScrollWidth = 17
    ScrollSynch = False
    ScrollProportional = False
    ScrollHints = shNone
    OemConvert = False
    FixedFooters = 0
    FixedRightCols = 0
    FixedColWidth = 12
    FixedRowHeight = 21
    FixedFont.Charset = DEFAULT_CHARSET
    FixedFont.Color = clWindowText
    FixedFont.Height = -11
    FixedFont.Name = 'Tahoma'
    FixedFont.Style = [fsBold]
    FixedAsButtons = False
    FloatFormat = '%.2f'
    IntegralHeight = False
    WordWrap = True
    Lookup = False
    LookupCaseSensitive = False
    LookupHistory = False
    BackGround.Top = 0
    BackGround.Left = 0
    BackGround.Display = bdTile
    BackGround.Cells = bcNormal
    Filter = <>
    CloseWhenLoaded = False
    KeepLinked = True
    DataMapMode = dmRow
    DataSource = DSExportar
    DetailGrid = False
    Fields = <>
    PageMode = True
    ShowMemoFields = True
    ShowPictureFields = True
    ShowBooleanFields = False
    ShowIndicator = True
    ColWidths = (
      12
      36
      118
      64
      64
      64
      64
      64
      95
      85
      64
      85)
  end
  object BitBtn1: TBitBtn
    Left = 358
    Top = 445
    Width = 153
    Height = 39
    Caption = 'Exportar a Excel'
    TabOrder = 1
    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 = 2
  end
  object DBLookupComboBox1: TDBLookupComboBox
    Left = 218
    Top = 16
    Width = 503
    Height = 21
    KeyField = 'ide'
    ListField = 'Area'
    ListSource = DSArea
    TabOrder = 3
  end
  object BitBtn2: TBitBtn
    Left = 395
    Top = 138
    Width = 75
    Height = 25
    Caption = 'Buscar'
    TabOrder = 4
    OnClick = BitBtn2Click
  end
  object ComboBox1: TComboBox
    Left = 155
    Top = 109
    Width = 145
    Height = 21
    ItemHeight = 13
    TabOrder = 5
    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 = 7
  end
  object DSExportar: TDataSource
    DataSet = QExportar
    Left = 697
    Top = 3
  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|*.xls'
    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
end
