Add columns before export

[Josh]

I have a grid that is pulling data from a stored procedure. When I export, I want to query another stored procedure that has many additional columns of data returned. Is it possible to bind my grid to a separate datasource prior to exporting to excel or pdf? It is not an option for me to loop through the columns returned and show/hide each one. Any thoughts are appreciated!

[Jayesh Goyani]

Hello,

As per my knowledge with RadGrid it is not possible (without column show/hide).

For export you have to take another grid with visible='false'.

Like :

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.ExportToPdfCommandName)
        {
            e.Canceled = true;
            RadGrid2.MasterTableView.ExportToPdf();
            RadGrid2.Rebind();
        }
    }

Thanks,
Jayesh Goyani