Search results

PivotViewModel

Interface for a class PivotView

Properties

beforeExport

EmitType<BeforeExportEventArgs>

This allows to set properties for exporting.

beginDrillThrough

EmitType<BeginDrillThroughEventArgs>

Triggers when value cell is clicked in the Pivot widget on Editing.

cellClick

EmitType<CellClickEventArgs>

Triggers when cell is clicked in the Pivot widget.

cellSelected

EmitType<PivotCellSelectedEventArgs>

Triggers when cell got selected in Pivot widget.

chartSeriesCreated

EmitType<ChartSeriesCreatedEventArgs>

Triggers when chart series are created.

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.

fetchReport

EmitType<FetchReportArgs>

This allows to fetch the report names from storage.

hyperlinkCellClick

EmitType<HyperCellClickEventArgs>

Triggers when hyperlink cell is clicked in the Pivot widget.

load

EmitType<LoadEventArgs>

This allows any customization of PivotView properties on initial rendering.

loadReport

EmitType<LoadReportArgs>

This allows to load the report from storage.

newReport

EmitType<NewReportArgs>

This allows to set the new report.

onFieldDropped

EmitType<FieldDroppedEventArgs>

Triggers when a field getting dropped into any axis.

onPdfCellRender

EmitType<PdfCellRenderArgs>

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;

/** chartTooltipRender?: EmitType;

/** chartLoaded?: EmitType;

/** chartLoad?: EmitType;

/** chartResized?: EmitType;

/** chartAxisLabelRender?: EmitType;

/** This allows any customization of Pivot cell style while PDF exporting.

removeReport

EmitType<RemoveReportArgs>

This allows to remove the report from storage.

renameReport

EmitType<RenameReportArgs>

This allows to rename the report.

saveReport

EmitType<SaveReportArgs>

This allows to save the report in any storage.

toolbarClick

EmitType<ClickEventArgs>

This allows to change the toolbar items.

toolbarRender

EmitType<ToolbarArgs>

This allows to change the toolbar items.

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.

cellTemplate

string

The template option which is used to render the pivot cells on the pivotview. Here, the template accepts either the string or HTMLElement as template design and then the parsed design is displayed onto the pivot cells.

chartSettings

ChartSettingsModel

Configures the features settings of Pivot widget.

dataSource

DataSourceModel

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

displayOption

DisplayOptionModel

Configures the settings of displayOption.

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.

showToolbar

boolean

It allows to enable/disable toolbar in pivot table.

showTooltip

boolean

Allows to display the Tooltip 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

toolbar

string[]

It allows to set toolbar items in pivot table.

width

string | number

It allows to set the width of Pivot widget.