PivotGridStringId Enum
Lists values corresponding to strings that can be localized.
Namespace: DevExpress.XtraPivotGrid.Localization
Assembly: DevExpress.PivotGrid.v24.2.Core.dll
Declaration
Members
Name | Description |
---|---|
RowHeadersCustomization
|
The text displayed within the Row Header Area when it contains no field headers. Default value: Drop Row Fields Here |
ColumnHeadersCustomization
|
The text displayed within the Column Area when it contains no field headers. Default value: Drop Column Fields Here |
FilterHeadersCustomization
|
The text displayed within the Filter Header Area when it contains no field headers. Default value: Drop Filter Fields Here |
DataHeadersCustomization
|
The text displayed within the Data Header Area when it contains no field headers. Default value: Drop Data Items Here |
RowArea
|
The text that represents the row area (displayed within the Customization Form). Default value: Row Area |
ColumnArea
|
The text that represents the column area (displayed within the Customization Form). Default value: Column Area |
FilterArea
|
The text that represents the filter area (displayed within the Customization Form). Default value: Filter Area |
DataArea
|
The text that represents the data area (displayed within the Customization Form). Default value: Data Area |
FilterShowAll
|
The caption of the filter dropdown list item used to show all field values. Default value: (Show All) |
FilterOk
|
The caption of the OK button displayed within the filter dropdown. Default value: OK |
FilterCancel
|
The caption of the Cancel button displayed within the filter dropdown. Default value: Cancel |
FilterBlank
|
The caption of the blank item in the group filter drop-down. Default value: (Blank) |
FilterShowBlanks
|
The caption of the filter dropdown list item used to show blank values. Default value: (Show Blanks) |
FilterInvert
|
The caption of the filter dropdown’s popup menu item used to invert the selection. Default value: Invert Filter |
CustomizationFormCaption
|
The caption of the Customization Form. Default value: PivotGrid Field List |
CustomizationFormText
|
The text displayed above the Customization Form’s field list. Default value: Drag fields here to hide |
CustomizationFormEmptyFilterText
|
The text displayed in the Customization Form’s field list when the string typed in the search box does not match any field name. Default value: No match for the search string |
CustomizationFormAddTo
|
The caption of the ‘Add To’ button displayed within the Customization Form. Default value: Add To |
CustomizationFormHint
|
The text displayed above the areas section in the Customization Form. Default value: Drag fields between areas below: |
CustomizationFormDeferLayoutUpdate
|
The caption of the check box in the Customization Form that allows you to perform delayed layout updates. Default value: Defer Layout Update |
CustomizationFormUpdate
|
The caption of the Customization Form’s update button. Default value: Update |
CustomizationFormListBoxText
|
The text displayed within the Customization Form’s field list when it is empty. Default value: Drag a field here to customize layout |
CustomizationFormHiddenFields
|
The text displayed within the Customization Form above the hidden fields list. Default value: Hidden Fields |
CustomizationFormAvailableFields
|
The text displayed above the Hidden Fields section in the Excel-style Customization Form when visible fields are included in it. Default value: Choose fields to add to the report: |
Total
|
The text displayed after the field name within the grand total column/row header, if a specific caption for grand total headers has not been specified. Default value: Total |
GrandTotal
|
The caption of grand total columns and rows. Default value: Grand Total |
TotalFormat
|
A pattern used to format headers of automatic total summary columns/rows. Default value: {0} Total Where {0} - the field value |
TotalFormatCount
|
A pattern used to format headers of count total summary columns/rows. Default value: {0} Count Where {0} - the field value |
TotalFormatSum
|
A pattern used to format headers of sum total summary columns/rows. Default value: {0} Sum Where {0} - the field value |
TotalFormatMin
|
A pattern used to format headers of minimum total summary columns/rows. Default value: {0} Min Where {0} - the field value |
TotalFormatMax
|
A pattern used to format headers of maximum total summary columns/rows. Default value: {0} Max Where {0} - the field value |
TotalFormatAverage
|
A pattern used to format headers of average total summary columns/rows. Default value: {0} Average Where {0} - the field value |
TotalFormatStdDev
|
A pattern used to format headers of standard deviation of a population subset total summary columns/rows. Default value: {0} StdDev Where {0} - the field value |
TotalFormatStdDevp
|
A pattern used to format headers of standard deviation of the whole population total summary columns/rows. Default value: {0} StdDevp Where {0} - the field value |
TotalFormatVar
|
A pattern used to format headers of variance of a population subset total summary columns/rows. Default value: {0} Var Where {0} - the field value |
TotalFormatVarp
|
A pattern used to format headers of variance of the whole population total summary columns/rows. Default value: {0} Varp Where {0} - the field value |
TotalFormatCustom
|
A pattern used to format headers of data fields with manually calculated summary values. Default value: {0} Custom Where {0} - the field value |
TotalFormatCountDistinct
|
A pattern used to format headers of count distinct total summary columns/rows. Default value: {0} Count Distinct Where {0} - the field value |
TotalFormatMedian
|
A pattern used to format headers of median total summary columns/rows. Default value: {0} Median Where {0} - the field value |
TotalFormatMode
|
A pattern used to format headers of mode total summary columns/rows. Default value: {0} Mode Where {0} - the field value |
PrintDesigner
|
The caption of the Print Designer dialog. Default value: Print Designer |
PrintDesignerPageOptions
|
The caption of the Print Designer dialog page that contains general printing options. Default value: Options |
PrintDesignerPageBehavior
|
The caption of the Print Designer dialog page that contains options used to specify the printing behavior. Default value: Behavior |
PrintDesignerCategoryDefault
|
The caption of the default options category in the Print Designer dialog. Default value: Default |
PrintDesignerCategoryLines
|
The caption of the Print Designer options category which contains options used to specify how cell borders are printed. Default value: Lines |
PrintDesignerCategoryHeaders
|
The caption of the Print Designer options category which contains options used to specify how field headers are printed. Default value: Headers |
PrintDesignerCategoryFieldValues
|
The caption of the Print Designer options category which contains options used to specify how field values are printed. Default value: Field Values |
PrintDesignerHorizontalLines
|
The caption of the Print Designer dialog option used to specify whether horizontal cell borders are printed. Default value: Horizontal Lines |
PrintDesignerVerticalLines
|
The caption of the Print Designer dialog option used to specify whether vertical cell borders are printed. Default value: Vertical Lines |
PrintDesignerFilterHeaders
|
The caption of the Print Designer dialog option used to specify whether headers of filter fields are printed. Default value: Filter Headers |
PrintDesignerDataHeaders
|
The caption of the Print Designer dialog option used to specify whether headers of data fields are printed. Default value: Data Headers |
PrintDesignerColumnHeaders
|
The caption of the Print Designer dialog option used to specify whether headers of column fields are printed. Default value: Column Headers |
PrintDesignerRowHeaders
|
The caption of the Print Designer dialog option used to specify whether headers of row fields are printed. Default value: Row Headers |
PrintDesignerHeadersOnEveryPage
|
The caption of the Print Designer dialog option used to specify whether headers are printed on every page. Default value: Headers On Every Page |
PrintDesignerColumnAreaOnEveryPage
|
Default value: Column Area On Every Page |
PrintDesignerRowAreaOnEveryPage
|
Default value: Row Area On Every Page |
PrintDesignerUnusedFilterFields
|
The caption of the Print Designer dialog option used to specify whether unused filter fields are printed. Default value: Unused Filter Fields |
PrintDesignerMergeColumnFieldValues
|
The caption of the Print Designer dialog option used to specify whether cells that display the same column field value are merged. Default value: Merge Column Field Values |
PrintDesignerMergeRowFieldValues
|
The caption of the Print Designer dialog option used to specify whether cells that display the same row field value are merged. Default value: Merge Row Field Values |
PrintDesignerUsePrintAppearance
|
The caption of the Print Designer dialog option used to specify whether print appearances are used when the pivot grid is printed. Default value: Use Print Appearance |
PopupMenuRefreshData
|
The caption of the context menu item used to refresh the pivot grid’s data. Default value: Reload Data |
PopupMenuSortAscending
|
The caption of the field header’s context menu item used to sort the field values in ascending order. Default value: Sort A-Z |
PopupMenuSortDescending
|
The caption of the field header’s context menu item used to sort the field values in descending order. Default value: Sort Z-A |
PopupMenuClearSorting
|
The caption of the field header’s context menu item used to clear the currently applied sorting. Default value: Clear Sorting |
PopupMenuShowExpression
|
The caption of the field value’s context menu item used to invoke the Expression Editor. Default value: Expression Editor… |
PopupMenuHideField
|
The caption of the field header’s context menu item used to hide the field. Default value: Hide |
PopupMenuBestFit
|
Default value: Best Fit |
PopupMenuSummaryType
|
Default value: Summary Type |
PopupMenuSortBySummary
|
Default value: Sort by Summary |
PopupMenuShowFieldList
|
The caption of the context menu item used to invoke the Customization Form. Default value: Show Field List |
PopupMenuHideFieldList
|
The caption of the context menu item used to hide the Customization Form. Default value: Hide Field List |
PopupMenuFieldOrder
|
The name of the field header’s context menu item which contains subitems used to reorder fields. Default value: Order |
PopupMenuMovetoBeginning
|
The caption of the field header’s context menu item used to move the field to the first position in its area. Default value: Move to Beginning |
PopupMenuMovetoLeft
|
The caption of the field header’s context menu item used to move the field left. Default value: Move to Left |
PopupMenuMovetoRight
|
The caption of the field header’s context menu item used to move the field right. Default value: Move to Right |
PopupMenuMovetoEnd
|
The caption of the field header’s context menu item used to move the field to the last position in its area. Default value: Move to End |
PopupMenuCollapse
|
The name of the field value’s context menu item used to collapse the field value. Default value: Collapse |
PopupMenuExpand
|
The name of the field value’s context menu item used to expand the field value. Default value: Expand |
PopupMenuCollapseAll
|
The name of the field value’s context menu item used to collapse all values of the field. Default value: Collapse All |
PopupMenuExpandAll
|
The name of the field value’s context menu item used to expand all values of the field. Default value: Expand All |
PopupMenuShowFilter
|
Default value: Show Filter |
PopupMenuHideFilter
|
Default value: Hide Filter |
PopupMenuSortFieldByColumn
|
The caption of the column field value’s context menu item used to sort the other field values by this column. Default value: Sort “{0}” by This Column |
PopupMenuSortFieldByRow
|
The caption of the row field value’s context menu item used to sort the other field values by this row. Default value: Sort “{0}” by This Row |
PopupMenuRemoveAllSortByColumn
|
The name of the field value’s context menu item used to remove sorting by column. Default value: Remove All Sorting |
PopupMenuFixRowTop
|
The name of the field header’s context menu item that pins the row to the top. Default value: Pin This Row to the Bottom |
PopupMenuFixRowBottom
|
The name of the field header’s context menu item that pins the row to the bottom. Default value: Pin This Row to the Bottom |
PopupMenuFixColumnLeft
|
The name of the field header’s context menu item that pins the column to the left. Default value: Pin This Column to the Left |
PopupMenuFixColumnRight
|
The name of the field header’s context menu item that pins the column to the right. Default value: Pin This Column to the Right |
PopupMenuUnfixRowTop
|
The name of the field header’s context menu item that unpins the row from the top. Default value: Unpin This Row from the Top |
PopupMenuUnfixRowBottom
|
The name of the field header’s context menu item that unpins the row from the bottom. Default value: Unpin This Row from the Bottom |
PopupMenuUnfixColumnLeft
|
The name of the field header’s context menu item that unpins the column from the left. Default value: Unpin This Column from the Left |
PopupMenuUnfixColumnRight
|
The name of the field header’s context menu item that unpins the column from the right. Default value: Unpin This Column from the Right |
DataFieldCaption
|
The text displayed within the data field header. Default value: Data |
TopValueOthersRow
|
The text displayed within the header of the ‘Others’ row. Default value: Others |
CellError
|
The text displayed within a cell when an error occurs (the cell’s value is PivotSummaryValue.ErrorValue). Default value: Error |
ValueError
|
The text displayed within a field value cell when an error occurs. Default value: Error |
PrefilterInvalidProperty
|
If you specify an invalid field name in a Prefilter expression, this string will be displayed in the Prefilter window instead of that field name. Default value: (invalid property) |
FilterInvalidCriteria
|
|
FilterFormCaption
|
Default value: Filter Editor |
EditFilter
|
Default value: Edit Filter |
OLAPMeasuresCaption
|
The caption of the ‘measures’ tree item displayed in the field section of the Customization Form in the OLAP mode. Default value: Measures |
OLAPKPIsCaption
|
The caption of the ‘KPIs’ tree item displayed in the field section of the Customization Form in the OLAP mode. Default value: KPIs |
OLAPKPITypeValue
|
The caption of the ‘Value’ tree item (the KPI actually achieved value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Value |
OLAPKPITypeGoal
|
The caption of the ‘Goal’ tree item (the KPI goal value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Goal |
OLAPKPITypeStatus
|
The caption of the ‘Status’ tree item (the KPI status value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Status |
OLAPKPITypeTrend
|
The caption of the ‘Trend’ tree item (the KPI trend value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Trend |
OLAPKPITypeWeight
|
The caption of the ‘Weight’ tree item (the KPI weight value) displayed in the field section of the Customization Form in the OLAP mode. Default value: Weight |
OLAPDrillDownFilterException
|
The error message which is displayed when a drill-through is performed while multiple items are selected in the report filter field. Default value: Show Details command cannot be executed when multiple items are selected in a report filter field. Select a single item for each field in the report filter area before performing a drill-through. |
OLAPDrillDownTopNException
|
The error message which is displayed when a drill-through is performed while Top N is applied to one of the row/column fields. Default value: Show Details command cannot be executed when Top N is applied to one of the row/column fields. |
OLAPNoOleDbProvidersMessage
|
The message that appears if no OLE DB provider can be found on the system when binding the pivot grid to an OLAP data source. Default value: In order to use the PivotGrid OLAP functionality, you should have a MS OLAP OleDb provider installed on your system.\r\nYou can download it here: |
TrendGoingUp
|
The text of the tooltip displayed for KPI values representing an ascending trend. Default value: Going Up |
TrendGoingDown
|
The text of the tooltip displayed for KPI values representing a descending trend. Default value: Going Down |
TrendNoChange
|
The text of the tooltip displayed for KPI values representing a horizontal trend. Default value: No Change |
StatusBad
|
The text of the tooltip displayed for KPI values representing a bad progress state. Default value: Bad |
StatusNeutral
|
The text of the tooltip displayed for KPI values representing a neutral progress state. Default value: Neutral |
StatusGood
|
The text of the tooltip displayed for KPI values representing a good progress state. Default value: Good |
DateTimeQuarterFormat
|
Default value: Q{0} |
SummaryCount
|
The text displayed within the headers of count summary data fields. Default value: Count |
SummarySum
|
The text displayed within the headers of sum summary data fields. Default value: Sum |
SummaryMin
|
The text displayed within the headers of minimum summary data fields. Default value: Min |
SummaryMax
|
The text displayed within the headers of maximum summary data fields. Default value: Max |
SummaryAverage
|
The text displayed within the headers of average summary data fields. Default value: Average |
SummaryStdDev
|
The text displayed within the headers of standard deviation of a population subset summary data fields. Default value: StdDev |
SummaryStdDevp
|
The text displayed within the headers of standard deviation of the whole population summary data fields. Default value: StdDevp |
SummaryVar
|
The text displayed within the headers of variance of a population subset summary data fields. Default value: Var |
SummaryVarp
|
The text displayed within the headers of variance of the whole population summary data fields. Default value: Varp |
SummaryCustom
|
The text displayed within the headers of data fields with manually calculated summary values. Default value: Custom |
SummaryCountDistinct
|
The text displayed within the headers of count distinct summary data fields. Default value: Count Distinct |
SummaryMedian
|
The text displayed within the headers of median summary data fields. Default value: Median |
SummaryMode
|
The text displayed within the headers of mode summary data fields. Default value: Mode |
CustomizationFormStackedDefault
|
The text that represents the Customization Form’s ‘Fields Section and Areas Section Stacked’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Fields Section and Areas Section Stacked |
CustomizationFormStackedSideBySide
|
The text that represents the Customization Form’s ‘Fields Section and Areas Section Side-By-Side’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Fields Section and Areas Section Side-By-Side |
CustomizationFormTopPanelOnly
|
The text that represents the Customization Form’s ‘Fields Section Only’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Fields Section Only |
CustomizationFormBottomPanelOnly2by2
|
The text that represents the Customization Form’s ‘Areas Section Only (2 by 2)’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Areas Section Only (2 by 2) |
CustomizationFormBottomPanelOnly1by4
|
The text that represents the Customization Form’s ‘Area Section Only (1 by 4)’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button). Default value: Areas Section Only (1 by 4) |
CustomizationFormLayoutButtonTooltip
|
The text displayed within the Customization Form Layout button’s tooltip. Default value: Customization Form Layout |
Alt_Expand
|
The alternative text for the expand button. Default value: [Expand] |
Alt_Collapse
|
The alternative text for the collapse button. Default value: [Collapse] |
Alt_SortedAscending
|
The alternative text for the ascending sorting image. Default value: (Ascending) |
Alt_SortedDescending
|
The alternative text for the descending sorting image. Default value: (Descending) |
Alt_FilterWindowSizeGrip
|
The alternative text for the filter drop-down’s size grip. Default value: [Resize] |
Alt_FilterButton
|
The alternative text for the filter button used when the field values are not filtered. Default value: [Filter] |
Alt_FilterButtonActive
|
The alternative text for the filter button used when the field values are filtered. Default value: [Filtered] |
Alt_DragHideField
|
The alternative text for the image displayed when a field is about to be hidden via drag-and-drop. Default value: Hide |
Alt_FilterAreaHeaders
|
The alternative text for the image displayed near the caption of the Filter Area Headers section in the Customization Form. Default value: [Filter Area Headers] |
Alt_ColumnAreaHeaders
|
The alternative text for the image displayed near the caption of the Column Area Headers section in the Customization Form. Default value: [Column Area Headers] |
Alt_RowAreaHeaders
|
The alternative text for the image displayed near the caption of the Row Area Headers section in the Customization Form. Default value: [Row Area Headers] |
Alt_DataAreaHeaders
|
The alternative text for the image displayed near the caption of the Data Area Headers section in the Customization Form. Default value: [Data Area Headers] |
Alt_FieldListHeaders
|
The alternative text for the image displayed near the caption of the Hidden Headers section in the Customization Form. Default value: [Hidden Field’s Headers] |
Alt_LayoutButton
|
The alternative text for the image displayed on the Layout button in the Customization Form. Default value: [Layout Button] |
Alt_StackedDefaultLayout
|
The alternative text for the image corresponding to the ‘Fields Section and Areas Section Stacked’ layout, displayed in the Customization Form Layout menu. Default value: [Stacked Default Layout] |
Alt_StackedSideBySideLayout
|
The alternative text for the image corresponding to the ‘Fields Section and Areas Section Side-By-Side’ layout, displayed in the Customization Form Layout menu. Default value: [Stacked Side By Side Layout] |
Alt_TopPanelOnlyLayout
|
The alternative text for the image corresponding to the ‘Fields Section Only’ layout, displayed in the Customization Form Layout menu. Default value: [Top Panel Only Layout] |
Alt_BottomPanelOnly2by2Layout
|
The alternative text for the image corresponding to the ‘Areas Section Only (2 by 2)’ layout, displayed in the Customization Form Layout menu. Default value: [Bottom Panel Only 2 by 2 Layout] |
Alt_BottomPanelOnly1by4Layout
|
The alternative text for the image corresponding to the ‘Areas Section Only (1 by 4)’ layout, displayed in the Customization Form Layout menu. Default value: [Bottom Panel Only 1 by 4 Layout] |
SearchBoxText
|
The text displayed within the Search Box in the Group Filter popup when the box is empty. Default value: Search |
PopupMenuKPIGraphic
|
The caption of a data field header context menu item that opens a submenu used to choose KPI graphics. Default value: KPI Graphics |
PopupMenuKPIGraphicNone
|
The caption of the context menu item that is used to disable KPI graphics. Default value: None |
PopupMenuKPIGraphicServerDefined
|
The caption of the context menu item that identifies server-defined KPI graphics. Default value: Server Defined |
PopupMenuKPIGraphicShapes
|
The caption of the context menu item that identifies the Shapes KPI graphics. Default value: Shapes |
PopupMenuKPIGraphicTrafficLights
|
The caption of the context menu item that identifies the Traffic Lights KPI graphics. Default value: Traffic Lights |
PopupMenuKPIGraphicRoadSigns
|
The caption of the context menu item that identifies the Road Signs KPI graphics. Default value: Road Signs |
PopupMenuKPIGraphicGauge
|
The caption of the context menu item that identifies the Gauge KPI graphics. Default value: Gauge |
PopupMenuKPIGraphicReversedGauge
|
The caption of the context menu item that identifies the Reversed Gauge KPI graphics. Default value: Reversed Gauge |
PopupMenuKPIGraphicThermometer
|
The caption of the context menu item that identifies the Thermometer KPI graphics. Default value: Thermometer |
PopupMenuKPIGraphicReversedThermometer
|
The caption of the context menu item that identifies the Reversed Thermometer KPI graphics. Default value: Reversed Thermometer |
PopupMenuKPIGraphicCylinder
|
The caption of the context menu item that identifies the Cylinder KPI graphics. Default value: Cylinder |
PopupMenuKPIGraphicReversedCylinder
|
The caption of the context menu item that identifies the Reversed Cylinder KPI graphics. Default value: Reversed Cylinder |
PopupMenuKPIGraphicFaces
|
The caption of the context menu item that identifies the Faces KPI graphics. Default value: Faces |
PopupMenuKPIGraphicVarianceArrow
|
The caption of the context menu item that identifies the Variance Arrow KPI graphics. Default value: Variance Arrow |
PopupMenuKPIGraphicStandardArrow
|
The caption of the context menu item that identifies the Standard Arrow KPI graphics. Default value: Standard Arrow |
PopupMenuKPIGraphicStatusArrow
|
The caption of the context menu item that identifies the Status Arrow KPI graphics. Default value: Status Arrow |
PopupMenuKPIGraphicReversedStatusArrow
|
The caption of the context menu item that identifies the Reversed Status Arrow KPI graphics. Default value: Reversed Status Arrow |
SummaryFilterRangeFrom
|
The text displayed on top of the summary filter popup window before the text editor used to specify the minimum of the visible values range. Default value: Show values from |
SummaryFilterRangeTo
|
The text displayed on top of the summary filter popup window, before the text editor used to specify the maximum of the visible values range. Default value: to |
SummaryFilterLegendHidden
|
The description for a legend item that identifies hidden summary values. Shown in the legend of the summary distribution diagram displayed within summary filter popup windows. Default value: Hidden |
SummaryFilterLegendVisible
|
The description for a legend item that identifies visible summary values. Shown in the legend of the summary distribution diagram displayed within summary filter popup windows. Default value: Visible |
SummaryFilterApplyToSpecificLevel
|
The caption of a check box that enables end-users to select a detail level to which summary filtering should be applied. Default value: Apply to specific level |
SummaryFilterColumnField
|
The caption of a combo box used to select a column field that identifies a detail level to which summary filtering is applied. Default value: Column field: |
SummaryFilterRowField
|
The caption of a combo box used to select a row field that identifies a detail level to which summary filtering is applied. Default value: Row field: |
SummaryFilterMaxValueCount
|
The description displayed above a constant line that indicates the maximum number of summary values that fall into a single subrange. This constant line is shown in a summary distribution diagram displayed within summary filter popup windows. Default value: Max Count |
SummaryFilterMaxVisibleCount
|
The description displayed above a constant line that indicates the maximum number of visible summary values that fall into a single subrange. This constant line is shown in a summary distribution diagram displayed within summary filter popup windows. Default value: Max Visible Count |
SummaryFilterLabelValues
|
The horizontal axis label of the summary distribution diagram displayed in summary filter popup windows. Default value: Values |
SummaryFilterClearButton
|
The caption of a button that resets the summary filter. Default value: Clear |
DrillDownException
|
The error message which is displayed when a drilldown dataset cannot be retrieved. Default value: Error retrieving drilldown dataset. |
OptimizedEngineServerModeNotSupportedException
|
Default value: The Optimized data processing engine does not support Server Mode. Do not switch to the Optimized engine when working with data sources that operate in Server Mode. |
PopupMenuFormatRules
|
The caption of the context menu item used to invoke the Format Rules menu. Default value: Format Rules |
PopupMenuFormatRulesIntersectionOnly
|
The caption of the check box in the Format Rules context menu that allows you to specify whether the rule is applied only to field intersection. Default value: Apply only to specific level |
PopupMenuFormatRulesClearMeasureRules
|
The caption of the context menu item used to clear rules from specific measure. Default value: Clear Rules from This Measure |
PopupMenuFormatRulesClearIntersectionRules
|
The caption of the context menu item used to clear rules from specific intersection. Default value: Clear Rules from This Intersection |
PopupMenuFormatRulesClearAllRules
|
The caption of the context menu item used to clear rules from all measures. Default value: Clear Rules From All Measures |
PopupMenuFormatRulesMeasure
|
The caption of the Measure field header in the Conditional Formatting Rules Manager. Default value: Measure |
PopupMenuFormatRulesColumn
|
The caption of the Column field header in the Conditional Formatting Rules Manager. Default value: Column |
PopupMenuFormatRulesRow
|
The caption of the Row field header in the Conditional Formatting Rules Manager. Default value: Row |
PopupMenuFormatRulesAnyField
|
The caption of the any field item in the Conditional Formatting Rules Manager’s combo box. Default value: (Any) |
PopupMenuFormatRulesGrandTotal
|
The caption of the Grand Total item in the Conditional Formatting Rules Manager’s combo box. Default value: (Grand Total) |
ExpressionValidationCircularDependency
|
Default value: The following fields have circular dependency: {0} |
ExpressionValidationInvalidProperty
|
Default value: The {0} not found. |
ExpressionValidationNotSummaryExpressionExpected
|
Default value: Criteria cannot contain aggregates. |
ExpressionValidationSummaryExpressionExpected
|
Default value: A summary expression is expected. |
ExpressionValidationInvalidArgumentCount
|
Default value: The number of arguments for the {0} function is invalid. |
ExpressionValidationInvalidFunctionArgument
|
Default value: The ‘{0}’ function expects ‘{1}’ as the {2} argument. |
ExpressionValidationFunctionIsNotSupported
|
Default value: The {0} function is not supported in the current calculation mode. |
ExpressionValidationExpressionIsEmpty
|
Default value: An expression cannot be empty. |
ExpressionValidationInvalidWindowExpressionUsage
|
Default value: The {0} function can be used only in a window expression. |
ExpressionValidationInvalidExpression
|
Default value: The expression cannot be evaluated. |
ServerRequestError
|
Default value: Error occurred during processing server request ({0}) |
ExpressionEditorFieldDescription
|
Default value: Caption: {0}\r\nType: {1} |
ExpressionEditorFieldsCategory
|
Default value: Fields |
PopupMenuMore
|
A caption for the drop-down menu item that expands to display the additional DateTime group intervals. The menu is available if the PivotGridOptionsMenu.ShowDateTimeGroupIntervalItems property is set to DateTimeGroupIntervals.ExtendedIntervals. Default value: More |
DateTimeGroupIntervalQuarter
|
A caption that identifies the predefined group interval PivotGroupInterval.DateQuarter. Default value: Quarter |
DateTimeGroupIntervalMonth
|
A caption that identifies the predefined group interval PivotGroupInterval.DateMonth. Default value: Month |
DateTimeGroupIntervalDay
|
A caption that identifies the predefined group interval PivotGroupInterval.DateDay. Default value: Day |
DateTimeGroupIntervalHour
|
A caption that identifies the predefined group interval PivotGroupInterval.Hour. Default value: Hour |
DateTimeGroupIntervalMinute
|
A caption that identifies the predefined group interval PivotGroupInterval.Minute. Default value: Minute |
DateTimeGroupIntervalSecond
|
A caption that identifies the predefined group interval PivotGroupInterval.Second. Default value: Second |
DateTimeGroupIntervalDayOfYear
|
A caption that identifies the predefined group interval PivotGroupInterval.DateDayOfYear. Default value: Day of Year |
DateTimeGroupIntervalDayOfWeek
|
A caption that identifies the predefined group interval PivotGroupInterval.DateDayOfWeek. Default value: Day of Week |
DateTimeGroupIntervalWeekOfYear
|
A caption that identifies the predefined group interval PivotGroupInterval.DateWeekOfYear. Default value: Week of Year |
DateTimeGroupIntervalWeekOfMonth
|
A caption that identifies the predefined group interval PivotGroupInterval.DateWeekOfMonth. Default value: Week of Month |
DateTimeGroupIntervalMonthYear
|
A caption that identifies the predefined group interval PivotGroupInterval.DateMonthYear. Default value: Month - Year |
DateTimeGroupIntervalQuarterYear
|
A caption that identifies the predefined group interval PivotGroupInterval.DateQuarterYear. Default value: Quarter - Year |
DateTimeGroupIntervalDayMonthYear
|
A caption that identifies the predefined group interval PivotGroupInterval.DateMonthYear. Default value: Day-Month-Year |
DateTimeGroupIntervalDateHour
|
A caption that identifies the predefined group interval PivotGroupInterval.DateHour. Default value: Date-Hour |
DateTimeGroupIntervalDateHourMinute
|
A caption that identifies the predefined group interval PivotGroupInterval.DateHourMinute. Default value: Date-Hour-Minute |
DateTimeGroupIntervalDateHourMinuteSecond
|
A caption that identifies the predefined group interval PivotGroupInterval.DateHourMinuteSecond. Default value: Date-Hour-Minute-Second |
DateTimeGroupIntervalDateWeekYear
|
A caption that identifies the predefined PivotGroupInterval.DateHourMinuteSecond group interval. Default value: Week-Year |
DateTimeGroupIntervalExactDate
|
A caption that specifies a DateTime group interval other than the DateTime combinations defined in the PivotGroupInterval enumeration. Default value: Exact Date |
DateTimeGroupIntervalExactTime
|
|
DateTimeGroupIntervalYear
|
A caption that identifies the predefined group interval DevExpress.XtraPivotGrid.PivotGroupInterval.Year. Default value: Year |
SearchForField
|
The text displayed in the empty Customization Form’s search box. The search box is shown if the PivotGridOptionsCustomizationEx.CustomizationFormSearchBoxVisible property is true. Default value: Search for a field… |
FunctionDescriptionAggr
|
Default value: aggr(SummaryExpression, Dimension1, Dimension2, …) Aggregates underlying data using the detail level and the summary function. The level is specified by a predefined set of dimensions. |
FunctionDescriptionIsTotal
|
|
FunctionDescriptionWindowAvg
|
Default value: WindowAvg(SummaryExpression, StartOffset, EndOffset) Returns the average of the expression within the window, which is defined using offsets from the current row. |
FunctionDescriptionRankCompetition
|
Default value: RankCompetition(SummaryExpression, [‘asc’, ‘desc’]) Returns the standard competition rank for the current row in the window. |
FunctionDescriptionWindowCountDistinct
|
Default value: WindowCountDistinct(SummaryExpression, StartOffset, EndOffset) Returns the distinct count of the expression within the window. |
FunctionDescriptionWindowCount
|
Default value: WindowCount(SummaryExpression, StartOffset, EndOffset) Returns the count of the expression within the window. |
FunctionDescriptionRankDense
|
Default value: RankDense(SummaryExpression, [‘asc’, ‘desc’]) Returns the dense rank for the current row in the window. |
FunctionDescriptionFirst
|
Default value: First() Returns the number of rows from the current row to the first row in the window. |
FunctionDescriptionIndex
|
Default value: Index() Returns the index of the current row in the window. |
FunctionDescriptionLast
|
Default value: Last() Returns the number of rows from the current row to the last row in the window. |
FunctionDescriptionLookup
|
Default value: Lookup(SummaryExpression, Position) Returns the value of the expression in a target position specified as a relative offset from the current position. |
FunctionDescriptionWindowMax
|
Default value: WindowMax(SummaryExpression, StartOffset, EndOffset) Returns the maximum of the expression within the window. |
FunctionDescriptionWindowMedian
|
Default value: WindowMedian(SummaryExpression, StartOffset, EndOffset) Returns the median of the expression within the window. |
FunctionDescriptionWindowFirstValue
|
|
FunctionDescriptionWindowMode
|
Default value: WindowMode(SummaryExpression, StartOffset, EndOffset) Returns the mode of the expression within the window. |
FunctionDescriptionWindowMin
|
Default value: WindowMin(SummaryExpression, StartOffset, EndOffset) Returns the minimum of the expression within the window. |
FunctionDescriptionRankModified
|
Default value: RankModified(SummaryExpression, [‘asc’, ‘desc’]) Returns the modified competition rank for the current row in the window. |
FunctionDescriptionRankPercentile
|
Default value: RankPercentile(SummaryExpression, [‘asc’, ‘desc’]) Returns the percentile rank for the current row in the window. |
FunctionDescriptionRunningAvg
|
Default value: RunningAvg(SummaryExpression) Returns the running average of the specified expression from the first row in the window to the current row. |
FunctionDescriptionRunningCount
|
Default value: RunningCount(SummaryExpression) Returns the running count of the specified expression from the first row in the window to the current row. |
FunctionDescriptionRunningMax
|
Default value: RunningMax(SummaryExpression) Returns the running maximum of the specified expression from the first row in the window to the current row. |
FunctionDescriptionRunningMin
|
Default value: RunningMin(SummaryExpression) Returns the running minimum of the specified expression from the first row in the window to the current row. |
FunctionDescriptionRunningSum
|
Default value: RunningSum(SummaryExpression) Returns the running sum of the specified expression from the first row in the window to the current row. |
FunctionDescriptionSize
|
Default value: Size() Returns the number of rows in the window. |
FunctionDescriptionWindowStdDev
|
Default value: WindowStdDev(SummaryExpression, StartOffset, EndOffset) Returns the sample standard deviation of the expression within the window. |
FunctionDescriptionWindowStdDevp
|
Default value: WindowStdDevp(SummaryExpression, StartOffset, EndOffset) Returns the biased standard deviation of the expression within the window. |
FunctionDescriptionWindowSum
|
Default value: WindowSum(SummaryExpression, StartOffset, EndOffset) Returns the sum of the expression within the window. |
FunctionDescriptionTotal
|
Default value: Total(SummaryExpression) Returns the total for the specified expression in a table calculation window. |
FunctionDescriptionRankUnique
|
Default value: RankUnique(SummaryExpression, [‘asc’, ‘desc’]) Returns the unique rank for the current row in the window. |
FunctionDescriptionWindowVar
|
Default value: WindowVar(SummaryExpression, StartOffset, EndOffset) Returns the variance of the expression within the window. |
FunctionDescriptionWindowVarp
|
Default value: WindowVarp(SummaryExpression, StartOffset, EndOffset) Returns the biased variance of the expression within the window. |
FunctionCategoryWindow
|
Default value: Window |
FunctionCategoryCustomAggregateNames
|
|
FunctionCategoryAdvanced
|
A caption of the Advanced category in the Function section in the Filter editor. Default value: Advanced |
FunctionDescriptionGetDateHour
|
Default value: GetDateHour(DateTime) Extracts the date part with the hour value from the defined DateTime. |
FunctionDescriptionGetDateHourMinute
|
Default value: GetDateHourMinute(DateTime) Extracts the date part with the hour and minute values from the defined DateTime. |
FunctionDescriptionGetDateHourMinuteSecond
|
Default value: GetDateHourMinuteSecond(DateTime) Extracts the date part with the hour, minute, and second values from the defined DateTime. |
FunctionDescriptionGetDateMonthYear
|
Default value: GetDateMonthYear(DateTime) Returns the date of the first day of the month for a given DateTime. |
FunctionDescriptionGetDateQuarterYear
|
Default value: GetDateQuarterYear(DateTime) Returns the date of the first day of the quarter for a given DateTime. |
FunctionDescriptionGetQuarter
|
Default value: GetQuarter(DateTime) Extracts a quarter from the defined DateTime. |
FunctionDescriptionGetWeekOfMonth
|
Default value: GetWeekOfMonth(DateTime) Extracts the week of the month from the defined DateTime. |
FunctionDescriptionGetWeekOfYear
|
Default value: GetWeekOfYear(DateTime) Extracts the week of the year from the defined DateTime. |
FunctionDescriptionToDateTime
|
Default value: ToDateTime(Value) Converts Value to a DateTime value. |
FunctionDescriptionToBoolean
|
Default value: ToBoolean(Value) Converts Value to an equivalent Boolean value. |
FunctionDescriptionMakeDateTime3
|
Default value: MakeDateTime(Year, Month, Day) Returns a date value constructed from the specified Year, Month and Day. |
FunctionDescriptionMakeDateTime4
|
Default value: MakeDateTime(Year, Month, Day, Hour) Returns a date value constructed from the specified Year, Month, Day and Hour. |
FunctionDescriptionMakeDateTime5
|
Default value: MakeDateTime(Year, Month, Day, Hour, Minute) Returns a date value constructed from the specified Year, Month, Day, Hour and Minute. |
FunctionDescriptionMakeDateTime6
|
Default value: MakeDateTime(Year, Month, Day, Hour, Minute, Second) Returns a date value constructed from the specified Year, Month, Day, Hour, Minute and Second. |
FunctionDescriptionGetDateWeekYear
|
Default value: GetDateWeekYear(DateTime) Returns the date of the first day of the week for a given DateTime (uses culture settings). |
FunctionDescriptionGetDateWeekYear2
|
Default value: GetDateWeekYear(DateTime, [‘FirstDay’, ‘FirstFullWeek’, ‘FirstFourDayWeek’]) Returns the date of the first day of the week for a given DateTime. The second parameter determines the rule for calculating the calendar week. |
FunctionCategoryAggregate
|
Default value: Aggregate |
FunctionDescriptionCountNotNull
|
Default value: CountNotNull(Value) Returns a number of non-null values in rows used to calculate an aggregate value. |
FunctionDescriptionMode
|
Default value: Mode(Value) Returns the mode of the values, where the mode is the value that is repeated the most. |
FunctionDescriptionCountDistinct
|
Default value: CountDistinct(Value) Returns the number of unique values in rows used to calculate an aggregate value. |
FunctionDescriptionMedian
|
Default value: Median(Value) Returns the median of the values in rows used to calculate an aggregate value. |
FunctionDescriptionStdDev
|
Default value: StdDev(Value) Returns an estimate of the standard deviation of a population, where the sample is a subset of the entire population. |
FunctionDescriptionStdDevp
|
Default value: StdDevp(Value) Returns the standard deviation of a population, where the population is the entire data to be summarized. |
FunctionDescriptionVar
|
Default value: Var(Value) Returns an estimate of the variance of a population, where the sample is a subset of the entire population. |
FunctionDescriptionVarp
|
Default value: Varp(Value) Returns the variance of a population, where the population is the entire data to be summarized. |
FunctionDescriptionCount
|
Default value: Count() Returns the number of rows used to calculate an aggregate value. |
FunctionDescriptionMax
|
Default value: Max(Value) Returns the maximum value from rows used to calculate an aggregate value. |
FunctionDescriptionMin
|
Default value: Min(Value) Returns the minimum value from rows used to calculate an aggregate value. |
FunctionDescriptionAvg
|
Default value: Avg(Value) Calculates the average value from rows used to calculate an aggregate value. |
FunctionDescriptionSum
|
Default value: Sum(Value) Returns the sum of the values in rows. |
FunctionDescriptionWindowCustomAggregate
|
|
FunctionDescriptionRunningCustomAggregate
|
|
FunctionDescriptionFirstValue
|
|
FunctionDescriptionWindowDefinitionOrderDesc
|
Default value: desc(column) Data rows are sorted by values in the specified column in descending order. |
FunctionDescriptionWindowDefinitionOrderAsc
|
Default value: asc(column) Data rows are sorted by values in the specified column in ascending order. This is the default sort order. |
FunctionDescriptionWindowDefinitionOrderBy
|
Default value: orderBy(column1, column2, …) Specifies the columns by which the values are sorted. |
FunctionDescriptionWindowDefinitionPartitionBy
|
Default value: partitionBy(column1, column2, …) Specifies the columns by which the data rows are partitioned. The window function is applied to each partition separately. |
FunctionDescriptionWindowDefinition
|
Default value: w(WindowExpression, partitionByFunction, orderByFunction) Calculates aggregated values with the specified window function for the window defined by the specified partitioning and ordering. |