de DevExpress (Developer Express) - Tipo de producto: Componente / .NET WinForms
Add a customizable WinForms .NET Pivot Grid to your application with Xtra Pivot Grid. 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 DevExpress PivotGrid for .NET, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions within managed applications. The Xtra Pivot Grid Suite was engineered from the ground-up to eliminate the limitations imposed by these 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 Suite v2011 vol 1?
What's new in XtraPivotGrid Suite v2010 vol 2?
What's new in XtraPivotGrid Suite v2010 vol 1?
What’s new in XtraPivotGrid Suite v2009 vol 3?
What’s new in XtraPivotGrid Suite v2009 vol 2?
Excel 2007 Style Customization Window - The XtraPivotGrid's customization window now has a new operation mode that mimics the appearance and behavior of Microsoft Excel 2007 Pivot Tables.
New Capabilities of Filter Dropdowns - This release extends the Pivot Grid's filter dropdowns with the following new features:
Suppressing Empty Columns When Displaying Trends - When displaying trends (summary variations), the first column or row in each group is always empty because there are no preceding values to calculate the difference. You can now suppress these empty cells by toggling a single option.
Common Changes Across Multiple WinForms Components
Seven New Skinning Options for Windows Forms Controls – DevExpress have introduced 7 new professional Skins/Themes in DXperience v2009 vol 2.
Expression Editor Now Available in Grids - In previous versions, the only way to specify unbound column values was to handle an event and write the appropriate code. The same applied if you needed conditional formatting driven from complex criteria. With this new release, DevExpress WinForms controls now allow you to address both these requirements using an intuitive design-time editor. An updated version of the DevExpress Expression Editor (the first version was introduced in XtraReports v2008 vol 2) is now available to the main WinForms Grid controls. You can use it to specify formulas for unbound column values or to set up conditional formatting. The DevExpress controls that support this new feature are the XtraGrid and XtraPivotGrid. For unbound columns, you can also enable the end-user customization of expressions. Simply enable an appropriate option and the column's header menu will include a link to the Expression Editor.
New Functions - Not only have DevExpress shared the Expression Editor between the main WinForms Grid controls, DevExpress have also extended the supported function set with about 50 new functions. These include the following:
What’s new in XtraPivotGrid Suite v2009 vol 1?
Improved Data Editing Functionality - You can specify when editor buttons should be displayed in data cells. They can be visible for all cells, for the focused cell or when entering edit mode. Different editors can be assigned to cells corresponding to the same field. Note that different editors can be used for edit and browsing modes. Keyboard activation of cell editors is now possible. You can now specify individual column width. Several events and event parameters have been added making it easier for you to control changes to cell values.
What’s new in XtraPivotGrid Suite v2008 vol 3?
Improved Sorting by Summary - Sorting by summary is a very powerful data analysis feature that makes it easy to locate the best or worst performance indicators. Previously, DevExpress OLAP controls had a limitation in this area - you could only sort data by grand totals. There was also no built-in end-user UI, so you needed to write code to make this feature available to end-users. With v2008 vol 3, you can sort field values against any data column or row. You can further specify the desired sort order in code or use the built-in UI elements to offer sorting options to end-users.
What’s new in XtraPivotGrid Suite v2008 vol 2?
What’s new in XtraPivotGrid Suite v2008 vol 1?
Custom Group Intervals - XtraPivotGrid now supports a grouping feature wherein all records with unique values are grouped into a single row or column. In addition to joining identical values into groups, you can also use predefined grouping intervals - e.g. months, years, etc. In version v2008 vol 1, the control provides you with even more flexibility. By handling a specially designed event, you can easily define custom group intervals.
Custom Totals in OLAP Mode - For column and row fields, the XtraPivotGrid control allows you to calculate custom totals. You can now define custom totals and the control will calculate them on the client side.
Drill-Down Functionality in OLAP Mode - XtraPivotGrid now publishes methods allowing you to access data that was used to calculate summaries within a particular cell.
Printing in Both Portrait and Landscape Mode - It's now easier to customize printed page settings, as the XtraPivotGrid control introduces properties to change paper size, orientation and margin.
What's New in XtraPivotGrid Suite v2007 vol. 3?
Select Multiple Cell Blocks - When this mode is enabled, end-users can select multiple cell blocks by clicking cells while pressing the CTRL button.
Report Interactivity Improvements - End-users can now specify the functions to be used to calculate cell values - which reduces the amount of work on your end, since you need only to populate the control with the desired fields. End-users will be able to create any report with just a few mouse clicks.
Advanced Filter Editor Dialog - A new filter editor - Prefilter - allows your end-users to build complex filter criteria with an unlimited number of filter conditions combined by any logical operators. The resulting filter condition is combined with filter conditions defined by individual fields. Previously, end-users could only apply a filter by selecting/deselecting field values using check boxes and as such, it was quite hard to filter out numeric or date-time values that fell within a specified range. With the new filter dialog, however, these tasks are now simple and straightforward - just a matter of specifying a couple of filter conditions.
XtraSpellChecker - RichTextBox Is Now Supported. In addition to all previously supported controls (standard TextBox, Developer Express TextEdit and MemoEdit), you can now use the spell checker with the standard RichTextBox.
Improved Performance against Large Text Fields - The XtraSpellChecker's performance no longer varies based upon the size of text within the target control. The spell checker only considers the currently visible text, which significantly improves performance against large text fields.
What's New in XtraPivotGrid Suite v2007 vol. 2?
Visualize your data using the PivotGrid and the XtraCharts Suite - The XtraPivotGrid now allows the data it displays to be visualized using the XtraCharts Suite. This is now possible because the PivotGrid can act as a data source for other controls. When used in this manner, it provides data from the current selection. Since IBindingList is supported, bound controls are automatically updated when cell selection changes. The pivot grid returns data in a form that is easily consumed by the XtraCharts Suite. This means that there are three fields and these fields hold series names, arguments and values. Thus, you can simply bind an XtraChart to an XtraPivotGrid, map three fields to the appropriate properties and run the application. The pivot grid's current selection will be automatically visualized by the bound chart.
Easy Row and Column Selection - End-users can now select a row or a column by simply clicking the corresponding header. Multiple row/column selection has also been made easier. End-users can simply press a header and then drag the mouse pointer to extend selection.
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
Group Values and Hierarchical Data Display
Data Summaries and Sorting
Built-in Filtering, Editing and Validation
DevExpress (Developer Express)