DevExpress でのピボットグリッドの画面操作パネルのレイアウト変更禁止設定

DevExpress でのピボットグリッドの画面操作パネル（ASPxPivotCustomizationControl）のレイアウト変更禁止設定サンプルです。

現状の画面デザインはこのようになっています。

＜画面操作パネルのレイアウト変更禁止設定＞

・「ASPxPivotCustomizationControl」に「AllowedLayouts=”BottomPanelOnly1by4″」を設定します。

【サンプルプログラム】

<table>
    <tr>
        <td valign="top">
            <div>
                <dx:ASPxPivotCustomizationControl ID="ASPxPivotCustomizationControl1" runat="server"
                    Height="450px" Width="250px" ASPxPivotGridID="ASPxPivotGrid1" 
                    AllowedLayouts="BottomPanelOnly1by4" AllowFilter="True" AllowSort="True" 
                    DeferredUpdates="True" Layout="BottomPanelOnly1by4">
                </dx:ASPxPivotCustomizationControl>
            </div>
        </td>
        <td>
            <div>
                <dx:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server" ClientIDMode="AutoID" 
                    DataSourceID="XpoDataSource1" EnableTheming="True" Theme="RedWine" 
                    Caption="売上一覧（ピボットグリッド）">
                    <Fields>
                        <dx:PivotGridField ID="fieldKINGAKU" Area="DataArea" AreaIndex="0" 
                            FieldName="KINGAKU" Caption="金額" CellFormat-FormatString="#,###" 
                            CellFormat-FormatType="Numeric">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldAQUREXNAME" Area="RowArea" AreaIndex="0" 
                            FieldName="AQUREX_NAME" Caption="担当者">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldPROJECT" Area="RowArea" AreaIndex="1" 
                            FieldName="PROJECT" Caption="案件" TotalValueFormat-FormatString="{0} 合計" 
                            TotalValueFormat-FormatType="Custom">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldTORIHIKICHIHOCHIHOMEI" Area="RowArea" AreaIndex="2" 
                            FieldName="TORIHIKI_CHIHO.CHIHOMEI" Caption="取引先場所" 
                            TotalValueFormat-FormatString="{0} 合計" TotalValueFormat-FormatType="Custom">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldTORIHIKICOMPANY" Area="RowArea" AreaIndex="3" 
                            FieldName="TORIHIKI_COMPANY" Caption="取引先名">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldTORIHIKITANTO" Area="RowArea" AreaIndex="4" 
                            FieldName="TORIHIKI_TANTO" Visible="False" Caption="取引先担当者">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldSALESEDATE" Area="ColumnArea" AreaIndex="0" 
                            FieldName="SALESE_DATE" Caption="売上年" GroupInterval="DateYear" 
                            UnboundFieldName="fieldSALESEDATE" TotalValueFormat-FormatString="{0}年 合計" 
                            TotalValueFormat-FormatType="Custom" ValueFormat-FormatString="{0}年" 
                            ValueFormat-FormatType="Custom">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldSALESEDATE1" Area="ColumnArea" AreaIndex="1" 
                            FieldName="SALESE_DATE" Caption="売上月" GroupInterval="DateMonth" 
                            UnboundFieldName="fieldSALESEDATE1">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldSALESEDATE2" AreaIndex="0" FieldName="SALESE_DATE" 
                            Caption="売上年" GroupInterval="DateYear" UnboundFieldName="fieldSALESEDATE2">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldSALESEDATE3" AreaIndex="1" FieldName="SALESE_DATE" 
                            Caption="売上月" GroupInterval="DateMonth" 
                            UnboundFieldName="fieldSALESEDATE3">
                        </dx:PivotGridField>
                    </Fields>
                    <OptionsPager Position="Bottom">
                        <FirstPageButton Visible="True">
                        </FirstPageButton>
                        <LastPageButton Visible="True">
                        </LastPageButton>
                        <PageSizeItemSettings Caption="表示件数：" Visible="True">
                        </PageSizeItemSettings>
                    </OptionsPager>
                </dx:ASPxPivotGrid>
            </div>
        </td>
    </tr>
