Search results

PivotViewModel

Interface for a class PivotView

Properties

beforeExport

EmitType<BeforeExportEventArgs>

This allows to set properties for exporting.

cellClick

EmitType<CellClickEventArgs>

Triggers when cell is clicked in the Pivot widget.

cellSelected

EmitType<PivotCellSelectedEventArgs>

Triggers when cell got selected in Pivot widget.

created

EmitType<Object>

Triggers when data source is created in the Pivot View.

dataBound

EmitType<Object>

Triggers when data source is populated in the Pivot View.

destroyed

EmitType<Object>

Triggers when data source is destroyed in the Pivot View.

drillThrough

EmitType<DrillThroughEventArgs>

Triggers when value cell is clicked in the Pivot widget on Drill-Through.

enginePopulated

EmitType<EnginePopulatedEventArgs>

Triggers after the pivot engine populated and allows to customize the pivot widget.

enginePopulating

EmitType<EnginePopulatingEventArgs>

Triggers before the pivot engine starts to populate and allows to customize the pivot datasource settings.

hyperlinkCellClick

EmitType<HyperCellClickEventArgs>

Triggers when hyperlink cell is clicked in the Pivot widget.

load

EmitType<LoadEventArgs>

queryCellInfo?: EmitType; /** headerCellInfo?: EmitType;

/** resizing?: EmitType;

/** resizeStop?: EmitType;

/** pdfHeaderQueryCellInfo?: EmitType;

/** pdfQueryCellInfo?: EmitType;

/** excelHeaderQueryCellInfo?: EmitType;

/** excelQueryCellInfo?: EmitType;

/** columnDragStart?: EmitType;

/** columnDrag?: EmitType;

/** columnDrop?: EmitType;

/** beforeColumnsRender?: EmitType;

/** selected?: EmitType;

/** cellDeselected?: EmitType;

/** rowSelected?: EmitType;

/** rowDeselected?: EmitType;

/** This allows any customization of PivotView properties on initial rendering.

onFieldDropped

EmitType<FieldDroppedEventArgs>

Triggers when a field getting dropped into any axis.

allowCalculatedField

boolean

It allows to enable calculated field in PivotView.

allowConditionalFormatting

boolean

It allows to enable Conditional Formatting in PivotView.

allowDeferLayoutUpdate

boolean

If allowDeferLayoutUpdate is set to true, then it will enable defer layout update to pivotview.

allowDrillThrough

boolean

If allowDrillThrough set to true, then you can view the raw items that are used to create a specified value cell in the pivot grid.

allowExcelExport

boolean

If allowExcelExport is set to true, then it will allow the user to export pivotview to Excel file.

allowPdfExport

boolean

If allowPdfExport is set to true, then it will allow the user to export pivotview to Pdf file.

dataSource

DataSourceModel

It allows the user to configure the pivot report as per the user need.

editSettings

CellEditSettingsModel

Configures the edit behavior of the Pivot Grid.

enablePersistence

boolean

Enable or disable persisting component’s state between page reloads.

enableRtl

boolean

Enable or disable rendering component in right to left direction.

enableValueSorting

boolean

It allows to enable Value Sorting in PivotView.

enableVirtualization

boolean

If enableVirtualization set to true, then the Grid will render only the rows and the columns visible within the view-port and load subsequent rows and columns on vertical scrolling. This helps to load large dataset in Pivot Grid.

gridSettings

GridSettingsModel

Configures the features settings of Pivot widget.

groupingBarSettings

GroupingBarSettingsModel

Configures the settings of GroupingBar.

height

string | number

Pivot widget. (Note change all occurrences)

hyperlinkSettings

HyperlinkSettingsModel

Configures the settings of hyperlink settings.

locale

string

Overrides the global culture and localization value for this component. Default global culture is ‘en-US’.

maxNodeLimitInMemberEditor

number

It allows to set the maximum number of nodes to be displayed in the member editor.

pivotValues

IPivotValues

It holds the pivot engine data which renders the Pivot widget.

showFieldList

boolean

It allows to render pivotfieldlist.

showGroupingBar

boolean

Enables the display of GroupingBar allowing you to filter, sort, and remove fields obtained from the datasource.

showTooltip

boolean

Allows to display the Tool-Tip on hovering value cells in pivot grid.

showValuesButton

boolean

It shows a common button for value fields to move together in column or row axis

width

string | number

It allows to set the width of Pivot widget.