Pivot Designer is a tool for defining all elements needed for an effective data analysis. Designer can manipulate with fields from the data source defined in DataSourceName property of the control.

To open Pivot Designer

1. Open the MxPart component containing the Pivot control.
2. Right click the control on the canvas and select Run Designer.
3. To see all available fields click the Browse button in section Series.

Series

This section contains all the series defined for this pivot control. User can switch between series in runtime using menu in context navigation. The series defined first, top most, is the default series for the control in runtime.

Section contains three commands for managing series.

Command	Description
Add	Adds new series to the end of the list in section Series. To rename the series select it and hold the mouse over the series.
Remove	Removes the selected series from the list in section Series.
Browse	Displays all available fields in the list in section Pivot Browser. If any series are already defined the definitions are also retrieved and displayed in Pivot Fields section.

Preview

Once series are created and all necessary fields are described, the developer can see the preview of the pivot control. This is done by clicking the button Preview on the top right side of the Preview section. The layout of the fields is displayed below.

Pivot Fields

This section contains fields which are all organized based on the purpose of a field in the control. Each field type can contain any number of fields.

Field Type	Description
Filter Fields	Fields in this section are used for filtering data in the control.
Column Fields	Fields in this section are displayed as columns in the control and serves as a vertical definition of groups.
Row Fields	Fields in this section are displayed as rows in the control and serves as a horizontal definition of groups.
Data Fields	Fields in this section provide data for the analysis.
Hidden Fields	Fields in this section are hidden and are not a part of the data analysis. These fields can however be included in the data presentation in runtime.

Each of the field in Pivot Fields section has several properties that define its appearance, behaviour and the format in which the data is displayed.

Appearance Properties

Property	Description
AreaIndex	Defines the index of a field in a particular area.
Caption	Defines the text representing a field.
GroupInterval	Defines the interval for which the data is displayed in a group.
IntervalSize	Defines the size of the interval.
SummaryDisplayType	Defines how a summary value calculated against the current data field is represented in a cell.
SummaryType	Defines the summary operation by which the current custom total is calculated.

Behaviour Properties

Property	Description
AllowedAreas	Defines the areas where field can be located in the control.
AllowSummaryChange	Reserved for future use.

Format Properties

Property	Description
FormatString	Defines the format in which value is presented in a field.
FormatType	Defines the type of the format in which the value is presented in a field.

See Also