Class ColumnFieldListDataSourceBuilder

Inheritance

System.Object

Syncfusion.EJ2.ControlBuilder

ColumnFieldListDataSourceBuilder

Namespace: Syncfusion.EJ2.PivotView

Assembly: Syncfusion.EJ2.dll

Syntax

public class ColumnFieldListDataSourceBuilder : ControlBuilder

Constructors

ColumnFieldListDataSourceBuilder()

Declaration

public ColumnFieldListDataSourceBuilder()

ColumnFieldListDataSourceBuilder(List<ColumnFieldListDataSource>)

Declaration

public ColumnFieldListDataSourceBuilder(List<ColumnFieldListDataSource> collection)

Parameters

Type	Name	Description
System.Collections.Generic.List<ColumnFieldListDataSource>	collection

Methods

Add()

Declaration

public void Add()

AllowDragAndDrop(Boolean)

Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

Declaration

public ColumnFieldListDataSourceBuilder AllowDragAndDrop(bool allowDragAndDrop)

Parameters

Type	Name	Description
System.Boolean	allowDragAndDrop

Returns

Type
ColumnFieldListDataSourceBuilder

Axis(String)

Allows you to set the axis name to the specific field. This will help to display the field in specified axis such as row/column/value/filter axis of pivot table.

Declaration

public ColumnFieldListDataSourceBuilder Axis(string axis)

Parameters

Type	Name	Description
System.String	axis

Returns

Type
ColumnFieldListDataSourceBuilder

BaseField(String)

Allows you to set the selective field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types.

It is applicable only for relational data source.

Declaration

public ColumnFieldListDataSourceBuilder BaseField(string baseField)

Parameters

Type	Name	Description
System.String	baseField

Returns

Type
ColumnFieldListDataSourceBuilder

BaseItem(String)

Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types. The selective item should be set the from field specified in the baseField property.

It is applicable only for relational data source.

Declaration

public ColumnFieldListDataSourceBuilder BaseItem(string baseItem)

Parameters

Type	Name	Description
System.String	baseItem

Returns

Type
ColumnFieldListDataSourceBuilder

Caption(String)

Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI.

Declaration

public ColumnFieldListDataSourceBuilder Caption(string caption)

Parameters

Type	Name	Description
System.String	caption

Returns

Type
ColumnFieldListDataSourceBuilder

DataType(String)

Allows to specify the data type of specific field.

Declaration

public ColumnFieldListDataSourceBuilder DataType(string dataType)

Parameters

Type	Name	Description
System.String	dataType

Returns

Type
ColumnFieldListDataSourceBuilder

ExpandAll(Boolean)

Allows you to either expand or collapse all the headers that are displayed in the pivot table. By default, all the headers are collapsed in the pivot table.

It is applicable only for Relational data.

Declaration

public ColumnFieldListDataSourceBuilder ExpandAll(bool expandAll)

Parameters

Type	Name	Description
System.Boolean	expandAll

Returns

Type
ColumnFieldListDataSourceBuilder

GroupName(String)

Allows you to create group folder for fields in pivot field list. Allows user to set the group (i.e., folder) name for selected fields that used to be displayed in the field list tree.

It is applicable only for relational data source.

Declaration

public ColumnFieldListDataSourceBuilder GroupName(string groupName)

Parameters

Type	Name	Description
System.String	groupName

Returns

Type
ColumnFieldListDataSourceBuilder

IsCalculatedField(Boolean)

Allows to set whether the specified field is a calculated field or not. In general, a calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

This option is applicable only for OLAP data source.

Declaration

public ColumnFieldListDataSourceBuilder IsCalculatedField(bool isCalculatedField)

Parameters

Type	Name	Description
System.Boolean	isCalculatedField

Returns

Type
ColumnFieldListDataSourceBuilder

IsNamedSet(Boolean)

Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself.

It is applicable only for OLAP data source.

Declaration

public ColumnFieldListDataSourceBuilder IsNamedSet(bool isNamedSet)

Parameters

Type	Name	Description
System.Boolean	isNamedSet

Returns

Type
ColumnFieldListDataSourceBuilder

Name(String)

Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table.

Declaration

