Excel Export with external RadFilter

[Fit2Page]

Hi,

When I export data to Excel from a RadGrid with an external RadFilter, I get all the data instead of the filtered data.

I use during export:

Protected Sub Export_Klanten_Click(sender As Object, e As EventArgs) Handles btn_Export_Klanten.Click

RadFilter2.FireApplyCommand()

dtgKlanten.ExportSettings.ExportOnlyData = true
dtgKlanten.ExportSettings.IgnorePaging = true
dtgKlanten.MasterTableView.AllowFilteringByColumn = false
dtgKlanten.ExportSettings.OpenInNewWindow = true
dtgKlanten.ExportSettings.HideStructureColumns = true
dtgKlanten.MasterTableView.ExportToExcel()
End Sub

Protected Sub RadFilter2_ApplyExpressions(sender As Object, e As RadFilterApplyExpressionsEventArgs)
    Dim provider As New RadFilterSqlQueryProvider()
    provider.ProcessGroup(e.ExpressionRoot)
    dtgKlanten.MasterTableView.FilterExpression = provider.Result
    dtgKlanten.Rebind()
End Sub

I thought this would filter the datasource on exporting, but is does not.

Any suggestions?

Marc

[Fit2Page]

Solved this by using the integrated Excel Export buttons of the RadGrid.