English | 日本語
When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table control provides business users unrivaled insights into daily operations. Until the release of the XtraPivotGrid for .NET, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions within managed applications.
The XtraPivotGrid Suite was engineered from the ground-up to blow away the limitations posed not just by these out-of-process solutions, but to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the XtraPivotGrid is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. It delivers numerous layout customization options with total end-user control over each individual on-screen report. Regardless of the perspective, data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.
At Developer Express we know that your time is valuable and our goal has always been to deliver products that address your business needs, increase your productivity and offer the "wow" factor that helps you obtain loyal users for years to come. The XtraPivotGrid demonstrates our commitment to these principles by offering developers like you a nearly endless set of options to dissect data yet do so in an elegant and efficient manner.
- Quickly Display Table Data into Fully Customizable Slice-and-Dice Reports
Our Pivot Grid Control has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports, thus addressing your customer's real-time business analysis needs. And just as important, users can easily change a report's layout visually in order to examine data from different/multiple perspectives so you never again have to foresee all possible report scenarios your end-users might require.
- OLAP Data Source Support
Microsoft Analysis Services (OLAP) data sources are now fully supported by our hypercube control. If bound to such a data source, a pivot grid delegates all data management and calculations to the server side.
- Print and Export Data - Instant Cross-tab Reports in PDF, XLS, HTML Formats and on Paper
The XtraPivotGrid is NOT just about 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.
- Data Visualization via Charting Control Integration
DevExpress pivot grid allows the data it displays to be visualized using our .NET Charting Control. This is possible because the PivotGrid can act as a data source for other controls.
- Provide Different Levels of Detail for Flexible Data Analysis
End-users may not want to browse through each and every unique respondent age value and instead want to see the ages of respondents in intervals such as 21-30, 31-40, etc. Instead of viewing sales by each unique date, they may want to view the sales against months.
- Hierarchical Data Display - Raw and Summarized Data in a Single Report
Field values are automatically arranged into a tree structure with expandable parents. End-users are free to expand and collapse child groups to see more summarized or raw reports.
- Automatic and Manually Calculated Totals
Among the many features available in the component library is its ability to display grand totals for each row and column automatically. On the rare occasion that the built-in summary computation engine does not address a specific business requirement, you can display any number of totals for any value group.
- Sort Data and Display Top or Bottom Numbers - Easily Access the Most Important Information
Comprehensive data analysis often requires a two-way approach to data navigation in that you may need to find data by a specific value or find a value by its data. This means that sometimes you need the first product to be the one with the most or least sales, rather than the one which starts with an A or Z.
- 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 and familiar visual metaphor.
- Drill Down - Take a Look at the Data Behind a Summary
With just a single line of code, you can take a look at the records that were used to calculate cell values. With a few more lines of code, you can display this data within a standard DataGrid control, our advanced WinForms Grid control or any other control designed for displaying table data.
Like all Developer Express .NET components, source code is available and your purchase is backed by a 60 day no questions asked money back guarantee.