How to: Hide Individual Rows and Columns
- 5 minutes to read
The following example demonstrates how to hide particular rows and columns by handling the CustomFieldValueCells Event. In this example, the event handler iterates through all row headers and removes rows that correspond to the “Employee B” field value, and that are not Total Rows.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/how-to-hide-particular-rows-and-columns-e2767
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs"
Inherits="ASPxPivotGrid_HidingColumnsAndRows._Default" %>
<%@ Register Assembly="DevExpress.Web.ASPxPivotGrid.v13.1, Version=13.1.8.0,
Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxPivotGrid"
TagPrefix="dx" %>
<%@ Register assembly="DevExpress.Web.v13.1, Version=13.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<!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 id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<dx:ASPxRadioButtonList ID="ASPxRadioButtonList1" runat="server" SelectedIndex="0" AutoPostBack="true" >
<Items>
<dx:ListEditItem Text="Default Layout" Value="Default Layout" />
<dx:ListEditItem Text="Delete All Rows Corresponding to "Employee B""
Value="Delete All Rows Corresponding to "Employee B"" />
</Items>
</dx:ASPxRadioButtonList>
<div>
<dx:ASPxPivotGrid ID="pivotGrid" runat="server" Width="500px"
OnFieldValueDisplayText="pivotGrid_FieldValueDisplayText"
OnCustomFieldValueCells="pivotGrid_CustomFieldValueCells"
OptionsCustomization-AllowFilter="false"
OptionsCustomization-AllowDrag="false">
</dx:ASPxPivotGrid>
</div>
</form>
</body>
</html>