background

UI for WinForms

WinForms PivotGrid

  • The WinForms PivotGrid control provides similar functionality to the PivotTables in MS Excel.
  • Part of the Telerik UI for WinForms library along with 160+ professionally-designed UI controls.
  • Includes support, documentation, demos, virtual classrooms, Visual Studio Extensions and more!
WinForms pivot grid control
  • Summarize Large Datasets in Readable Way

    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.
    UI for WinForms PivotGrid Overview
  • Flexible Pivoting

    The WinForms PivotGrid control allows end-users to easily interact with and break down raw data into any fashion they desire. With a pivot table users can create summarizations and highlight specific data with a few clicks.
    WinForms PivotGrid control
  • Full OLAP Support

    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.
    WinForms PivotGrid control showcasing OLAP support
  • Tabular And Compact Layouts

    RadPivotGrid supports two types of layouts – Tabular and Compact. The Tabular layout displays each field in a separate box – for row descriptors in a separate column, and for column descriptors in a separate row. The compact layout nests the field descriptors in one common box to optimize space which can be useful in any scenario which uses a large number of fields.
    WinForms PivotGrid showcasing Tabular And Compact Layouts
  • Easy Data Filtering and Sorting

    As a prerequisite for each data management control, RadPivotGrid provides intuitive filtering and sorting options out of the box.
    WinForms PivotGrid displaying Easy Data Filtering and Sorting
  • Group Filtering

    The standard data manipulation capabilities are complemented by group filtering options that allow your end-users to achieve the exact data view they desire. They are accessible via context menus and dialogs which pretty much resemble those available in MS Excel.
    Group Filtering in the WinForms PivotGrid control
  • Drag And Drop Support

    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.
    WinForms PivotGrid Drag and Drop Support
  • Export

    RadPivotGrid can easily export data to native XLSX and PDF formats via the export providers using our Document Processing Libraries, PdfProcessing and SpreadProcessing.

    WinForms PivotGrid control showcasing export to excel
  • KPI Indicators

    RadPivotGrid can display Key Performance Indicators (KPIs) which will allow you to quickly spot trends or evaluate current or past performance.

    KPI Indicators in the WinForms PivotGrid control
  • Data Binding to ChartView

    RadPivotGrid enables seamless integration with RadChartView, providing users a visual indication of certain portions of the data in the control.
    Data Binding to ChartView in the WinForms PivotGrid Control
  • Advanced Printing Options

    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.
    Advanced Printing Options in the WinForms PivotGrid control
  • Save/Load Layout

    RadPivotGrid supports save and load layout functionality, which enables applications to preserve user RadPivotGrid settings, such as group descriptors, and restore them later. Using this functionality, users can store different layout settings of the control and switch between them, when needed.
  • Calculated Fields and Calculated Items

    The control enables user to add calculated fields or items, which rely on specific business logic, in row or column manually.

    • A calculated field is a new data field in which the values result from a custom calculation formula. You can display the calculated field along with another data field or on its own.
    • A calculated item is a new item in a row or column field in which the values are the result of a custom calculation. In this case, the calculated item’s formula references one or more items in the same field. Using Calculated Items enables you to extend RadPivotGrid with additional items that are not part of the data source.
  • Field List

    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.

    Field List in the WinForms PivotGrid Control
  • Selection and clipboard operations

    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.
    UI for WinForms PivotGrid displaying a Context Menu
  • Fine-Grained Customizations and Tooltips

    Visual elements such as cells, groups and the like, and menus in the control are accessible and highly customizable. You can change colors, fonts and directions; add/remove/replace menu items in context menus; set error text for no-data cells and much more to satisfy any UI requirement. You can also show tool tips based on the currently hovered element in the control.
  • Extensive VS.NET Design-time Support

    RadPivotGrid provides rich design-time support functionality, making customizations and configurations very easy. Some key capabilities include:

    • A dedicated Property Builder, which aids the control setup at design time
    • Convenient properties exposed at the control Smart Tag for quick control setup
    • The ability to apply themes in design time and switch between them; the ThemeName property in the Smart tag automatically detects the present themes
    • Visual Style Builder, Element Hierarchy Editor and Shape Editor productivity tools for full control over the UI
    • Options to search the forums or open the control online documentation in the Smart Tag
    WinForms PivotGrid control in Design Time
  • Localization Support

    Business globalization requires multilingual applications. RadPivotGrid supports full localization of its strings. See Localization and Right-to-Left Support for the full list of controls supporting RTL and localization.
  • Appearance

    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.

    WinForms PivotGrid displaying customization scenarios

All Winforms Components

Next Steps