How to: Add Unbound Fields

  • 2 min to read

The following example shows how to add unbound fields to the ASPxPivotGrid.

The 'DiscountAmount' unbound field's values are calculated using the PivotGridFieldBase.UnboundExpression property, while the 'PriceWithDiscount' unbound field is populated by handling the ASPxPivotGrid.CustomUnboundFieldData event.

NOTE

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-add-unbound-fields-e1892

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs"
       Inherits="AddUnboundField._Default" %>

<%@ Register Assembly="DevExpress.Web.ASPxPivotGrid.v13.1, Version=13.1.5.0,
       Culture=neutral, PublicKeyToken=b88d1754d700e49a"
       Namespace="DevExpress.Web.ASPxPivotGrid"
       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 runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <dx:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server" DataSourceID="AccessDataSource1"
             OnCustomUnboundFieldData="CustomUnboundFieldData">
            <Fields>
                <dx:PivotGridField ID="fieldSalesperson" Area="RowArea"
                      AreaIndex="0" FieldName="Salesperson">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldCountry" Area="ColumnArea"
                      AreaIndex="0" FieldName="Country">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldExtendedPrice" Area="DataArea"
                      AreaIndex="0" FieldName="ExtendedPrice">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldDiscount" Area="DataArea"
                      AreaIndex="1" FieldName="Discount">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldDiscountAmount" Area="DataArea"
                      UnboundExpression="[ExtendedPrice]*[Discount]"
                      AreaIndex="2" UnboundType="Decimal"
                      Caption="Discount Amount">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldPriceWithDiscount" Area="DataArea"
                      AreaIndex="3" UnboundType="Decimal"
                      FieldName="PriceWithDiscount"
                      Caption="Price with Discount">
                </dx:PivotGridField>
            </Fields>
        </dx:ASPxPivotGrid>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server"
                DataFile="~/App_Data/nwind.mdb"
                SelectCommand="SELECT [Salesperson], [Country],
                       [ExtendedPrice], [Discount]
                       FROM [Invoices]">
        </asp:AccessDataSource>
    </div>
    </form>
</body>
</html>
See Also