Overview

24 May 20191 minute to read

PivotGrid control is an easily configurable, presentation-quality business control that reads both OLAP and Relational datasource, allows to create multi-dimensional views for analysis and satisfying business user needs.

Some of the key feature available in PivotGrid are listed below:

1. Data Binding: Supports both OLAP and Relational datasource data binding in the same environment.
2. PivotTable Field List: Lists the entire datasource bound to PivotGrid and allows UI interaction such as filtering and drag drop operation of any measure, dimension, hierarchy, level and field at runtime.
3. Grouping Bar: Supports UI interaction at runtime through sorting, filtering and drag drop operation of the existing field items bound through report.
4. Grid Layout: Four different layouts such as normal, top summary, no summary and excel-like layout are supported.
5. Export: PivotGrid can be exported to Word, PDF, CSV and Excel documents.
6. PivotGrid control specific features such as hyperlink, cell selection, conditional formatting, RTL, globalization and localization are supported as well.