Exporting only selected rows

[Debbie]

Is there a way to only export the selected rows of a RadGrid?  What I need to do is provide a view of only selected rows -- so I plan to use export to PDF (in a new window) where the user can print the grid contents. 

thanks!
Debbie

[Debbie]

nevermind, found a solution.

[Debbie]

I spoke to quickly, the fix that I found on another post didn't work.

I'm trying to only display selected rows when exporting to EXCEL.

 foreach (GridDataItem item in grid.Items)
{

        itemitem.Visible = item.Selected;

}

But this doesn't appear to work.  I have two rows in my grid, only one row selected, but export is still exporting all rows in the grid.

Any help / suggestions are appreciated.

thanks!
Debbie

[Princy]

Hello Debbie,

You can try thie following code snippet and see if it helps.

 protected void Button1_Click(object sender, EventArgs e)
    {
          foreach (GridDataItem item in RadGrid1.Items)
        {
            if (item.Selected==false)
            {
                item.Visible = false;
            }
        }
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Princy.

[Debbie]

that is what I'm doing, but that isn't working.  Here's my code I'm running...

protected void btnExport_Click(object sender, EventArgs e)
        {

            SetForRefresh(false);
            switch (tpTaskMgmt.ActiveTabIndex)
            {
                case (int) Tabs.Unassigned:
                    ExportGrid(gridUnassigned, true);
                    break;
                case (int)Tabs.MyTasks:
                    ExportGrid(gridMyTasks, true);
                    break;
                case (int)Tabs.ReplenishReady:
                    ExportGrid(gridReplenishReady, true);
                    break;

            }

        }

        private static void ExportGrid(RadGrid grid, bool selectedOnly)
        {

            if (selectedOnly)
            {
                foreach (GridDataItem item in grid.Items)
                {
                       item.Visible = item.Selected;
                }
            }
            grid.MasterTableView.Columns.FindByUniqueName("colSelect").Visible = false;
            grid.ExportSettings.ExportOnlyData = true;
            grid.ExportSettings.OpenInNewWindow = true;
            grid.MasterTableView.ExportToWord();
        }

[Sic]

did you find a solution to this issue? We're having the same problem

Thx,
Greg

[Yavor]

Hello Sic,

Attached to this message, is a small application, which handles a similar case.
I hope it helps.

All the best,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Vaibhav]

Hi.
I need  to export only selected rows to excel.
I am able to hide columns before exporting.
I have searched a lot regarding hiding unselected rows/Exporting only selected rows in telerik threads.
In all my search results I found the below line of code. 

​ if (Grid.SelectedItems.Count != 0)
{
foreach (GridDataItem item in Grid.MasterTableView.Items)
{
if (!item.Selected)
item.Visible = false;
}
} My excel format is"BIFF".
Its very urgent.
Please help

[Allen]

Doesn't setting these to invisible mean they have to be reset to visible after the export completes?

[Eyup]

Hi Allen,

Any changes made while exporting won't affect the overall settings of the grid and these changes won't persist after the export action.

Regards,
Eyup
Telerik

[Matej]

[quote]Vaibhav said:
item.Visible = false;
[/quote]

item.Display = false;  works for me