Data Shaping Features - Fields Customization

Customization Form Style:

Allow Drag Fields

Customization Form Layout:

Allow Drag Fields In Customization Form

Show Customization Window

Page 1 of 4 (37 items)

Order Year

Order Amount

Quantity

Country

Order Quarter

Category Name

Qtr 1

Beverages

Condiments

Confections

Dairy Products

Grains/Cereals

Meat/Poultry

Produce

Seafood

Qtr 1 Total

Qtr 2

Beverages

Grand Total

Page 1 of 4 (37 items)

Description

This example shows the Fields Customization Window. This allows you to temporarily hide specific fields and then restore them again when needed.

ASPxPivotGrid allows you to show and hide the Fields Customization Window both on the server (using C# or VB code) and on the client using JavaScript. This demo shows the JavaScript usage. Here, when clicking the btnCustomizationFields button, we are calling the ChangeCustomizationFieldsVisibility() function which hides or shows the Fields Customization Window.

The ChangeCustomizationFieldsVisibility function is a part of the ASPxPivotGrid's ClientSideAPI. The ClientSideAPI is a collection of functions and events available on the client. These functions are disabled by default. To turn them on, set the EnableClientSideAPI property value to true.

Also, the demo shows the usage of the ClientSide CustomizationFieldsVisibleChanged event. When fired, this event changes the btnCustomizationFields button caption from "Show" to "Hide" and vice versa. This event is available only when the EnableClientSideAPI property is true.