Screenshot Preview

XtraPivotGrid Suite

by DevExpress (Developer Express) - Product Type: Component / .NET WinForms

New licenses can only be purchased as part of DXperience, DevExpress Universal Suite or DXperience WinForms

If you require information, please visit the pages above or Contact Us for pricing and availability.

Fast, fully customizable OLAP grid. XtraPivotGrid is an Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab report generation. Numerous layout customization options give you total control over its UI and user-centric features make it easy to deploy. The Xtra Pivot Grid Suite was engineered from the ground-up to eliminate the limitations imposed by out-of-process solutions and to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the Xtra Pivot Grid is able to slice and dice information efficiently and intuitively present it to end-users. It delivers numerous layout customization options with total end-user control over each individual on-screen report.

What's new in XtraPivotGrid 13.1?

  • New Control Designer UI:  Design-time customization dialogs for our WinForms Controls have been re-designed for improved usability and a more consistent user experience.
  • Contextual Smart Tags:  WinForms Navigation Controls (including the Ribbon, Toolbars, NavBar) now display Smart Tags for their individual elements. This allows a customer to customize the control's layout and main settings with a few simple clicks, without using the Property Grid. We've also reviewed and extended our Smart Tags based on the usage experience of the controls.

New WinForms Data Source Wizard
Available via a Smart Tag or the clickable label on any DevExpress data-aware control, this wizard helps you set up your Data Source in three easy steps. In the first step, the Wizard lists all data sources found in the solution, categorized by the data access technologies. If needed, you can select a data access technology and create a new data source. Once the data source has been selected or created, you choose a data binding mode from a list (all list items have short descriptions and links to our online documentation). Finally, the third step allows you to customize Control and Data Source specific settings. After you click Finish, the wizard adds a data source component to the form, binds the control and generates all necessary code.

Visual Studio Template Gallery
Prior to 13.1, DevExpress offered numerous Project/Item Templates that were created over many release cycles. These templates could be found in various locations within Visual Studio. This release includes a fully consolidated DevExpress Template Gallery - the entry point for all Project/Item Templates. The Template Gallery provides a unified ay to use DevExpress templates, features powerful filtering and searching mechanisms and contains sample images and descriptions for each template, thus simplifying the way in which selections are made for individual projects. 13.1 also includes improvements to shipping templates and offers additional template options.

FormAssistant component:  This helper component is designed for first time users. When placed on the application form, it allows you to:

  • Convert between various form types (Form, XtraForm, RibbonForm)
  • Select a skin
  • Automatically initialize a skin engine to enable form skinning
  • Add the BonusSkins library to the project's References section
  • Specify basic form settings

Actionable On-Screen Analytics
The DevExpress WinForms Pivot Grid Control has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports so your application can efficiently address real-time business analysis needs. The fully customizable design of the Pivot Grid ensures that end-users can modify any layout visually in order to examine data from different/multiple perspectives.

OLAP Support and Asynchronous Data Processing
Microsoft Analysis Services (OLAP) data sources are fully supported by the WinForms Pivot Grid. When bound to this data source type, the Xtra Pivot Grid automatically delegates all data management and calculations to the server. Supported data providers include: OLEDB for OLAP, ADOMD.NET and XMLA.

Asynchronous Data Processing: When asynchronous data processing mode is enabled, your application stays responsive while the pivot grid performs necessary calculations.

Unbound Columns and Expression Editor: You can now create unbound fields and populate them with data as your needs dictate.

Drill-Down, Visualize, Print and Export

  • Data Drill-Down - With just a single line of code, you can allow your end-users to explore the data underlying all calculated cell values.
  • Charting - The Pivot Grid Control allows its contents to be visualized using the DevExpress Chart Control.
  • Print and Export Data - Instant Cross-Tab Reports in printed form, PDF, XLS, and numerous other file formats. Xtra Pivot Grid is not just for on-screen data analysis. With it, you can export data to numerous formats and render its contents to paper just like a traditional WYSIWYG report.

Group Values and Hierarchical Data Display

  • Group Values - Provides end-users with unique levels of detail for more flexible data analysis and reduces the amount of effort required to understand business trends by using summarized on-screen pivot table values.
  • Hierarchical Data Display - Field values are automatically arranged into a tree structure with expandable parents. When necessary, end-users are free to expand and collapse child groups in order to view information in a more summarized format.

Data Summaries and Sorting

  • Automatic and Manually Calculated Totals - The Pivot Grid offers two unique ways with which to display data summaries: an out-of-the-box solution that addresses most common business needs and a completely customizable solution to satisfy the requirements of your most demanding of users.
  • Sorting, Top or Bottom Numbers - The Pivot Grid makes data analysis more efficient by enabling a two-way approach to data navigation. End-users can locate data by a specific value or find a value by its data.

Built-in Filtering, Editing and Validation

  • End-User Data Filtering - With the Pivot Grid's built-in visual filtering option, your end-users can manipulate reports on the fly using an easy to understand data filter dialog.
  • Data Editing and Validation - The Pivot Grid allows end-users to perform 'what-if' analysis by editing summary values displayed in data cells.

Product Search

Enter search words:

Quick Links


Primary Category

Related Products

Related Categories

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Screenshot Gallery

Click for full screen preview

Screenshot of XtraPivotGrid Suite - .NET - 12.2.8 Screenshot of XtraPivotGrid Suite - .NET - 12.2.8 Screenshot of XtraPivotGrid Suite - .NET - 12.2.8 Screenshot of XtraPivotGrid Suite - .NET - 12.2.8 Screenshot of XtraPivotGrid Suite - .NET - 12.2.8
Award Award