PivotGridControl Methods
Allows you to create a pivot table (cross-tabular format) for multi-dimensional analysis of large amounts of data.
Name | Description |
---|---|
About() static | Activates the Pivot Grid Control’s About dialog box. |
Accessibility |
Notifies the accessibility client applications of the specified Accessible |
Accessibility |
Notifies the accessibility client applications of the specified Accessible |
Begin |
Notifies the control that the initialization has started.
Inherited from Editor |
Begin |
Executes the specified delegate asynchronously with the specified arguments, on the thread that the control’s underlying handle was created on. Inherited from Control. |
Begin |
Executes the specified delegate asynchronously on the thread that the control’s underlying handle was created on. Inherited from Control. |
Begin |
Locks the Pivot |
Best |
Resizes all columns to fit their contents. |
Best |
Resizes the column |
Best |
Resizes columns in the Data Area to the minimum width required to display their contents. |
Best |
Resizes the Data Header Area to the minimum width required to display data field headers. |
Best |
Resizes columns that display row field values to the minimum width required to display their contents. |
Bring |
Brings the control to the front of the z-order. Inherited from Control. |
Calc |
Returns information on the grid elements located at the specified point. |
Can |
Indicates whether the field can be resized. |
Change |
Expands or collapses all values of the specified Pivot Grid field asynchronously. |
Change |
Toggles the sort order of the specified field asynchronously. |
Check |
Returns whether the Editor |
Clear |
Clears field sorting asynchronously in OLAP mode. |
Close |
Hides the active editor, saving changes made. |
Close |
|
Collapse |
Collapses all the columns and rows in the Pivot |
Collapse |
Collapses all columns and rows in a Pivot Grid control asynchronously. |
Collapse |
Collapses all columns. |
Collapse |
Collapses all columns asynchronously. |
Collapse |
Collapses all rows. |
Collapse |
Collapses all rows asynchronously. |
Collapse |
Collapses a specific column or row that is identified by the specified values. |
Collapse |
Collapses the specified column or row asynchronously. |
Contains |
Retrieves a value indicating whether the specified control is a child of the control. Inherited from Control. |
Convert |
Converts the Pivot |
Create |
Forces the creation of the visible control, including the creation of the handle and any visible child controls. Inherited from Control. |
Create |
Creates a new instance of the control collection for the control. Inherited from Control. |
Create |
Returns data records used to calculate summary values for all cells. |
Create |
Returns data records used to calculate a summary value for the specified cell. Allows you to specify the columns to return. |
Create |
Returns data records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to return. |
Create |
Returns data records used to calculate a summary value for the specified cell. Allows you to limit the number of returned records. |
Create |
Returns a list of records used to calculate a summary value for the specified cell. |
Create |
Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
Create |
Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
Create |
Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
Create |
Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
Create |
Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
Create |
Creates the Graphics for the control. Inherited from Control. |
Create |
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Inherited from Marshal |
Create |
Creates a copy of the current pivot grid’s OLAP data source instance. |
Create |
Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns to be returned. |
Create |
Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to be returned. |
Create |
Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell. |
Create |
Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to be returned. |
Create |
Returns a summary data source. |
Def |
Sends the specified message to the default window procedure. Inherited from Control. |
Destroy |
Destroys the handle associated with the control. Inherited from Control. |
Dispose() | Releases all resources used by the Component. Inherited from Component. |
Do |
Begins a drag-and-drop operation. Inherited from Control. |
Draw |
Supports rendering to the specified bitmap. Inherited from Control. |
End |
Notifies the control that the initialization has been completed.
Inherited from Editor |
End |
Retrieves the return value of the asynchronous operation represented by the IAsync |
End |
Unlocks the Pivot |
End |
Unlocks the Pivot Grid control after the Pivot |
Ensure |
Ensures that the Pivot Grid Control’s view information has been calculated. If not, forces the Pivot Grid Control to calculate the view information. |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Expand |
Expands all the columns and rows in the Pivot |
Expand |
Expands all columns and rows in the Pivot Grid control asynchronously. |
Expand |
Expands all columns. |
Expand |
Expands all columns asynchronously. |
Expand |
Expands all rows. |
Expand |
Expands all rows asynchronously. |
Expand |
Expands a specific column or row that is identified by the specified values. |
Expand |
Expands the specified column or row asynchronously. |
Export |
Exports the control’s data to the specified stream in CSV format using the specified options. |
Export |
Exports the control’s data to the specified stream in CSV. |
Export |
Exports the control’s data to the specified file in CSV format using the specified options. |
Export |
Exports the control’s data to the specified file in CSV format. |
Export |
Exports the control’s data to the specified stream in DOCX format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to a DOCX document and sends it to the specified stream. |
Export |
Exports the control’s data to the specified file in DOCX format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to the specified DOCX file. |
Export |
Exports the control’s data to the specified stream in HTML format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to an HTML document with the specified encoding and title and sends it to the specified stream. The output file can be compressed (secondary characters e. |
Export |
Exports the Pivot Grid Control’s data as HTML and sends it to the specified stream. |
Export |
Exports the control’s data to the specified file in HTML format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to an HTML file with the specified encoding and title. The output file can be compressed (secondary characters e. |
Export |
Exports the Pivot Grid Control’s data to a HTML file with the specified encoding. |
Export |
Exports the Pivot Grid Control’s data to the specified file as HTML. |
Export |
Exports the control’s data to the specified stream in Image format using the specified Image-specific options. |
Export |
Exports the control’s data to the specified stream in BMP format. |
Export |
Exports the control’s data to the specified file in Image format using the specified Image-specific options. |
Export |
Exports the control’s data to the specified file in BMP format. |
Export |
Exports the control’s data to the specified stream in MHT format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to an MHT document (Web archive, single file) at the specified path and title and sends it to the specified stream. The output file can be compressed (secondary characters e. |
Export |
Exports the control’s data to the specified file in MHT format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) with the specified path and title. The output file can be compressed (secondary characters e. |
Export |
Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) at the specified path and with the specified encoding. |
Export |
Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) at the specified path. |
Export |
Exports the control’s data to the specified stream in PDF format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to a PDF document and sends it to the specified stream. |
Export |
Exports the control’s data to the specified file in PDF format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to the specified PDF file. |
Export |
Exports the Pivot Grid Control’s data as Rich Text and sends it to the specified stream. |
Export |
Exports the Pivot Grid Control’s data to the specified RTF file. |
Export |
Exports the control’s data to the specified stream in Text format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to a text document with the specified separator string, text encoding settings and sends it to the specified stream. |
Export |
Exports the Pivot Grid Control’s data to a text document with the specified separator string and sends it to the specified stream. |
Export |
Exports the Pivot Grid Control’s data to a text document and sends it to the specified stream. |
Export |
Exports the control’s data to the specified file in Text format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to a text document with the specified separator string and text encoding settings, and sends it to the specified file. |
Export |
Exports the Pivot Grid Control’s data to a text file at the specified path and with the specified separator string. |
Export |
Exports the Pivot Grid Control’s data to a text file at the specified path. |
Export |
Exports the control’s data to the specified stream in XLS format using the specified options. |
Export |
Exports the control’s data to the specified stream in XLS format using the specified options. |
Export |
Exports the Pivot Grid Control’s data as XLS and sends it to the specified stream. |
Export |
Exports the control’s data to the specified file in XLS format using the specified options. |
Export |
Exports the control’s data to the specified file in XLS format using the specified options. |
Export |
Exports the Pivot Grid Control’s data to the specified file as XLS. |
Export |
Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
Export |
Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
Export |
Exports the control’s data to the specified stream in XLSX (MS Excel 2007) format. |
Export |
Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
Export |
Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
Export |
Exports the control’s data to the specified file in XLSX (MS Excel 2007) format. |
Find |
Retrieves the form that the control is on. Inherited from Control. |
Focus() | Sets input focus to the control. Inherited from Control. |
Force |
Forces the Pivot Grid Control to finish its initialization. |
From |
Retrieves the control that contains the specified handle. Inherited from Control. |
From |
Returns the control that is currently associated with the specified handle. Inherited from Control. |
Get |
Retrieves a value indicating how a control will behave when its Auto |
Get |
Returns a cell value by the column and row indexes. |
Get |
Returns a cell value calculated for the specified column and row field values, against the specified data field. |
Get |
Returns a cell value calculated for the specified column and row field values. |
Get |
Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. Inherited from Control. |
Get |
Retrieves the child control that is located at the specified coordinates. Inherited from Control. |
Get |
Returns the index of the specified column. |
Get |
Returns the index of the specified column. |
Get |
Returns the next Container |
Get |
Returns the field whose header is displayed at the specified point. |
Get |
Returns a field at the specified visual position in the specified area. |
Get |
Returns the list of fields that are available in the bound data source. |
Get |
Returns a list of fields displayed in the specified area. |
Get |
Returns the specified column or row field’s value for the cell addressed by its zero-based index in the Data Area. |
Get |
Returns an OLAP member for the specified field value. |
Get |
Gets the type of a specific column/row field’s value. |
Get |
Gets the type of a field value in the column or row area. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
|
Get |
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Inherited from Marshal |
Get |
Retrieves the next control forward or back in the tab order of child controls. Inherited from Control. |
Get |
Gets the list of key performance indicators (KPI) in a cube. |
Get |
Returns the Measures dimension’s members used to calculate the value, goal, status and weight of the specified Key Performance Indicator (KPI). |
Get |
Returns a graphic set defined on the server for the specified KPI’s trend and status. |
Get |
Returns the specified KPI’s value. |
Get |
Retrieves the size of a rectangular area into which a control can be fitted. Inherited from Control. |
Get |
Returns the index of the specified row. |
Get |
Returns the index of the specified row. |
Get |
Retrieves the bounds within which the control is scaled. Inherited from Control. |
Get |
Returns an object that represents a service provided by the Component or by its Container. Inherited from Component. |
Get |
Retrieves the value of the specified control style bit for the control. Inherited from Control. |
Get |
Returns the actual tooltip controller that controls the behavior and appearance of hints for the container editor.
Inherited from Editor |
Get |
Determines if the control is a top-level control. Inherited from Control. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Hide() | Conceals the control from the user. Inherited from Control. |
Hide |
Closes the Customization Form. |
Hide |
Hides the active editor discarding any changes made. |
Initialize |
Obtains a lifetime service object to control the lifetime policy for this instance.
Inherited from Marshal |
Init |
Called after the control has been added to another container. Inherited from Control. |
Invalidate() | Invalidates the entire surface of the control and causes the control to be redrawn. Inherited from Control. |
Invalidate |
Invalidates a specific region of the control and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control. |
Invoke |
Executes the specified delegate, on the thread that owns the control’s underlying window handle, with the specified list of arguments. Inherited from Control. |
Invoke |
Executes the specified delegate on the thread that owns the control’s underlying window handle. Inherited from Control. |
Invoke |
Raises the Got |
Invoke |
Raises the Lost |
Invoke |
Raises the Click event for the specified control. Inherited from Control. |
Invoke |
Raises the Paint event for the specified control. Inherited from Control. |
Invoke |
Raises the Paint event for the specified control.
Inherited from Control. |
Is |
Determines if a character is an input character that the control recognizes. Inherited from Control. |
Is |
Determines whether the specified key is a regular input key or a special key that requires preprocessing. Inherited from Control. |
Is |
Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control. |
Is |
Determines if the specified character is the mnemonic character assigned to the control in the specified string. Inherited from Control. |
Is |
Returns whether the specified column field value or row field value is collapsed. |
Is |
Returns whether the specified column field value or row field value is collapsed. |
Layout |
Updates a Pivot |
Load |
Restores the collapsed state of field values from the specified file. |
Load |
Restores the collapsed state of field values from the specified stream. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Marshal |
Notify |
Raises the Invalidated event with a specified region of the control to invalidate. Inherited from Control. |
On |
Raises the Auto |
On |
Raises the Back |
On |
Raises the Background |
On |
Raises the Background |
On |
Raises the Causes |
On |
Raises the Change |
On |
Raises the Client |
On |
Raises the Context |
On |
Raises the Context |
On |
Raises the Control |
On |
Raises the Control |
On |
Raises the Cursor |
On |
Raises the Dock |
On |
Raises the Drag |
On |
Raises the Drag |
On |
Raises the Drag |
On |
Raises the Drag |
On |
Raises the Enabled |
On |
Raises the Font |
On |
Raises the Fore |
On |
Raises the Give |
On |
Raises the Help |
On |
Raises the Ime |
On |
Raises the Invalidated event. Inherited from Control. |
On |
Raises the Key |
On |
Raises the Layout event. Inherited from Control. |
On |
Raises the Location |
On |
Raises the Margin |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Move event. Inherited from Control. |
On |
Notifies the control of Windows messages. Inherited from Control. |
On |
Raises the Padding |
On |
Paints the background of the control. Inherited from Control. |
On |
Raises the Back |
On |
Raises the Background |
On |
Raises the Binding |
On |
Raises the Cursor |
On |
Raises the Enabled |
On |
Raises the Font |
On |
Raises the Fore |
On |
Raises the Right |
On |
Raises the Visible |
On |
Raises the Preview |
On |
Raises the Paint event. Inherited from Control. |
On |
Raises the Query |
On |
Raises the Region |
On |
Raises the Resize event. Inherited from Control. |
On |
Raises the Style |
On |
Raises the System |
On |
Raises the Tab |
On |
Raises the Tab |
On |
Raises the Text |
Perform |
Forces the control to apply layout logic to all its child controls. Inherited from Control. |
Perform |
Forces the control to apply layout logic to all its child controls. Inherited from Control. |
Point |
Computes the location of the specified screen point into client coordinates. Inherited from Control. |
Point |
Computes the location of the specified client point into screen coordinates. Inherited from Control. |
Post |
Posts the value being edited to the associated data source without closing the editor. |
Post |
|
Pre |
Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
Pre |
Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
Print() |
Prints the Pivot |
Process |
Processes a command key. Inherited from Control. |
Process |
Processes a dialog character. Inherited from Control. |
Process |
Processes a key message and generates the appropriate control events. Inherited from Control. |
Process |
Processes a keyboard message. Inherited from Control. |
Process |
Previews a keyboard message. Inherited from Control. |
Process |
Processes a mnemonic character. Inherited from Control. |
Raise |
Raises the appropriate drag event. Inherited from Control. |
Raise |
Raises the appropriate key event. Inherited from Control. |
Raise |
Raises the appropriate mouse event. Inherited from Control. |
Raise |
Raises the appropriate paint event. Inherited from Control. |
Recreate |
Forces the re-creation of the handle for the control. Inherited from Control. |
Rectangle |
Computes the size and location of the specified screen rectangle in client coordinates. Inherited from Control. |
Rectangle |
Computes the size and location of the specified client rectangle in screen coordinates. Inherited from Control. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Reflect |
Reflects the specified message to the control that is bound to the specified handle. Inherited from Control. |
Refresh |
Reloads data from the control’s data source and recalculates summaries. |
Refresh |
Reloads data from the control data source and recalculates summaries asynchronously. |
Reset |
Resets the Back |
Reset |
Causes a control bound to the Binding |
Reset |
Resets the Cursor property to its default value. Inherited from Control. |
Reset |
For internal use.
Inherited from Editor |
Reset |
For internal use.
Inherited from Editor |
Reset |
Resets the Font property to its default value. Inherited from Control. |
Reset |
Resets the Fore |
Reset |
Resets the Ime |
Reset |
Resets the control to handle the Mouse |
Reset |
Resets the Right |
Reset |
Resets the Text property to its default value (Empty). Inherited from Control. |
Restore |
Restores the Pivot Grid Control’s layout stored at the specified system registry path, using the specified settings. |
Restore |
Restores the layout stored at the specified system registry path. |
Restore |
Restores a Pivot Grid Control’s layout from the specified stream, using the specified settings. |
Restore |
Restores a Pivot Grid Control’s layout from the specified stream. |
Restore |
Restores a Pivot Grid Control’s layout using the specified settings from the specified XML file. |
Restore |
Restores a Pivot Grid Control’s layout from the specified XML file. |
Resume |
Resumes usual layout logic. Inherited from Control. |
Resume |
Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. Inherited from Control. |
Retrieve |
Creates Pivot |
Retrieve |
Creates Pivot |
Retrieve |
Creates Pivot |
Retrieve |
Creates Pivot |
Rtl |
Converts the specified Content |
Rtl |
Converts the specified Horizontal |
Rtl |
Converts the specified Left |
Rtl |
Converts the specified Content |
Rtl |
Converts the specified Horizontal |
Rtl |
Converts the specified Left |
Save |
Saves the collapsed state of field values to the specified file. |
Save |
Saves the collapsed state of field values to the specified stream. |
Save |
Saves a Pivot Grid Control’s layout to the specified system registry path, using the specified settings. |
Save |
Saves a Pivot Grid Control’s layout to a system registry path. |
Save |
Saves a Pivot Grid Control’s layout to the specified stream, using the specified settings. |
Save |
Saves a Pivot Grid Control’s layout to the specified stream. |
Save |
Saves a Pivot Grid Control’s layout to the specified XML file, using the specified settings. |
Save |
Saves a Pivot Grid Control’s layout to an XML file. |
Save |
Saves the Pivot Grid Control’s data and full layout to the specified file, and allows the data to be compressed. |
Save |
Saves the Pivot Grid Control’s data and full layout to the specified file. |
Save |
Saves the Pivot Grid Control’s data and full layout to the specified stream, and allows the data to be compressed. |
Save |
Saves the Pivot Grid Control’s data and full layout to the specified stream. |
Scale |
Scales the control and all child controls by the specified scaling factor. Inherited from Control. |
Scale |
Scales the entire control and any child controls. Inherited from Control. |
Scale |
Scales the control and any child controls. Inherited from Control. |
Scale |
This method is not relevant for this class. Inherited from Control. |
Select() | Activates the control. Inherited from Control. |
Select |
Activates a child control. Optionally specifies the direction in the tab order to select the control from. Inherited from Control. |
Select |
Activates the next control. Inherited from Control. |
Send |
Sends the control to the back of the z-order. Inherited from Control. |
Set |
Sets a value indicating how a control will behave when its Auto |
Set |
Sets the specified bounds of the control to the specified location and size. Inherited from Control. |
Set |
Sets the bounds of the control to the specified location and size. Inherited from Control. |
Set |
Performs the work of setting the specified bounds of this control. Inherited from Control. |
Set |
Sets the size of the client area of the control. Inherited from Control. |
Set |
Sets the data source for the Pivot Grid control and loads data asynchronously. |
Set |
Sets the sort order for the specified field asynchronously. |
Set |
Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously. |
Set |
|
Set |
|
Set |
Sets a specified Controltrue or false .
Inherited from Control. |
Set |
Sets the control as the top-level control. Inherited from Control. |
Set |
Sets the control to the specified visible state. Inherited from Control. |
Show() | Displays the control to the user. Inherited from Control. |
Show |
|
Show |
Displays the Customization Form. |
Show |
Displays the Customization Form at the specified point. |
Show |
Displays the Customization Form and assigns it to the specified parent. |
Show |
Invokes the focused cell’s editor. |
Show |
Invokes the in-place editor for the cell at the specified position. |
Show |
Invokes the Expression Editor where a user can edit the specified field’s binding expression. |
Show |
Opens the Print Preview window with a toolbar-based interface. |
Show |
Opens the Print Preview window with a Ribbon-based interface. |
Show |
Invokes the Expression Editor that enables editing a specified unbound field’s expression. |
Size |
Determines the size of the entire control from the height and width of its client area. Inherited from Control. |
Suspend |
Temporarily suspends the layout logic for the control. Inherited from Control. |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
To |
Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component. |
Update() | Causes the control to redraw the invalidated regions within its client area. Inherited from Control. |
Update |
Updates the bounds of the control with the current size and location. Inherited from Control. |
Update |
Updates the bounds of the control with the specified size, location, and client size. Inherited from Control. |
Update |
Updates the bounds of the control with the specified size and location. Inherited from Control. |
Update |
Forces the assigned styles to be reapplied to the control. Inherited from Control. |
Update |
Updates the control in its parent’s z-order. Inherited from Control. |
Validate |
Validates the active editor. |
Xtra |
For internal use. |
See Also