Gridview Group By

[Scott]

Hello hopefully someone can help me.  I'm looking to do a group by on the gridview control, but I don't want it user expandable.  I want it to already be expanded not allowing the user for collapse and look like the file attached.  Does anyone know how to control this with the Telerik GridView?

Any help would be greatly appreciated.

[Jack]

Hi Scott,

You can expand all groups by setting AutoExpandGroups property to true and you can hide the group headers by setting GroupHeaderHeight to 0. Here is a sample:

this.radGridView1.MasterGridViewTemplate.AutoExpandGroups = true;
((GridTableElement)this.radGridView1.GridElement).GroupHeaderHeight = 0;

Currently it is not possible to merge cells between rows. So, you can't achieve the layout from the picture. We have in mind this feature and it will be implemented in one of our upcoming releases. Should you have any other questions, please write back.

Regards,

Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Scott]

Is There a way I can do this grouping, and  not allow the users to change/modify the grouping that I set in the program?  It seems that if I turn EnableGrouping=False off so the users can't change grouping then the grid doesn't group when I conduct it programatically.

[Jack]

Hello Scott,

You can hide the group panel by setting ShowGroupPanel property to false. You can also disable the context menu item when handling ContextMenuOpening event:

this.radGridView1.MasterGridViewTemplate.GroupByExpressions.Add("Value GroupBy Value");
this.radGridView1.MasterGridViewTemplate.AutoExpandGroups = true;
this.radGridView1.ShowGroupPanel = false;
this.radGridView1.ContextMenuOpening += new ContextMenuOpeningEventHandler(radGridView1_ContextMenuOpening);

void radGridView1_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
{
    GridHeaderCellElement cell = e.ContextMenuProvider as GridHeaderCellElement;
    if (cell != null)
    {
        e.ContextMenu.Items.RemoveAt(6);
    }
}

I hope this helps.

Greetings,

Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.