Excel filtering not showing up

[Roy Cunningham]

Grouping Grid control

Here is my code

I am dynamically pouplating the rows from an an Array List

they show up fine and sorting works

but filtering does not show??

Dim al As New ArrayList()

oGrid.TopLevelGroupOptions.ShowFilterBar = True

al.Add(New Data("tEST1", "TEST5", "TEST7", "TEST14", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST3", "TEST4", "TEST8", "TEST15", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

al.Add(New Data("tEST4", "TEST3", "TEST9", "TEST16", Now(), Now(), True, "TEST"))

oGrid.TableDescriptor.AllowNew = False

oGrid.ShowGroupDropArea = True

Me.oGrid.DataSource = al

Dim gridExcelFilter As New GridExcelFilter

gridExcelFilter.WireGrid(Me.oGrid) 'THIS DOES NOT SHOW ME ANY FILTER in the column headers!???

Does it only work with data bound to a dataset?

[Arulpriya Ramalingam]

Hi Roy,  

  

We have analyzed your code part. To avail the GridExcelFilter support for the columns, you need to enable the filtering support for that columns and this can be achieved by setting the AllowFilter property of GridColumnDescriptor to true. We have created a simple sample as per your requirement. Please make use of the below code and sample,  

  

Code example  

  

//To set the datasource  

this.gridGroupingControl1.DataSource = dataSource;  

  

foreach (GridColumnDescriptor column inthis.gridGroupingControl1.TableDescriptor.Columns)  

{  

    //To enable the filter for columns  

    column.AllowFilter = true;  

}  

  

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/AllowFilter764869570   

  

Regards,  

Arulpriya