or
<telerik:GridTemplateColumn UniqueName="Select"> <ItemTemplate> </ItemTemplate></telerik:GridTemplateColumn><telerik:GridTemplateColumn UniqueName="Select" Visible='<%# CheckboxVisibleCheck(Eval("Column3").ToString)%>'> <ItemTemplate> </ItemTemplate></telerik:GridTemplateColumn><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="InvestorWeb.test" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"><telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" MinDisplayTime="500" Skin="Metro"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxManager runat="server" ID="RadAjaxManager1" DefaultLoadingPanelID="RadAjaxLoadingPanel1"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="ImgEdit"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadAjaxPanel1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="LinkButton1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadAjaxPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxPanel ID="RadAjaxPanel2" runat="server" EnableAJAX="true"> <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AutoGenerateColumns="false" AllowPaging="true" PageSize="20" Width="900px" Skin="Metro" onitemcommand="RadGrid1_ItemCommand"> <ClientSettings> <Selecting AllowRowSelect="True" /> <Resizing AllowColumnResize="true" ClipCellContentOnResize="true" ResizeGridOnColumnResize="true" EnableRealTimeResize="true" /> </ClientSettings> <MasterTableView TableLayout="Fixed"> <Columns> <telerik:GridBoundColumn DataField="RoleID" UniqueName="RoleID" HeaderText="Role ID"> <HeaderStyle Width="100px" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="RoleName" HeaderText="Role Name"> <HeaderStyle Width="500px" HorizontalAlign="Center" /> </telerik:GridBoundColumn> <telerik:GridNumericColumn DataField="Description" HeaderText="Description"> <HeaderStyle Width="270px" HorizontalAlign="Center" /> </telerik:GridNumericColumn> <telerik:GridTemplateColumn HeaderStyle-CssClass="editItem" FooterStyle-CssClass="editItem" ItemStyle-CssClass="editItem"> <HeaderStyle Width="30px" /> <ItemTemplate> <asp:ImageButton ID="ImgEdit" runat="server" ImageUrl="Images/edit.png" Height="15px" Width="15px" ToolTip="Click Here to Edit" CommandName="Edit" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid> </telerik:RadAjaxPanel> <asp:LinkButton ID="LinkButton1" runat="server">Add Reports</asp:LinkButton> <telerik:RadAjaxPanel ID="RadAjaxPanel1" EnableAJAX="true" runat="server" Width="900px" Height="200px"> </telerik:RadAjaxPanel></form></body></html>using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;namespace InvestorWeb{ public partial class test : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("RoleID"); dt.Columns.Add("RoleName"); dt.Columns.Add("Description"); for (int i = 1; i < 80; i++) { dt.Rows.Add(i, "Report" + i, "Desc" + i); } RadGrid1.DataSource = dt; RadGrid1.DataBind(); } protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { } }}ActiveBatchesRadGrid_ItemCommand calls the method ConfigureExport in the base class so all exports function the sameprivate void ActiveBatchesRadGrid_ItemCommand(object source, GridCommandEventArgs e){ switch (e.CommandName) { case RadGrid.InitInsertCommandName: _gridTableView = e.Item.OwnerTableView; break; case RadGrid.ExportToExcelCommandName: ExpandAllDetailTableRecords(source, ExpandedStates, false); ConfigureExport(source, e); break; } }protected static void ConfigureExport(object source, GridCommandEventArgs e){ e.Item.OwnerTableView.ExpandCollapseColumn.Visible = false; e.Item.OwnerTableView.GetColumn("PolicyEditRecord").Visible = false; e.Item.OwnerTableView.GetColumn("DeleteTransaction").Visible = false; e.Item.OwnerTableView.GetColumn("ManualAdjustmentBatchID").Visible = false; e.Item.OwnerTableView.GetColumn("ManualAdjustmentID").Visible = false; ((RadGrid)source).ExportSettings.ExportOnlyData = true; //((RadGrid)source).PageSize = ((RadGrid)source).MasterTableView.VirtualItemCount; ((RadGrid)source).ExportSettings.IgnorePaging = true; ((RadGrid)source).ExportSettings.OpenInNewWindow = false; ((RadGrid)source).MasterTableView.HierarchyDefaultExpanded = false; ((RadGrid)source).MasterTableView.ExportToExcel();}VirtualItemCount is commented out because it throws an "System.ArgumentOutOfRangeException: Specified argument was out of the range of
valid values." error. I have not tried it yet but I think it may be due to the export being conducted on the DetailGrid and not the MasterGrid. Any comments on that would be appreciated too.<telerik:RadGrid ID="gvCCECCommitteeProperties" GridLines="None" AutoGenerateColumns="false" PageSize="15" EnableEmbeddedSkins="true" Skin="Default" Width="99%" AllowFilteringByColumn="true" AllowAutomaticDeletes="false" AllowMultiRowEdit="false" AllowMultiRowSelection="false" AllowPaging="true" AllowSorting="false" runat="server" OnItemCreated="gvCCECCommitteeProperties_ItemCreated" DataSourceID="SqlDataSource1" AllowAutomaticUpdates="true" AllowAutomaticInserts="False" OnInit="gvCCECCommitteeProperties_Init" SelectCommandType="StoredProcedure" SelectCommand="SelectEmployees" UpdateCommandType="" UpdateCommand="UPDATE [CCECCommitteeProperties] SET [LastName] = @LastName, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [Suffix] = @Suffix, [IsDependent] = @IsIndependent, [IsUnopposed] = @IsUnapplosed, [IsOneParty] = @IsOneParty, [IsPrimaryWinner] = @IsPrimaryWinner, [IsGeneralWinner] = @IsGeneralWinner, [IsActive] = @IsActive, [IsQualifiedForBallot] = @IsQualifiedForBallot, [IsReallocated] = @IsReAllocated, [IsIncumbent] = @IsIncumbent WHERE [CCECCommitteePropertyID] = @CCECCommitteePropertyID" ShowStatusBar="true"> <MasterTableView ShowFooter="false" DataKeyNames="CCECCommitteePropertyID" EditMode="InPlace" CommandItemDisplay="TopAndBottom"> <Columns> <telerik:GridEditCommandColumn FooterText="EditCommand footer" UniqueName="EditCommandColumn" HeaderText="Edit" HeaderStyle-Width="100px" UpdateText="Update"> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn HeaderStyle-Width="250px" HeaderText="Names<br>(Last Name)" AllowFiltering="true" DataField="LastName"> <ItemTemplate> <div style="width: 250px"> <asp:Label Width="100px" ID="Label1" runat="server" Text="Last Name;" ></asp:Label> <asp:Label Width="100px" ID="txtLastName" runat="server" Text='<%# Bind("LastName") %>'></asp:Label> <br /> <asp:Label Width="100px" ID="Label2" runat="server" Text="First Name:" ></asp:Label> <asp:Label Width="100px" ID="txtFirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:Label> <br /> <asp:Label Width="100px" ID="Label4" runat="server" Text="Middle Name:" ></asp:Label> <asp:Label Width="100px" ID="txtMiddleName" runat="server" Text='<%# Bind("MiddleName") %>'></asp:Label> <br /> <asp:Label Width="100px" ID="Label3" runat="server" Text="Suffix:" ></asp:Label> <asp:Label Width="100px" ID="txtSuffix" runat="server" Text='<%# Bind("Suffix") %>'></asp:Label> </div> </ItemTemplate> <EditItemTemplate> <div style="width: 250px" > <asp:Label Width="100px" ID="Label1" runat="server" Text="Last Name;" ></asp:Label> <asp:TextBox Width="100px" ID="LastName" runat="server" Text='<%# Bind("LastName") %>'></asp:TextBox> <br /> <asp:Label Width="100px" ID="Label2" runat="server" Text="First Name:" ></asp:Label> <asp:TextBox Width="100px" ID="FirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:TextBox> <br /> <asp:Label Width="100px" ID="Label4" runat="server" Text="Middle Name:" ></asp:Label> <asp:TextBox Width="100px" ID="MiddleName" runat="server" Text='<%# Bind("MiddleName") %>'></asp:TextBox> <br /> <asp:Label Width="100px" ID="Label3" runat="server" Text="Suffix:" ></asp:Label> <asp:TextBox Width="100px" ID="Suffix" runat="server" Text='<%# Bind("Suffix") %>'></asp:TextBox> </div> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Information<br>(Filer Id)" AllowFiltering="true" DataField="CommitteeID"> <ItemTemplate> <div style="float: left;"> FilerID: <asp:Label ID="lblFilerID" runat="server" Text='<%# Eval("CommitteeID") %>'></asp:Label> <br /> Party: <asp:Label ID="lblCandidateParty" runat="server" Font-Bold="False" Text='<%# Eval("PartyName") %>'></asp:Label> </div> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsActive" HeaderText="Active?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsIndependent" HeaderText="Independent?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsUnopposed" HeaderText="Unopposed?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsOneParty" HeaderText="One Party<br>Dominant?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsPrimaryWinner" HeaderText="Primary<br>Winner?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsGeneralWinner" HeaderText="General<br>Winner?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsQualifiedForBallot" HeaderText="Qualified<br>for Ballot?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsReallocated" HeaderText="Reallocated?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsIncumbent" HeaderText="Incumbent?" ></telerik:GridCheckBoxColumn> <telerik:GridBoundColumn Visible="false" DataField="OfficeID" ></telerik:GridBoundColumn> </Columns> </MasterTableView></telerik:RadGrid>protected void gvCCECCommitteeProperties_Init(object sender, System.EventArgs e){ GridFilterMenu menu = gvCCECCommitteeProperties.FilterMenu; int i = 0; while (i < menu.Items.Count) { if (i == 0) { if (menu.Items[i].Text == "NoFilter" || menu.Items[i].Text == "Contains" || menu.Items[i].Text == "StartsWith" || menu.Items[i].Text == "EqualTo") { i++; } else { menu.Items.RemoveAt(i); } } }}