Current filter:
                                You should refresh the page.
                                E

                                How to Display Underlying Records

                                Tags:
                                0

                                The ASPxPivotGrid includes the drill-down capability, which enables you to retrieve a list of records that were used to calculate a particular summary.

                                To obtain drill-down data, use the pivot grid's CreateDrillDownDataSource method. Its parameters completely identify a summary cell.

                                In this example, an end-user can view records from the control's underlying data source, associated with a summary cell, by clicking on it. The obtained data is displayed by the ASPxGridView within a popup window.

                                Leave a Comment
                                You must  log in  or  register  to leave comments
                                Select file
                                • Default.aspx
                                • Default.aspx.cs
                                Select language
                                • C#
                                • VB.NET
                                Select version
                                • v2009 vol 3.2 - v2012 vol 2.8
                                <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs"
           Inherits="DisplayUnderlyingRecords._Default" %>

<%@ Register Assembly="DevExpress.Web.ASPxGridView.v9.3, Version=9.3.1.0,
           Culture=neutral, PublicKeyToken=b88d1754d700e49a"
           Namespace="DevExpress.Web.ASPxGridView"
           TagPrefix="dxwgv" %>

<%@ Register Assembly="DevExpress.Web.v9.3, Version=9.3.1.0,
         Culture=neutral, PublicKeyToken=b88d1754d700e49a"
         Namespace="DevExpress.Web.ASPxPopupControl"
         TagPrefix="dxpc" %>

<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v9.3, Version=9.3.1.0,
         Culture=neutral, PublicKeyToken=b88d1754d700e49a"
         namespace="DevExpress.Web.ASPxPivotGrid"
         tagprefix="dxwpg" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.3, Version=9.3.1.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 runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <input runat="server" id="ColumnIndex" type="hidden" enableviewstate="true" />
    <input runat="server" id="RowIndex" type="hidden" enableviewstate="true" />
    <div>
        <dxwpg:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server"
            DataSourceID="AccessDataSource1"            
            ClientInstanceName="PivotGrid">
            <Styles>
                <CellStyle Cursor="pointer">
                </CellStyle>
            </Styles>
            <Fields>
                <dxwpg:PivotGridField Area="RowArea" AreaIndex="0"
                    Caption="Customer" FieldName="CompanyName"
                    ID="fieldCompanyName">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField Area="ColumnArea" AreaIndex="0"
                    Caption="Year" FieldName="OrderDate"
                    UnboundFieldName="Year"
                    GroupInterval="DateYear"
                    ID="fieldOrderDate">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField Area="DataArea" AreaIndex="0"
                    FieldName="ProductAmount"
                    Caption="Product Amount"
                    ID="fieldProductAmount">
                </dxwpg:PivotGridField>
                <dxwpg:PivotGridField Area="RowArea" AreaIndex="1"
                    Caption="Products" FieldName="ProductName"
                    ID="fieldProductName">
                </dxwpg:PivotGridField>
            </Fields>
            <OptionsView ShowFilterHeaders="False" />
        </dxwpg:ASPxPivotGrid>
        <dxpc:ASPxPopupControl ID="ASPxPopupControl1" runat="server"
              Left="200" Top="200" CloseAction="CloseButton"
              ClientInstanceName="DrillDownWindow"
              HeaderText="Drill Down Window"
              Width="153px"  Height="1px"
              AllowDragging="True">
            <ContentCollection>
                <dxpc:PopupControlContentControl runat="server">
                    <dxwgv:ASPxGridView ID="ASPxGridView1" runat="server"
                          OnCustomCallback="ASPxGridView1_CustomCallback"
                          ClientInstanceName="GridView"
                          AutoGenerateColumns="False">
                        <ClientSideEvents EndCallback="function(s, e) {
	                  DrillDownWindow.SetClientWindowSize(-1, 100, 100);
                          }" />
                        <Columns>
                            <dxwgv:GridViewDataTextColumn Caption="Product Name"
                                     FieldName="ProductName" VisibleIndex="0">
                            </dxwgv:GridViewDataTextColumn>
                            <dxwgv:GridViewDataTextColumn Caption="Company Name"
                                     FieldName="CompanyName" VisibleIndex="1">
                            </dxwgv:GridViewDataTextColumn>
                            <dxwgv:GridViewDataDateColumn Caption="Order Date"
                                     FieldName="OrderDate" VisibleIndex="2">
                            </dxwgv:GridViewDataDateColumn>
                            <dxwgv:GridViewDataTextColumn Caption="Product Amount"
                                     FieldName="ProductAmount" VisibleIndex="3">
                            </dxwgv:GridViewDataTextColumn>
                            <dxwgv:GridViewDataTextColumn Caption="Year"
                                     FieldName="Year" VisibleIndex="4">
                            </dxwgv:GridViewDataTextColumn>
                        </Columns>
                        <SettingsLoadingPanel Mode="ShowOnStatusBar" />
                        <Styles>
                            <Header ImageSpacing="5px" SortingImageSpacing="5px">
                            </Header>
                        </Styles>
                    </dxwgv:ASPxGridView>
                </dxpc:PopupControlContentControl>
            </ContentCollection>
        </dxpc:ASPxPopupControl>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server"
            DataFile="~/App_Data/nwind.mdb"
            SelectCommand="SELECT * FROM [CustomerReports]"
            DataSourceMode="DataReader" />

        <script type="text/javascript">
            function ShowDrillDown() {
                var mainTable = PivotGrid.GetMainTable();
                DrillDownWindow.ShowAtPos(_aspxGetAbsoluteX(mainTable), 
                      _aspxGetAbsoluteY(mainTable));
            }
        </script>

    </div>
    </form>
</body>
</html>