RadPivotGrid is a control that empowers your applications with similar functionality to the PivotTables in MS Excel. It takes large chunks of data and summarizes it in a human readable way with the help of aggregates and field descriptors.
The control offer great performance achieved through the UI virtualization used for its visual elements.
RadPivotGrid comes loaded with full-fledged support for OLAP data sources featuring an OLAP browser. With its help, you not only get access to the data in an OLAP cube but also to the structure of the bound data source. The accompanying Hierarchical Field List is fully optimized to load on demand the entire structure of the bound OLAP data source.
As a prerequisite for each data management control, RadPivotGrid provides intuitive filtering and sorting options out of the box.
The Telerik PivotGrid has the ability for you to display all of your available fields in an external window from which they can be dragged and dropped in to the control itself to group by the desired fields.
RadPivotGrid can easily export data to native XLSX and PDF formats via the export providers using our Document Processing Libraries, PdfProcessing and SpreadProcessing.
RadPivotGrid can display Key Performance Indicators (KPIs) which will allow you to quickly spot trends or evaluate current or past performance.
Exploit native printing support with a bunch of customization settings available for the printing layout. Your end users can send their pivotized reports to the printer, then fine-tune the printing layout using the Print preview or Print settings dialogs. They can set page headers, page footers and watermarks, as well, and adjust paper size settings.
The control enables user to add calculated fields or items, which rely on specific business logic, in row or column manually.
RadPivotFieldList provides your users with an easy runtime customization of the RadPivotGrid reports. With it, they can change the way they represent aggregated data in RadPivotGrid by modifying the column/row group descriptions, aggregate descriptions or report filters. This can be achieved by dragging fields across the four list boxes, or by reordering the items in a single list. A deferred layout update option is also available, so users can stack changes and perform them at once. The features of the control are quite similar to the PivotTable Field List panel in Microsoft Excel.
Last, but not least, the control exposes its inner elements, so users can make additional customizations, according to their needs.
The control’s cell selection functionality can be turned off by a single property setting. Other features, such as column best fit and resize, the clipboard cut/copy/paste and contextual operations delivered by the embedded context menus improve the user experience with the control.
RadPivotGrid provides rich design-time support functionality, making customizations and configurations very easy. Some key capabilities include:
The control is shipped with a rich set of themes that enable you to easily build slick interfaces with the look and feel of Windows Vista, Office 2007, Outlook and so on. Themes can be switched easily using a single property.
In addition our framework supports custom themes, which you can build from scratch to fit your exact visual demands, using the Visual Style Builder productivity tool.