A Report Writer Suite by Developer Express

Quickly Display Table Data into Fully Customizable Visual Reports
The XtraPivotGrid Suite is the first component library of its kind for the .NET WindowsForms platform that allows your end users to slice and dice data in a manner similar to that found in MS Excel®. It has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports - making your applications far more usable and more effective at addressing your customer’s real-time business analysis needs. And just as importantly, with the XtraPivotGrid, users can easily change a report's layout visually in order to examine data from different/multiple perspectives. The benefits of this are two-fold - first, you never again have to foresee all possible report scenarios your end-users might require (saving you time and increasing your productivity) and second, your users will not have to deal with hard to use and overly complex reporting tools to answer their business questions.

Control the Level of Detail
By default, the row and column axes contain each unique value in the source column. With the XtraPivotGrid, you can quickly simplify a report by merging values. For instance, you might have a report containing survey data in which the respondent's age represents an important characteristic. End-users may not want to browse through each and every unique age 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 for just the first few months. The axis can be customized in almost any fashion and the most common customizations need only a single property to be modified for its implementation!

Print and Render the XtraPivotGrid with Ease
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.

- Printing support is available via the XtraPrinting Library (must be purchased separately).
- Export to the XLS, XML, TXT, HTM and PDF.
- Multi-cell selection and data export via the clipboard.
- The XtraPivotGrid can be embedded into reports produced with the XtraReports Suite to create cross-tab reports.

Arrange Values Hierarchically - See Raw or Summarized Data in a Single Report
Businesses have unique requirements and no two entities will analyze information in the same exact way. Your end-users may want to analyze sales for each product or each product category. They may want to view yearly data or see more detailed data by viewing the data for each month in a year. Using traditional reporting/database tools, you would often be forced to create a myriad of different reports to deliver the appropriate solution to your customers - but that’s no longer the case with the XtraPivotGrid. Since the visual control offers your end-users total runtime customization flexibility, not a single report layout needs to be modified to view data at different detail levels. You simply place fields at lower detail levels on the column or row area. 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 Specified Totals
To improve the development experience, the XtraPivotGrid ensures your ability to deliver superior capabilities with minimal coding. 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.