Conditional Data Export

[FISCAL]

Hi,

Is is possible to have a conditional data export from the grid? For example let's assume we have a grid with 3 columns as shown below and "Export?" column will either have "Yes" or "No" value. If it has "Yes", that record has to be exported to excel else not?

ID  Name   Export?
1    Scott   Yes
2    Parker  No
3   Milan    Yes


Any help would be highly appreciated and wish you a very Happy New Year ahead.

Many thanks

M G

[Shinu]

Hello,

Before exporting, you can iterate through each item and hide the items based on the condition.

For more on this please refer the following documentation.
Word/Excel export (HTML-based) [Hiding Items section].


Shinu.

[FISCAL]

Hi,

I have thought so but that does not work. I have to display all records in the grid and it's only that during the export process some have to be removed.

I think the other option would be to have grid just for the sake of exporting data but make it hidden..not invisible though!

Cheers,
MG

[Shinu]

Hello,


Here I am pasting the code for what I suggested. Hope this would help you. :)

Code:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.ExportToExcelCommandName)
    {
        foreach( GridDataItem item in RadGrid1.MasterTableView.Items )
        {
            if (item["Export"].Text.ToString() == "No")
            {
                item.Visible = false;
            }
        }
    }
}

happy new year.


-Shinu.

[FISCAL]

Many thanks -  I hope it will solve my problem without having extract grid!

Cheers,
M G