New to Telerik UI for ASP.NET AJAXStart a free 30-day trial

Configuration Wizard

The Configuration Wizard provides you with an easy and straight forward way for setting up your RadPivotGrid control. You can set up and control the structure and main functionalities from here.

When you open the wizard, it shows the settings grouped by their purpose. You can navigate through the different groups by using the menu on the left. Below follows a description of each set of settings:

General

This is a group of settings that are not so tightly related but form the main structure and behavior of the control.They are:

  • Data - shows a dropdown where you can pick the ID of the declarative data source to which RadPivotGrid should be bound.

  • Performance optimizations - here you can enable the usage of a queryable data provider when binding RadPivotGrid in .NET 4.0 or later.

  • Tables layout - two dropdowns let you choose the table-layout setting of the tables displaying the row and column headers.

  • Data cells - shows two textboxes. In the first one you can write a custom text which will appear when an aggregate cell has no value; in the second you can put in the text to show in aggregate cells whenthere was an error during calculation.

  • Sorting - displays a checkbox which you can use to enable and disable sorting in RadPivotGrid.

    General

Paging

These settings control the paging in RadPivotGrid. They are organized in two sections:

  • Paging - shows a checkbox used to enable and disable paging and a numeric box which lets you set the page size of the control.

  • Page Navigation - allows you to customize the navigation options in the RadPivotGrid pager.The Always show navigation checkbox is used to decide whether the pager will be displayed when the items in RadPivotGrid are less than the page size.There are also two dropdowns that let you choose the position of the pager inside the rendered pivot grid and its mode.

    Paging

For more information on paging in RadPivotGrid, see these articles:

Basic Paging

Pager Item

Styles

Here you can customize the styles applied to RadPivotGrid. There is a separate property grid for the whole pivot grid and for each logical structure of the control. Styles

For information and code samples of how you can apply custom styles based on different criteria inside RadPivotGrid,check Conditional Formatting.

Zones

Here you can control the settings of the column, row and data header zones. They are listed as follows:

  • Show/Hide Zones - shows a checkbox which corresponds to the visibility of each of the three header zones - column, row and data.

  • Zones Empty Message - allows you to provide a text for each zone which will be displayed in it if no fields are included in it.

  • ContextMenu - shows a checkbox allowing you to enable or disable the zone context menu.

    Zones

You can see how zones and the zone context menu are used in the First Lookdemo of RadPivotGrid.

Client Settings

From here you can enable and disable all client features of the control, attach client events and control the text of client messages. This section shows a property grid for all ClientSettings in RadPivotGrid and for each sub class of settings - the ClientEvents, Scrolling settings, etc. Client Settings