</table>
<div>
    <dx:XpoDataSource ID="XpoDataSource1" runat="server" 
        TypeName="Sample_07.SAMPLE.SALESE_INFO">
    </dx:XpoDataSource>
</div>

<table>

<tr>

<div>

<dx:ASPxPivotCustomizationControl ID="ASPxPivotCustomizationControl1" runat="server"

Height="450px" Width="250px" ASPxPivotGridID="ASPxPivotGrid1"

AllowedLayouts="BottomPanelOnly1by4" AllowFilter="True" AllowSort="True"

DeferredUpdates="True" Layout="BottomPanelOnly1by4">

</dx:ASPxPivotCustomizationControl>

</div>

</td>

<td>

<div>

<dx:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server" ClientIDMode="AutoID"

DataSourceID="XpoDataSource1" EnableTheming="True" Theme="RedWine"

Caption="売上一覧（ピボットグリッド）">

<dx:PivotGridField ID="fieldKINGAKU" Area="DataArea" AreaIndex="0"

FieldName="KINGAKU" Caption="金額" CellFormat-FormatString="#,###"

CellFormat-FormatType="Numeric">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldAQUREXNAME" Area="RowArea" AreaIndex="0"

FieldName="AQUREX_NAME" Caption="担当者">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldPROJECT" Area="RowArea" AreaIndex="1"

FieldName="PROJECT" Caption="案件" TotalValueFormat-FormatString="{0} 合計"

TotalValueFormat-FormatType="Custom">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldTORIHIKICHIHOCHIHOMEI" Area="RowArea" AreaIndex="2"

FieldName="TORIHIKI_CHIHO.CHIHOMEI" Caption="取引先場所"

TotalValueFormat-FormatString="{0} 合計" TotalValueFormat-FormatType="Custom">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldTORIHIKICOMPANY" Area="RowArea" AreaIndex="3"

FieldName="TORIHIKI_COMPANY" Caption="取引先名">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldTORIHIKITANTO" Area="RowArea" AreaIndex="4"

FieldName="TORIHIKI_TANTO" Visible="False" Caption="取引先担当者">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldSALESEDATE" Area="ColumnArea" AreaIndex="0"

FieldName="SALESE_DATE" Caption="売上年" GroupInterval="DateYear"

UnboundFieldName="fieldSALESEDATE" TotalValueFormat-FormatString="{0}年合計"

TotalValueFormat-FormatType="Custom" ValueFormat-FormatString="{0}年"

ValueFormat-FormatType="Custom">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldSALESEDATE1" Area="ColumnArea" AreaIndex="1"

FieldName="SALESE_DATE" Caption="売上月" GroupInterval="DateMonth"

UnboundFieldName="fieldSALESEDATE1">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldSALESEDATE2" AreaIndex="0" FieldName="SALESE_DATE"

Caption="売上年" GroupInterval="DateYear" UnboundFieldName="fieldSALESEDATE2">

</dx:PivotGridField>

<dx:PivotGridField ID="fieldSALESEDATE3" AreaIndex="1" FieldName="SALESE_DATE"

Caption="売上月" GroupInterval="DateMonth"

UnboundFieldName="fieldSALESEDATE3">

</dx:PivotGridField>

</Fields>

</FirstPageButton>

</LastPageButton>

</PageSizeItemSettings>

</OptionsPager>

</dx:ASPxPivotGrid>

</div>

</td>

</tr>

</table>

<div>

<dx:XpoDataSource ID="XpoDataSource1" runat="server"

TypeName="Sample_07.SAMPLE.SALESE_INFO">

</dx:XpoDataSource>

</div>

それでは、実行して動作確認を行います。

↓

※レイアウト変更アイコン非表示

無事にピボットグリッドの画面操作パネル（ASPxPivotCustomizationControl）のレイアウト変更禁止設定が出来ました。

MENU

最近の投稿

人気記事

MENU

DevExpress でのピボットグリッドの画面操作パネルのレイアウト変更禁止設定

関連記事はこちら:

最近の投稿

人気記事