Sql.Net Class Library Documentation

PivotTable Class

Facilates Pivot Table (Cross-Tab) transformation from relational data

For a list of all members of this type, see PivotTable Members.


public class PivotTable

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.


Use PivotTable class to create Cross-Tab reports.

Set BaseQuery or BaseSql property to SQL which produces data that needs to be pivoted. Set RowField to specify how data should be grouped. Set ValueField and Function to specify how the values in the cross tab should be collected. Create at least one PivotColumn which specifies the data column to pivot on and the which Cross-Tab columns are to be created.


Namespace: Reeb.Reporting

Assembly: Reeb.Reporting (in Reeb.Reporting.dll)

See Also

PivotTable Members | Reeb.Reporting Namespace