Back to Devexpress

XRPivotGrid Members

xtrareports-devexpress-dot-xtrareports-dot-ui-dot-xrpivotgrid-dot-underscore-members.md

latest44.1 KB
Original Source

XRPivotGrid Members

Displays multi-dimensional data in reports.

Constructors

NameDescription
XRPivotGrid()Initializes a new instance of the XRPivotGrid class with the default settings.

Properties

NameDescription
ActualHeightGets the XRPivotGrid‘s rendered height (measured in report units).
ActualWidthGets the XRPivotGrid‘s rendered width (measured in report units).
AnchorHorizontalSpecifies the horizontal anchoring type of a report control. Inherited from XRControl.
AnchorVerticalSpecifies the vertical anchoring style of a report control. Inherited from XRControl.
AppearanceProvides access to the properties that control the appearance of the pivot grid’s elements.
BandProvides access to the owner band, in which the current control is situated. Inherited from XRControl.
BookmarkBindable. Gets or sets the text of a bookmark for this control. Inherited from XRControl.
BookmarkParentGets or sets the report control whose bookmark is the parent of the current bookmark. Inherited from XRControl.
BottomFGets the Y-coordinate of the control’s bottom edge (measured in report units). Inherited from XRControl.
BoundsFSpecifies the location and size of a report element, according to the system of measurement selected for the report. Inherited from XRControl.
CanHaveChildrenGets a value indicating whether the control can contain other controls. Inherited from XRControl.
CanRaiseEvents protectedGets a value indicating whether the component can raise an event. Inherited from Component.
CellStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.CellStyle property.
ColumnCountGets the number of columns in the XRPivotGrid.
ContainerGets the IContainer that contains the Component. Inherited from Component.
ControlsGets the collection of XRControl objects or their descendants that are contained in this control. Inherited from XRControl.
CustomTotalCellStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.CustomTotalCellStyle property.
DataAdapterGets or sets the data adapter used to populate the pivot grid’s data source.
DataMemberSpecifies the data source member which supplies data to the Pivot Grid.
DataSourceGets or sets the pivot grid control’s data source. If it’s empty, then the report’s data source will be used.
DesignMode protectedGets a value that indicates whether the Component is currently in design mode. Inherited from Component.
Events protectedGets the list of event handlers that are attached to this Component. Inherited from Component.
ExpressionBindingsProvides access to a control’s collection of expression bindings. Inherited from XRControl.
FieldHeaderStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.FieldHeaderStyle property.
FieldsProvides access to a pivot grid’s field collection.
FieldValueGrandTotalStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.FieldValueGrandTotalStyle property.
FieldValueStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.FieldValueStyle property.
FieldValueTotalStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.FieldValueTotalStyle property.
FilterSeparatorStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.FilterSeparatorStyle property.
FormattingRulesProvides access to a collection of formatting rules applied to this control. Inherited from XRControl.
GrandTotalCellStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.GrandTotalCellStyle property.
HasChildrenGets a value indicating whether the control contains other XRControl objects. Inherited from XRControl.
HeaderGroupLineStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.HeaderGroupLineStyle property.
HeightFSpecifies the control’s height (measured in report units). Inherited from XRControl.
IndexGets the zero-based index of this control in its parent’s collection of controls. Inherited from XRControl.
IsDisposedFor internal use. Gets a value indicating whether the control has been disposed of. Inherited from XRControl.
IsSingleChildChecks whether the report element (control or band) is a single child of its parent. Inherited from XRControl.
KeepTogetherSpecifies whether a control can be split across pages. Inherited from XRControl.
LeftFSpecifies the X-coordinate of the control’s left edge (measured in report units). Inherited from XRControl.
LinesStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.LinesStyle property.
LocationFSpecifies the floating-point representation of the coordinates of the control’s upper-left corner. Inherited from XRControl.
LocationFloatFor internal use. Supports serialization of the XRControl.LocationF property. Inherited from XRControl.
LockedInUserDesignerGets or sets a value that specifies whether this control can be changed by an end-user in the End-User Designer. Inherited from XRControl.
NameGets or sets a name of the control. Inherited from XRControl.
OLAPConnectionStringSpecifies a connection string to a cube in an MS Analysis Services database.
OLAPDataProviderSpecifies an OLAP data provider.
OptionsChartDataSourceProvides access to the options controlling the display of the Pivot Grid’s data in a Chart.
OptionsDataProvides access to the pivot grid’s data specific options.
OptionsDataFieldProvides access to the options which control the presentation of the data fields in the Pivot Grid.
OptionsLayoutFor internal use.
OptionsPrintProvides access to the pivot grid’s print options.
OptionsViewProvides access to the pivot grid’s display options.
ParentSpecifies the parent object that contains the current control. Inherited from XRControl.
PrefilterProvides access to the Prefilter settings that enable filtering the incoming data.
ReportProvides access to the report that contains the control. Inherited from XRControl.
RightFGets the X-coordinate of the control’s right edge (measured in report units). Inherited from XRControl.
RightToLeftSpecifies the orientation of the content within the Pivot Grid’s cells.
RootReportProvides access to the report to which the control belongs. Inherited from XRControl.
RowCountGets the number of rows in the XRPivotGrid.
ScriptsProvides access to an object that contains XRPivotGrid-specific scripts to handle its events in the End-User Report Designer.
SiteGets or sets the ISite of the Component. Inherited from Component.
SizeFGets or sets the size of the control. Inherited from XRControl.
SnapLineMarginSpecifies the control’s margins that are maintained when the control is aligned using snap lines. Inherited from XRControl.
StylesProvides access to the style settings that control the appearance of the Pivot Grid.
TagBindable. Gets or sets the object that contains data about this control. Inherited from XRControl.
TopFGets or sets the Y-coordinate of the control’s top edge (measured in report units). Inherited from XRControl.
TotalCellStyleNameGets or sets the name of the style assigned to the XRPivotGridStyles.TotalCellStyle property.
VisibleGets or sets a value that specifies whether the report control is displayed in the document. Inherited from XRControl.
WidthFSpecifies the control’s width (measured in report units). Inherited from XRControl.

