This is a migrated thread and some comments may be shown as answers.

telerik:RadGrid with updatepanel

5 Answers 270 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Gaurav asked on 01 Jun 2011, 01:24 PM

Hi Telerik

I am using telerik:GridGroupByExpression.

My code is following..........

<telerik:RadGrid AlternatingItemStyle-CssClass="even" Width="100%" OnItemCreated="radGridComments_ItemCreated"

OnColumnCreated="radGridComments_ColumnCreated" OnItemDataBound="radGridComments_ItemDataBound"

ID="radGridComments" runat="server" AutoGenerateColumns="true" GridLines="none">

<mastertableview groupsdefaultexpanded="true">

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldName="ItemName" HeaderText="" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldName="ItemName" SortOrder="Ascending" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

</mastertableview>

<clientsettings>

<Resizing ResizeGridOnColumnResize="false" AllowColumnResize="true" />

</clientsettings>

</telerik:RadGrid>

It display fine on page load as following.

As soon as I click on export, export to excel is working fine. but the data is now displaying like

Please see the GridGroupByField in both images. Please look in to this issue. I don't want GridGroupByField name like with

"ItemName:" it must be same as before like "Please indicate the region in which you currently work."

Thanks
Gaurav

5 Answers, 1 is accepted

answered on 02 Jun 2011, 06:54 AM

Hello Gaurav,

Try the following code snippet in order to hide the groupheader when exporting.
C#:

protected void Button1_Click(object sender, EventArgs e)

{

RadGrid1.ExportSettings.ExportOnlyData = true;

RadGrid1.ExportSettings.OpenInNewWindow = true;

foreach (GridGroupHeaderItem groupItem in RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader))

{

groupItem.Visible = false;

}

RadGrid1.MasterTableView.ExportToExcel();

}

Thanks,
Shinu.