PivotGridV2Builder
Properties
WriteAction - Func
Methods
DataSource(System.Action)
Sets the DataSource configuration of the grid.
Parameters
configurator - System.Action<PivotDataSourceV2Builder>
The lambda that configures the DataSource settings.
Example
@(Html.Kendo().PivotGridV2()
.Name("pivotgrid")
.DataSource(dataSource => dataSource.Xmla()
.Columns(columns => {
columns.Add("[Product].[Category]");
})
.Rows(rows => rows.Add("[Geography].[City]"))
.Measures(measures => measures.Values(new string[]{"[Measures].[Reseller Freight Cost]"}))
.Transport(transport => transport
.Connection(connection => connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read("https://demos.telerik.com/olap/msmdpump.dll")
)
)
)
DataSource(System.String)
Sets an existing DataSource as a DataSource of the PivotGridV2.
Parameters
dataSourceId - System.String
The name of the existing DataSource.
Example
@(Html.Kendo().PivotGridV2()
.Name("pivotgrid")
.DataSource("externalDS")
)
Configurator(System.String)
Defines the PivotConfiguratorV2.
Parameters
configurator - System.String
The Name() option of the PivotConfiguratorV2.
Example
@(Html.Kendo().PivotConfiguratorV2()
.Name("configurator")
.Sortable()
.Filterable()
.Height(570)
)
@(Html.Kendo().PivotGridV2()
.Name("pivotgrid")
.Configurator("#configurator")
)
BindTo(System.Collections.Generic.IEnumerable)
Binds the PivotGridV2 to a collection of objects (local data).
Parameters
dataSource - System.Collections.Generic.IEnumerable<T>
The IEnumerable collection that contains the data.
Example
@model IEnumerable<ProductViewModel>
@(Html.Kendo().PivotGridV2<ProductViewModel>()
.Name("pivotgrid")
.BindTo(Model)
)
AutoBind(System.Boolean)
If set to false the widget will not bind to the data source during initialization. In this case data binding will occur when the change event of the data source is fired. By default the widget will bind to the data source specified in the configuration.
Parameters
value - System.Boolean
The value for AutoBind
Navigatable(System.Boolean)
If set to true the user could navigate the component using the keyboard navigation. By default keyboard navigation is disabled.
Parameters
value - System.Boolean
The value for Navigatable
Navigatable()
If set to true the user could navigate the component using the keyboard navigation. By default keyboard navigation is disabled.
Excel(System.Action)
Configures the Kendo UI PivotGridV2 Excel export settings.
Parameters
configurator - System.Action<PivotGridV2ExcelSettingsBuilder>
The configurator for the excel setting.
Pdf(System.Action)
Configures the Kendo UI PivotGridV2 PDF export settings.
Parameters
configurator - System.Action<PivotGridV2PdfSettingsBuilder>
The configurator for the pdf setting.
ColumnWidth(System.Double)
The width of the table columns. Value is treated as pixels.
Parameters
value - System.Double
The value for ColumnWidth
Height(System.Double)
The height of the PivotGridV2. Numeric values are treated as pixels.
Parameters
value - System.Double
The value for Height
ColumnHeaderTemplate(System.String)
The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.
Parameters
value - System.String
The value for ColumnHeaderTemplate
ColumnHeaderTemplateId(System.String)
The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.
Parameters
templateId - System.String
The ID of the template element for ColumnHeaderTemplate
ColumnHeaderTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for ColumnHeaderTemplate
ColumnHeaderTemplateHandler(System.String)
The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.
Parameters
templateHandler - System.String
The handler that returs the template for ColumnHeaderTemplate
ColumnHeaderTemplate(Kendo.Mvc.UI.TemplateBuilder)
The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the columnheadertemplate.
DataCellTemplate(System.String)
The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.
Parameters
value - System.String
The value for DataCellTemplate
DataCellTemplateId(System.String)
The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.
Parameters
templateId - System.String
The ID of the template element for DataCellTemplate
DataCellTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for DataCellTemplate
DataCellTemplateHandler(System.String)
The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.
Parameters
templateHandler - System.String
The handler that returs the template for DataCellTemplate
DataCellTemplate(Kendo.Mvc.UI.TemplateBuilder)
The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the datacelltemplate.
KpiStatusTemplate(System.String)
The template which renders the content of the KPI Status value. By default renders "open", "hold" and "denied" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
value - System.String
The value for KpiStatusTemplate
KpiStatusTemplateId(System.String)
The template which renders the content of the KPI Status value. By default renders "open", "hold" and "denied" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
templateId - System.String
The ID of the template element for KpiStatusTemplate
KpiStatusTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
The template which renders the content of the KPI Status value. By default renders "open", "hold" and "denied" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for KpiStatusTemplate
KpiStatusTemplateHandler(System.String)
The template which renders the content of the KPI Status value. By default renders "open", "hold" and "denied" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
templateHandler - System.String
The handler that returs the template for KpiStatusTemplate
KpiStatusTemplate(Kendo.Mvc.UI.TemplateBuilder)
The template which renders the content of the KPI Status value. By default renders "open", "hold" and "denied" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the kpistatustemplate.
KpiTrendTemplate(System.String)
The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
value - System.String
The value for KpiTrendTemplate
KpiTrendTemplateId(System.String)
The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
templateId - System.String
The ID of the template element for KpiTrendTemplate
KpiTrendTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for KpiTrendTemplate
KpiTrendTemplateHandler(System.String)
The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
templateHandler - System.String
The handler that returs the template for KpiTrendTemplate
KpiTrendTemplate(Kendo.Mvc.UI.TemplateBuilder)
The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the kpitrendtemplate.
RowHeaderTemplate(System.String)
The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.
Parameters
value - System.String
The value for RowHeaderTemplate
RowHeaderTemplateId(System.String)
The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.
Parameters
templateId - System.String
The ID of the template element for RowHeaderTemplate
RowHeaderTemplateView(Microsoft.AspNetCore.Html.IHtmlContent)
The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.
Parameters
templateView - Microsoft.AspNetCore.Html.IHtmlContent
The view that contains the template for RowHeaderTemplate
RowHeaderTemplateHandler(System.String)
The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.
Parameters
templateHandler - System.String
The handler that returs the template for RowHeaderTemplate
RowHeaderTemplate(Kendo.Mvc.UI.TemplateBuilder)
The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.
Parameters
template - TemplateBuilder<TModel>
A Template component that configures the rowheadertemplate.
Events(System.Action)
Configures the client-side events.
Parameters
configurator - System.Action<PivotGridV2EventBuilder>
The client events action.
Example
@(Html.Kendo().PivotGridV2()
.Name("PivotGridV2")
.Events(events => events
.DataBinding("onDataBinding")
)
)
ToComponent()
Returns the internal view component.
Expression(System.String)
Sets the name of the component.
Parameters
modelExpression - System.String
Explorer(Microsoft.AspNetCore.Mvc.ViewFeatures.ModelExplorer)
Sets the name of the component.
Parameters
modelExplorer - Microsoft.AspNetCore.Mvc.ViewFeatures.ModelExplorer
Name(System.String)
Sets the name of the component.
Parameters
componentName - System.String
The name.
Deferred(System.Boolean)
Suppress initialization script rendering. Note that this options should be used in conjunction with
Parameters
deferred - System.Boolean
HtmlAttributes(System.Object)
Sets the HTML attributes.
Parameters
attributes - System.Object
The HTML attributes.
HtmlAttributes(System.Collections.Generic.IDictionary)
Sets the HTML attributes.
Parameters
attributes - System.Collections.Generic.IDictionary<String,Object>
The HTML attributes.
ScriptAttributes(System.Object,System.Boolean)
Sets the JavaScript attributes to the initialization script.
Parameters
attributes - System.Object
The JavaScript attributes.
overrideAttributes - System.Boolean
Argument which determines whether attributes should be overriden.
ScriptAttributes(System.Collections.Generic.IDictionary,System.Boolean)
Sets the JavaScript attributes to the initialization script.
Parameters
attributes - System.Collections.Generic.IDictionary<String,Object>
The JavaScript attributes.
overrideAttributes - System.Boolean
Argument which determines whether attributes should be overriden.
Render()
Renders the component in place.
ToHtmlString()
WriteTo(System.IO.TextWriter,System.Text.Encodings.Web.HtmlEncoder)
Parameters
writer - System.IO.TextWriter
encoder - System.Text.Encodings.Web.HtmlEncoder
ToClientTemplate()
AsModule(System.Boolean)
Specifies whether the initialization script of the component will be rendered as a JavaScript module.