Methods

NameDescription
AllControls<T>()Returns a collection that contains all controls found within XRControl (within a report). Inherited from XRControl.
BestFit()Resizes the columns which correspond to the data fields and row fields to the minimum width required to completely display the column’s contents.
BestFit(XRPivotGridField)Resizes the columns which correspond to the specified field to the minimum width required to completely display the column’s contents.
BringToFront()Brings the control to the front of the z-order. Inherited from XRControl.
CollapseAll()Collapses all the columns and rows in the pivot grid.
CollapseAllColumns()Collapses all the columns in the pivot grid.
CollapseAllRows()Collapses all the rows in the pivot grid.
CreateObjRef(Type)Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. Inherited from MarshalByRefObject.
Dispose()Releases all resources used by the Component. Inherited from Component.
Equals(Object, Object) staticDetermines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)Determines whether the specified object is equal to the current object. Inherited from Object.
ExpandAll()Expands all the columns and rows in the pivot grid.
ExpandAllColumns()Expands all the columns in the pivot grid.
ExpandAllRows()Expands all the rows in the pivot grid.
FindControl(String, Boolean)Finds the control that has the specified name in the XRControl.Controls collection. Inherited from XRControl.
GetCellInfo(Int32, Int32)Returns an object that contains information on the specified cell.
GetCellValue(Int32, Int32)Returns a value displayed in the specified cell.
GetCellValue(Object[], Object[], XRPivotGridField)Retrieves a cell value, identified by the specified data field, column and row field values.
GetCellValue(Object[], Object[])Retrieves a cell value, identified by the specified column and row field values.
GetEffectiveBackColor()Returns the color actually used as the control’s background color. Inherited from XRControl.
GetEffectiveBorderColor()Returns the color actually used as the control’s border color. Inherited from XRControl.
GetEffectiveBorderDashStyle()Returns the border dash style that is actually used by the control. Inherited from XRControl.
GetEffectiveBorders()Returns the borders settings actually used as the control’s borders settings. Inherited from XRControl.
GetEffectiveBorderWidth()Returns the border width settings actually used as the control’s current settings. Inherited from XRControl.
GetEffectiveFont()Returns the font actually used as the control’s font. Inherited from XRControl.
GetEffectiveForeColor()Returns the color actually used as the control’s foreground color. Inherited from XRControl.
GetEffectivePadding()Returns the padding values actually used as the control’s padding. Inherited from XRControl.
GetEffectiveStyle()Returns the actual visual style of a control taking into account all formatting rules and odd/even styles applied to the control. Inherited from XRControl.
GetEffectiveTextAlignment()Returns the text alignment actually used as the control’s text alignment. Inherited from XRControl.
GetFieldByArea(PivotArea, Int32)Returns a field at the specified visual position in the specified area.
GetFieldValue(PivotGridFieldBase, Int32)Returns the specified field value.
GetFieldValueType(Boolean, Int32)Gets the type of a field value in the column or row area.
GetHashCode()Serves as the default hash function. Inherited from Object.
GetLifetimeService()Retrieves the current lifetime service object that controls the lifetime policy for this instance. Inherited from MarshalByRefObject.
GetService(Type) protectedReturns an object that represents a service provided by the Component or by its Container. Inherited from Component.
GetType()Gets the Type of the current instance. Inherited from Object.
InitializeLifetimeService()Obtains a lifetime service object to control the lifetime policy for this instance. Inherited from MarshalByRefObject.
IsObjectCollapsed(XRPivotGridField, Int32)Returns a value indicating whether or not the specified column field value or row field value is collapsed.
IsObjectCollapsed(Boolean, Int32, Int32)Returns a value indicating whether or not the specified column field value or row field value is collapsed.
MemberwiseClone() protectedCreates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protectedCreates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
PerformLayout()Forces the control to apply layout logic to itself and all its child controls. Inherited from XRControl.
ReferenceEquals(Object, Object) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
RemoveInvalidBindings(Predicate<XRBinding>)Removes inappropriate bindings assigned to the XRControl‘s properties. Inherited from XRControl.
ResetBackColor()Resets the XRControl.BackColor property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetBorderColor()Resets the XRControl.BorderColor property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetBorderDashStyle()Resets the XRControl.BorderDashStyle property to en empty value. Inherited from XRControl.
ResetBorders()Resets the XRControl.Borders property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetBorderWidth()Resets the XRControl.BorderWidth property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetFont()Resets the XRControl.Font property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetForeColor()Resets the XRControl.ForeColor property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetPadding()Resets the XRControl.Padding property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
ResetTextAlignment()Resets the XRControl.TextAlignment property value, so that it is no longer stored in the current control and is obtained from its parent instead. Inherited from XRControl.
RestoreLayoutCore(XtraSerializer, Stream, OptionsLayoutBase)
RestoreLayoutCore(XtraSerializer, String, OptionsLayoutBase)
RestoreLayoutFromStream(Stream, OptionsLayoutBase)Restores a pivot grid’s layout from the specified stream, using the specified settings.
RestoreLayoutFromStream(Stream)Restores a pivot grid’s layout from the specified stream.
ResumeLayout()Resumes normal layout logic for the control. Inherited from XRControl.
RetrieveFields()Creates XRPivotGridField objects for all the fields in the XRPivotGrid‘s bound data source.
SendToBack()Sends the control to the back of the z-order. Inherited from XRControl.
SuspendLayout()Temporarily suspends the layout logic for the control. Inherited from XRControl.
ToImage()Returns a graphical representation of a control. Inherited from XRControl.
ToImage(DXTextRenderingHint)Returns the graphical representation of a control created using the specified text rendering mode. Inherited from XRControl.
ToString()Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component.
XtraFindFieldsItem(XtraItemEventArgs)For internal use.

