or

<telerik:RadGrid ID="RadGridEmployeeCost" runat="server" AllowSorting="True" AllowPaging="true" AllowFilteringByColumn="true" CellSpacing="0" GridLines="None" HeaderStyle-Font-Bold="true" Skin="Web20" OnNeedDataSource="RadGridEmployeeCost_NeedDataSource" ShowGroupPanel="true" OnColumnCreated="RadGridEmployeeCost_ColumnCreated"> <ClientSettings AllowDragToGroup="True" /></telerik:RadGrid>protected void RadGridEmployeeCost_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { ObjCon.Open(); SqlCommand ObjCmd = new SqlCommand("SELECT name,address,TelPhone,EmailId,Qualification FROM WorkSummary", ObjCon); ObjCmd.ExecuteNonQuery(); SqlDataAdapter ObjDa = new SqlDataAdapter(ObjCmd); DataSet ds = new DataSet(); ObjDa.Fill(ds); RadGridEmployeeCost.DataSource = ds; } } protected void RadGridEmployeeCost_ColumnCreated(object sender, GridColumnCreatedEventArgs e) { if ((e.Column is GridBoundColumn && e.Column.UniqueName == "TelPhone" || e.Column.UniqueName == "EmailId" || e.Column.UniqueName == "Qualification")) { GridBoundColumn column = e.Column as GridBoundColumn; column.AllowFiltering = false; } }Private Sub SetFilters(ByVal grid As RadGrid) grid.MasterTableView.AllowFilteringByColumn = gridConfiguration.EnableHeaderFiltering If gridConfiguration.EnableHeaderFiltering Then grid.MasterTableView.CommandItemTemplate = New RadGridCommandItemFilterTemplate End IfEnd SubFriend Class RadGridCommandItemFilterTemplate Implements ITemplate Public showHideFilter As RadButton Public Sub New() MyBase.New() End Sub Public Sub InstantiateIn(ByVal container As Control) Implements ITemplate.InstantiateIn showHideFilter = New RadButton With {.ID = "showHideFilter", .Text = "Show / Hide Filters", .CommandName = "ShowHideFilters", .OnClientCheckedChanged = "showHideFilters()"} container.Controls.Add(showHideFilter) End SubEnd Class <telerik:RadScriptManager ID="ScriptManager" runat="server"> </telerik:RadScriptManager> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="ConfigureGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="ConfigureGrid" LoadingPanelID="AjaxLoadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid runat="server" ID ="ConfigureGrid" GridLines="None" AutoGenerateColumns="false" Skin="WebBlue"/> <telerik:RadAjaxLoadingPanel ID="AjaxLoadingPanel" runat="server"/> <asp:SqlDataSource ID="PrimaryDataSource" runat="server"/></form><script type="text/javascript"> function showFilterItem() { var grid = $find("<%=ConfigureGrid.ClientID%>"); if (grid) { grid.get_masterTableView().showFilterItem(); } } function hideFilterItem() { var grid = $find("<%=ConfigureGrid.ClientID%>"); if (grid) { grid.get_masterTableView().hideFilterItem(); } } function showHideFilters() { var radButton = document.getElementById("showHideFilter"); if (radButton) { if (radButton.checked) { showFilterItem(); } else { hideFilterItem(); } } }</script><telerik:PivotGridAggregateField DataField="StatusText" Aggregate="Count" Caption="Counts" UniqueName="Counts" IsHidden="false"></telerik:PivotGridAggregateField><telerik:RadPivotGrid ID="RadPivotGrid_DataView" runat="server" ConfigurationPanelSettings-DefaultDeferedLayoutUpdate="false" Height="100%" AggregatesPosition="Rows" AllowSorting="True" OnItemCommand="RadPivotGrid_DataView_ItemCommand" OnCellCreated="RadPivotGrid_DataView_CellCreated" DataSourceID="Sql_Contract_Details" EnableToolTips="True" EnableZoneContextMenu="True" EnableConfigurationPanel="True" OnFieldCreated="RadPivotGrid_DataView_FieldCreated" Skin="Metro" OnCellDataBound="RadPivotGrid_DataView_CellDataBound" Culture="en-GB" OnItemNeedCalculation="RadPivotGrid_DataView_ItemNeedCalculation" AllowPaging="True" PageSize="30"> <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox" AlwaysVisible="True" /> <Fields>...</Fields> <ClientSettings EnableFieldsDragDrop="True"> <Scrolling AllowVerticalScroll="True"></Scrolling> </ClientSettings> <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" DefaultDeferedLayoutUpdate="True" LayoutType="OneByFour"></ConfigurationPanelSettings> </telerik:RadPivotGrid>
<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnableRowHoverStyle="True" AllowColumnHide="False">
<Selecting AllowRowSelect="False" />
<Resizing AllowColumnResize="True" AllowResizeToFit="True" ResizeGridOnColumnResize="False" />
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
<ClientMessages DragToGroupOrReorder="Click the Header to Sort; Drag to Reorder; Right Click for Context Menu" />
</ClientSettings>
...
<ColumnGroups> <telerik:GridColumnGroup HeaderText="MHO Portal Access" Name="User" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup> <telerik:GridColumnGroup HeaderText="Census Tract Exclusions" Name="CT" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup> <telerik:GridColumnGroup HeaderText="Rental Listings" Name="Rental" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup> <telerik:GridColumnGroup HeaderText="Real Estate Professionals" Name="REP" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup></ColumnGroups><Columns> <telerik:GridBoundColumn DataField="MHA" HeaderText="MHA" SortExpression="MHA" UniqueName="MHA" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MHA_MHO_ID" HeaderText="MHA_MHO_ID" SortExpression="MHA_MHO_ID" UniqueName="MHA_MHO_ID" Visible="false"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Service_Name" FilterControlAltText="Filter Service_Name column" HeaderTooltip="Service" HeaderText="Service" SortExpression="Service_Name" UniqueName="Service_Name" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Is_Primary" FilterControlAltText="Filter Is_Primary column" HeaderTooltip="Role" HeaderText="Role" SortExpression="Is_Primary" UniqueName="Is_Primary" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MHO_Name" FilterControlAltText="Filter MHO_Name column" HeaderTooltip="MHO Name" HeaderText="MHO Name" SortExpression="MHO_Name" UniqueName="MHO_Name" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="POC" HeaderText="POC" SortExpression="POC" UniqueName="POC" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Title" HeaderText="Title" SortExpression="Title" UniqueName="Title" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Phone_Number" HeaderText="Phone" SortExpression="Phone_Number" UniqueName="Phone_Number" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Email" HeaderText="Email" SortExpression="Email" UniqueName="Email" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="First_Login" HeaderText="First Login" ColumnGroupName="User" SortExpression="First_Login" UniqueName="First_Login" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Last_Login" HeaderText="Last Login" ColumnGroupName="User" SortExpression="Last_Login" UniqueName="Last_Login" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Submission" HeaderText="Submit" ColumnGroupName="CT" SortExpression="CT_Submission" UniqueName="CT_Submission" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Total" HeaderText="Total" ColumnGroupName="CT" SortExpression="CT_Total" UniqueName="CT_Total" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Included" HeaderText="In." ColumnGroupName="CT" SortExpression="CT_Included" UniqueName="CT_Included" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Excluded" HeaderText="Ex." ColumnGroupName="CT" SortExpression="CT_Excluded" UniqueName="CT_Excluded" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Neutral" HeaderText="NA" ColumnGroupName="CT" SortExpression="CT_Neutral" UniqueName="CT_Neutral" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Percent_Excluded" HeaderText="% Ex" ColumnGroupName="CT" SortExpression="CT_Percent_Excluded" UniqueName="CT_Percent_Excluded" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Percent_Updated" HeaderText="% Updated" ColumnGroupName="CT" SortExpression="CT_Percent_Updated" UniqueName="CT_Percent_Updated" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Rental_Submission" HeaderText="Submit" ColumnGroupName="Rental" SortExpression="Rental_Submission" UniqueName="Rental_Submission" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Rental_Total" HeaderText="Total" ColumnGroupName="Rental" SortExpression="Rental_Total" UniqueName="Rental_Total" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Rental_Current" HeaderText="Current" ColumnGroupName="Rental" SortExpression="Rental_Current" UniqueName="Rental_Current" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="REP_Submission" HeaderText="Submit" ColumnGroupName="REP" SortExpression="REP_Submission" UniqueName="REP_Submission" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="REP_Total" HeaderText="Total" ColumnGroupName="REP" SortExpression="REP_Total" UniqueName="REP_Total" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="REP_Current" HeaderText="Current" ColumnGroupName="REP" SortExpression="REP_Current" UniqueName="REP_Current" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn></Columns>