PivotTableDataTableWriter Class

NReco.PivotData Class Library Documentation
Exports pivot table model to ADO.NET DataTable.
Inheritance Hierarchy

SystemObject
  NReco.PivotData.OutputPivotTableWriterBase
    NReco.PivotData.OutputPivotTableDataTableWriter

Namespace:  NReco.PivotData.Output
Assembly:  NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.4.2
Syntax

public class PivotTableDataTableWriter : PivotTableWriterBase

The PivotTableDataTableWriter type exposes the following members.

Constructors

  NameDescription
Public methodPivotTableDataTableWriter
Initializes a new instance of the PivotTableDataTableWriter class
Top
Properties

  NameDescription
Public propertyColumnCaptionSeparator
Gets or sets separator for joining column caption parts.
Public propertyFormatAggregatorName
Gets or sets custom formatting handler for aggregator name (aggregator factory)->(label).
Public propertyFormatColumnKey
Gets or sets custom formatting handler for table column labels (key,dimension)->(label).
Public propertyGrandTotal
Include grand totals value into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsColumn
Include totals column into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsColumnHeaderText
Gets or sets title text for totals column header (Totals by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsRow
Include totals row into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsRowHeaderText
Gets or sets title text for totals row header (Totals by default).
(Inherited from PivotTableWriterBase.)
Top
Methods

  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodGetAggregatorsCount (Inherited from PivotTableWriterBase.)
Protected methodGetAggregatorValue
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Public methodWrite
Generate DataTable by specified PivotTable instance.
Top
Remarks

Examples

PivotTable pvtTbl; // lets assume we already have a PivotTable instance
var pvtDataTableWr = new PivotTableDataTableWriter("PivotTable");
DataTable res = pvtDataTableWr.Write(pvtTbl);
See Also

Reference