[Solved] Export to excel after server side sort

[Guido Tapia]

Hi All,

I'm trying to fix an issue with an export to excel functionality requirement I have.  Basically I need to sort the grid before exporting to excel.  I'm trying this at the moment:

private void OnExportToExcelClicked(object sender, EventArgs e)

{

            grid.MasterTableView.SortExpressions.Clear();

            grid.MasterTableView.SortExpressions.AddSortExpression(new GridSortExpression {FieldName = whateverFieldName, SortOrder = GridSortOrder.Ascending});

            grid.MasterTableView.Rebind();

            grid.MasterTableView.ExportToExcel();

}

However this is not working.

Is there anything I'm missing here?

Thanks

Guido Tapia

[Princy]

Hello Guido,

Try setting the sort expression as shown in the code below and see if it helps:
c#:

private void OnExportToExcelClicked(object sender, EventArgs e)
{
            GridSortExpression expression = new GridSortExpression();
            expression.FieldName = "FieldName";
            expression.SortOrder = GridSortOrder.Ascending;
            grid.MasterTableView.SortExpressions.Clear();
            grid.MasterTableView.SortExpressions.AddSortExpression(expression);
            grid.MasterTableView.Rebind();

            grid.MasterTableView.ExportToExcel();
}

Thanks
Princy.

[Guido Tapia]

I don't know if I'm missing something here, but isn't that exactly the same as my code?

Guido

[Guido Tapia]

My apologies,

I had forgotten I had implemented custom sorting on this grid. 

Operator error.

Thanks

Guido