XtraPivotGrid Suite - .NET - v2008 vol 2 - Sommario

di Developer Express - Tipo prodotto: Componente / .NET WinForms

Sommario

XtraPivotGrid Suite by Developer Express

Multi-Dimensional data analysis for .NET. The XtraPivotGrid Suite is a comprehensive data analysis, data mining, and visual reporting solution for WindowsForms applications. It was engineered from the ground up to provide a unique bridge between on-screen forms and printed reports. With it, your users can break down raw data in any manner they require using easy-to-understand Windows commands and instantly render the desired output to a printer. By incorporating the XtraPivotGrid in your application, you can deliver an almost endless array of reports - both on-screen and in printed form - without hassles or aggravation.

The XtraPivotGrid Suite is a comprehensive data analysis, data mining, and visual reporting solution for Windows Forms applications. With it, your users can break down raw data in any manner they require using easy-to-understand Windows commands and instantly render the desired output to a printer.

OLAP Data Source Support - Microsoft Analysis Services (OLAP) data sources are now fully supported by the XtraPivotGrid. If bound to such a data source, a pivot grid control delegates all data management and calculations to the server side. This feature greately increases your application's performance if you are dealing with a large dataset. In this case, it may take a long time for a client machine to reclaculate data. It is much faster to request server-side data recalculation and then simply display the downloaded result.

Quickly Display Table Data into Fully Customizable Visual Reports - The XtraPivotGrid Suite allows your end users to slice and dice data in a manner similar to that found in MS Excel®. It has the ability 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 important, 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.

Sort Data and Display Top Rows - Easily Access the Most Important Information - The PivotGridControl automatically sorts row and column values so you can easily locate required data. Comprehensive data analysis, however, 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. To allow for the latter approach, the PivotGridControl introduces a unique feature - sorting values by their corresponding grand totals. This means the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales. This of course is just the beginning to more effective and efficient data analysis. You can also specify the number of top rows that are displayed. So you can view a specific number of best-selling or worst-selling products for each year, month, customer, etc. You can concentrate on only the most important information and avoid being overload with a lot of surplus data.

Filter Data - Filter Out the Values Used to Calculate Summaries on the Fly - The goal was to radically simplify runtime data analysis and provide end-users with superior customization options. You will find that with its built-in visual filtering option, your end-users can manipulate reports on the fly using an easy to understand and familiar visual metaphor.

Hide unnecessary values in the axes. Yet another mechanism that allows end-users to focus only on the most important data

Filter the data against which calculations are based. To allow your end-users manage this capability visually, the PivotGridControl has a Filter Panel Region. This pane was specifically designed to contain fields that aren't currently used in the report, and when required, can be dropped onto the report to automatically alter the base data used in the calculations

Drill Down - Take a Look at the Data Behind a Summary - The XtraPivotGrid is designed to transform table data into a summarized report. At the same time, it allows you to do the reverse. 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, the advanced XtraGrid control or any other control designed for displaying table data. This feature brings complete data browsing flexibility within a single report - from different detail levels in a summarized report to the original raw data used to create the report itself. End-users are free to analyze every aspect and level of their data.

Visualize your data using the PivotGrid and the XtraCharts Suite - The XtraPivotGrid allows the data it displays to be visualized using the XtraCharts Suite. This is 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.

What’s new in XtraPivotGrid Suite v2008 vol 2?

Inplace Editing and Data Validation - With v2008 vol 2, the XtraPivotGrid introduces more flexibility for those requiring data editing. You can now embed individual XtraEditors within cells in order to initiate in-cell editing. The XtraPivotGrid's Editor API is pretty much the same as that found in the XtraGrid or other DevExpress data editing control. You simply assign an editor to a pivot grid field and this editor appears in corresponding cells. All data editing features, including advanced Data Validation are available to you. Due to the unique nature of the XtraPivotGrid control, you must handle a specially designed event to save your changes to the database. By introducing data editing within XtraPivotGrid cells, you can now visually enhance your "reports." For instance, on-screen reports can be easier to analyze if you embed progress bars into individual cells.

OLAP Support Enhancements -If an OLAP cube contains KPI (key performance indicator) information, the XtraPivotGrid can now automatically recognize it and display it in an appropriate format. If a bound cube has multiple localized versions, the XtraPivotGrid automatically fetches a version appropriate for the current client culture. If this automatic localization option does not meet your requirements, you can control the localization process manually.

Running Totals - With v2008 vol 2, end-users have extended freedom in report customization and thus data analysis. You can now enable Running totals for required fields or even allow users to determine which total calculation mechanism is most appropriate for their current data analysis task. What's great about Running Totals in an interactive control like the XtraPivotGrid is that total values depend upon the order of values and, at the same time, end-users can change that order by sorting, grouping or filtering. Thus, with Running Totals you don't get one more way to present data. With this feature, end-users can produce an endless array of reports they couldn't generate previously.

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.

PartNumbers: PC-516222-162721 516222-162721 PC-516222-162723 516222-162723

PurchaseOptions: XtraPivotGrid Suite v2008 vol 2 (V8.2.4) 1 Developer License - Includes one year subscription , XtraPivotGrid Suite v2008 vol 2 (V8.2.4) 1 Developer License - with Source Code - Includes one year subscription

Resources: Read the Developer Express License Agreement, Download the DXperience v2008 vol 2 (V8.2.4) for Visual Studio 2005/2008 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET WinForms

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: Business Components

Search Items: New Product Aug 05, New Product Sep 05

Keywords: Mining analyze analyse analysis　データ分析 On-Line Analytical OLAP analysis analyze analyse Grid Grids Table Tables DataGrid DataGrids Developer Express devexpress Enterprise Partner xtra pivot grid pivotgrid xtrapivot