Pivot table wrapper that collapses all groups except ones that are explicitely expanded.
Inheritance Hierarchy
NReco.PivotDataCollapsePivotTable
Namespace: NReco.PivotData
Assembly: NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.6.1
Syntax
The CollapsePivotTable type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() | CollapsePivotTable |
Initializes a new instance of CollapsePivotTable instance by specified CollapsePivotTableConfiguration.
|
Properties
Name | Description | |
---|---|---|
![]() | ColumnKeys | |
![]() | Columns | |
![]() | PivotData | |
![]() | RowKeys | |
![]() | Rows |
Methods
Name | Description | |
---|---|---|
![]() | Equals | (Inherited from Object.) |
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | GetValue | |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | ToString | (Inherited from Object.) |
Remarks
Use this class if you need to prepare pivot table data model where only some groups are expanded. Usually it is used for exports and canned reports.
NOTE: do not use this wrapper for interactive web pivot table where user can expand/collapse groups: for this purpose PivotTableHtmlWriter implements this functionality in a special way (see ).
Examples
PivotTable originalPvtTbl; var collapsedPvtTbl = new CollapsePivotTable(originalPvtTbl, new CollapsePivotTableConfiguration() { // expand: // - 1st (index=0) group of the 1st dimension on rows // - 3rd (index=2) group and its 1st (index=0) sub-group ExpandedRows = new int[][] { new int[] { 0 }, new int[] { 2, 0} } } );
See Also