Events

NameDescription
AfterPrintOccurs after an XRControl object is displayed in the report. Inherited from XRControl.
BeforePrintOccurs before an XRControl object creates its image in a report being generated. Inherited from XRControl.
CustomCellDisplayTextEnables custom display text to be provided for the cells displayed within the Data Area.
CustomCellValueAllows you to replace cell values with custom ones.
CustomChartDataSourceDataOccurs when a XRPivotGrid control prepares data to be displayed in a XRChart control.
CustomChartDataSourceRowsOccurs before the XRPivotGrid control passes its data to a bound XRChart control.
CustomColumnWidthEnables you to specify a custom column width or hide certain columns based on specified criteria.
CustomFieldSortProvides the capability to sort data using custom rules.
CustomFieldValueCellsAllows you to customize field value cells of XRPivotGrid.
CustomGroupIntervalAllows you to custom group values of column and row fields.
CustomRowHeightEnables you to specify a custom row height (e.g., to hide some rows based on specific criteria).
CustomServerModeSortProvides the capability to sort data using custom rules in OLAP and server mode.
CustomSummaryEnables summary values to be calculated manually.
CustomUnboundFieldDataEnables data to be provided for unbound fields.
DisposedOccurs when the component is disposed by a call to the Dispose() method. Inherited from Component.
DrawThis event is not available for the XRPivotGrid class.
EvaluateBindingOccurs after a data-bound XRControl object obtains data from its data source. Inherited from XRControl.
FieldValueDisplayTextEnables the display text of individual column and row headers and filter dropdown items to be customized.
HtmlItemCreatedThis event is not available for the XRPivotGrid class.
LocationChangedOccurs when the value of the XRControl.LocationF property is changed. Inherited from XRControl.
ParentChangedOccurs when the XRControl instance’s parent is changed. Inherited from XRControl.
PrefilterCriteriaChangedFires when the Prefilter’s criteria are changed.
PreviewClickThis event is not available for the XRPivotGrid class.
PreviewDoubleClickThis event is not available for the XRPivotGrid class.
PreviewMouseDownThis event is not available for the XRPivotGrid class.
PreviewMouseMoveThis event is not available for the XRPivotGrid class.
PreviewMouseUpThis event is not available for the XRPivotGrid class.
PrintCellEnables you to render a different content for individual data cells.
PrintFieldValueEnables you to render a different content for individual field values.
PrintHeaderEnables you to render a different content for individual field headers.
PrintOnPageThis event is not available for the XRPivotGrid class.
SizeChangedOccurs when the value of the XRControl.SizeF property is changed. Inherited from XRControl.
TextChangedThis event is not available for the XRPivotGrid class.

See Also

XRPivotGrid Class

DevExpress.XtraReports.UI Namespace