public ColumnFieldListDataSourceBuilder Name(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type
ColumnFieldListDataSourceBuilder

ShowEditIcon(Boolean)

Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table.

Declaration

public ColumnFieldListDataSourceBuilder ShowEditIcon(bool showEditIcon)

Parameters

Type	Name	Description
System.Boolean	showEditIcon

Returns

Type
ColumnFieldListDataSourceBuilder

ShowFilterIcon(Boolean)

Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table.

Declaration

public ColumnFieldListDataSourceBuilder ShowFilterIcon(bool showFilterIcon)

Parameters

Type	Name	Description
System.Boolean	showFilterIcon

Returns

Type
ColumnFieldListDataSourceBuilder

ShowNoDataItems(Boolean)

Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source.

It is applicable only for relational data source.

Declaration

public ColumnFieldListDataSourceBuilder ShowNoDataItems(bool showNoDataItems)

Parameters

Type	Name	Description
System.Boolean	showNoDataItems

Returns

Type
ColumnFieldListDataSourceBuilder

ShowRemoveIcon(Boolean)

Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime.

Declaration

public ColumnFieldListDataSourceBuilder ShowRemoveIcon(bool showRemoveIcon)

Parameters

Type	Name	Description
System.Boolean	showRemoveIcon

Returns

Type
ColumnFieldListDataSourceBuilder

ShowSortIcon(Boolean)

Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime.

Declaration

public ColumnFieldListDataSourceBuilder ShowSortIcon(bool showSortIcon)

Parameters

Type	Name	Description
System.Boolean	showSortIcon

Returns

Type
ColumnFieldListDataSourceBuilder

ShowSubTotals(Boolean)

Allows to show or hide sub-totals to a specific field in row/column axis of the pivot table.

Declaration

public ColumnFieldListDataSourceBuilder ShowSubTotals(bool showSubTotals)

Parameters

Type	Name	Description
System.Boolean	showSubTotals

Returns

Type
ColumnFieldListDataSourceBuilder

ShowValueTypeIcon(Boolean)

Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This value type icon helps to select the appropriate aggregation type to specified value field at runtime.

Declaration

public ColumnFieldListDataSourceBuilder ShowValueTypeIcon(bool showValueTypeIcon)

Parameters

Type	Name	Description
System.Boolean	showValueTypeIcon

Returns

Type
ColumnFieldListDataSourceBuilder

Type(SummaryTypes)

Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are, Sum: Allows to display the pivot table values with sum. Product: Allows to display the pivot table values with product. Count: Allows to display the pivot table values with count. DistinctCount: Allows to display the pivot table values with distinct count. Min: Allows to display the pivot table with minimum value. Max: Allows to display the pivot table with maximum value. Avg: Allows to display the pivot table values with average. Median: Allows to display the pivot table values with median. Index: Allows to display the pivot table values with index. PopulationStDev: Allows to display the pivot table values with population standard deviation. SampleStDev: Allows to display the pivot table values with sample standard deviation. PopulationVar: Allows to display the pivot table values with population variance. SampleVar: Allows to display the pivot table values with sample variance. RunningTotals: Allows to display the pivot table values with running totals. DifferenceFrom: Allows to display the pivot table values with difference from the value of the base item in the base field. PercentageOfDifferenceFrom: Allows to display the pivot table values with percentage difference from the value of the base item in the base field. PercentageOfGrandTotal: Allows to display the pivot table values with percentage of grand total of all values. PercentageOfColumnTotal: Allows to display the pivot table values in each column with percentage of total values for the column. PercentageOfRowTotal: Allows to display the pivot table values in each row with percentage of total values for the row. PercentageOfParentTotal: Allows to display the pivot table values with percentage of total of all values based on selected field. PercentageOfParentColumnTotal: Allows to display the pivot table values with percentage of its parent total in each column. PercentageOfParentRowTotal: Allows to display the pivot table values with percentage of its parent total in each row. CalculatedField: Allows to display the pivot table with calculated field values. It allows user to create a new calculated field alone.

Declaration

public ColumnFieldListDataSourceBuilder Type(SummaryTypes type)

Parameters

Type	Name	Description
SummaryTypes	type

Returns

Type
ColumnFieldListDataSourceBuilder