Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

ASPxPivotGrid by DevExpress (Developer Express)

URLs: aspxpivotgrid, devexpress

Add data mining and multi-dimensional analysis to your ASP.NET applications. ASPxPivotGrid Suite is a comprehensive data analysis, data mining, and visual reporting solution for ASP.NET 2. With ASPxPivotGrid, your users can break down raw data in any manner they require using easy-to-understand Windows commands. By incorporating the ASPxPivotGrid in your application, you can deliver an almost endless array of reports. ASPxPivotGrid is able to slice and dice information efficiently and provide customers with an intuitive end-user experience. ASPxPivotGrid delivers numerous layout customization options with total end-user control over each individual on-screen report. ASPxPivotGrid Subscription with Source code Licenses available.

OLAP Data Source Support

Microsoft Analysis Services (OLAP) data sources are now fully supported by the ASPxPivotGrid. If bound to such a data source, a pivot grid control delegates all data management and calculations to the server side. This feature greatly increases your application's performance if you are dealing with a large dataset. In this case, the entire dataset will have to be reloaded with each control update. 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 ASPxPivotGrid Suite is a component library for ASP.NET 2 that allows your end users to slice and dice data in a manner similar to that found in MS Excel. It can 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 ASPxPivotGrid, 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 ASPxPivotGrid, 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.

Arrange Values Hierarchically - See Raw or Summarized Data in a Single Report

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

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 ASPxPivotGrid 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 ASPxPivotGrid 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

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 - Another mechanism that allows end-users to focus only on the most important data

Filter the data against which calculations are based - Allow your end-users manage this capability visually, the ASPxPivotGrid 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

What's new in ASPxPivotGrid Suite v2011 vol 1?

Export Performance Boost - With this release, DevExpress have significantly improved print and export performance - between 75 to 95% when compared to previous versions. Note that the more rows there are in a Pivot Grid, the greater performance boost you will get.

Enhanced Layout Serialization - With this release, DevExpress have improved the layout serialization capabilities of the ASP.NET Pivot Grid control. You are now able to save the pivot grid's layout to a stream or a string, and also specify which layout options should be persisted (much like its WinForms counterpart). We have also implemented new events that allow you to respond to a layout update and to cancel layout changes after it has been loaded.

Sort by Summary Default Order - You can now specify a default sort order when using the Sorting by Summaries feature. Field values are automatically arranged in this order when sorting by summaries is enabled for a field.

Unbound Fields - Unbound field values use up to 4 times less memory as compared to older versions. Exact savings depends upon the unbound field's data type.

Collapsed States - DevExpress have reduced the amount of memory consumed by the collapsed states of field values when they are serialized. The actual savings depends upon the number of collapsed and expanded field values in the layout. The key benefit of this enhancement is that the ASPxPivotGrid sends less data to the server on callbacks.

What's new in ASPxPivotGrid Suite v2010 vol 2?

Filtering and Sorting in the Customization Form - Field headers displayed in the Customization Form now display sort glyphs and filter buttons to allow data shaping operations directly from the Field List.

MS Excel Style Customization Form - With this release, a Microsoft Excel style Customization Form can be used within the ASP.NET Pivot Control. This form allows end-users to hide, restore and reorder fields, drag them between areas and sort/filter data against specific fields.

Adding and Removing Filter Items - By default, filter drop-downs display unique values from the underlying data field. In DXperience v2010 vol 2, we have introduced two new events allowing you to manage these drop-down lists. With these events, you can add or remove items, edit their captions and change their checked state.

Limiting the Number of Series and Points in a Chart Data Source - With this release, DevExpress have added the ability to limit the number of series in the data source passed to the Chart Control, as well as the number of points in a series.

Disabling Specific Customization Form Layouts - You can now specify which Customization Form layouts are available to end-users via the Layout menu.

What's new in ASPxPivotGrid Suite v2010 vol 1?

Full Support for Visual Studio 2010 and .NET Framework Client Profile

What’s new in ASPxPivotGrid Suite v2009 vol 3?

Disable Sorting in OLAP Mode - By default, Pivot Grid controls automatically sort field values (row and column headers) in either ascending or descending order. This can be replicated functionality when working with OLAP cubes since they can define their own value order. To handle these instances, our Pivot Grid controls allow you to disable header value sorting thus keeping the value sequence defined by the data source.

Improved Memory Utilization - Previously, our Pivot Grid controls loaded the entire underlying dataset into the memory, regardless of which data needed to be displayed on screen. With this release, only the visible field data is being loaded which dramatically decreases memory consumption, especially for data sources with a large number of data fields (properties).

What’s new in ASPxPivotGrid Suite v2009 vol 2?

Hot-tracked Style for Data Rows - You can now simplify grid row handling by enabling a hot-tracked style for grid rows. You can specify the desired style settings via grid properties or CSS and the grid will clearly indicate the row under the mouse pointer. This is particularly useful if you provide context menus for data row or perform other actions in response to row clicks.

What’s new in ASPxPivotGrid Suite v2009 vol 1?

Advanced Filter Editor - Extended the ability to build complex filter expressions in the pivot grid. Your end-users can take advantage of the pivot grid's embedded filter editor – Prefilter – and construct complex filter criteria with an unlimited number of filter conditions combined with any logical operator. Also added the ability to replace the default text that represents the currently applied filter expression with a custom description (by handling the specially designed server-side event).

Improved Row Header Alignment - Field headers displayed within the Row Header Area are now aligned to the corresponding field values.

What’s new in ASPxPivotGrid 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 ASPxPivotGrid Suite v2008 vol 2?

Useful Classes for Client-Side Scripting - a new ASPxClientUtils class allowing you to easily perform typical client-side actions, including the following:

Determine web browser type

Work with arrays

Access an object's parent or child object

Obtain event parameters

Easily Transmit Data onto the Client -All DevExpress AJAX-enabled controls allow you to use callbacks to easily exchange data with the web server. Controls expose a JSProperties property, which allows you to declare custom properties for the client control. You can specify these property values on the server and then access them on the client...as you would with built-in properties.

Enabling/Disabling Controls and Control Elements on the Client Side - Previously, enabling or disabling a control or a particular control element required a round trip to the server. In v2008 vol 2 the ASPxEditors and ASPxperience Libraries allow you to change their enabled state or the state of their elements (e.g., tabs and menu items) on the client side, to reduce the number of round trips and increase web site responsiveness.

Distinguishing Between Callbacks and Postbacks - A new server-side IsCallback property has been added to our web controls. This property enables you to determine whether a control is taking part in callback processing.

What’s new in ASPxPivotGrid Suite v2008 vol 1?

Data Shaping Improvements

Group Values Manually - New Custom Group Intervals feature. With it, you can easily group axis values using your own criteria. Simply handle a specially designed event to compare values and determine whether they need to be within the same group.

Keep Fields Together -Fields can now be grouped so that they are always kept together. This allows you, for instance, to move several fields simultaneously by dragging a single field from a group. Another advantage is the ability to easily show or hide fields using expand buttons in column headers.

OLAP Enhancements - You can now obtain the records that were used to calculate a particular summary. Only a single line of code is required to achieve this objective.

Data Exchange Enhancements

Printing - The ASPxPivotGrid can be printed in both portrait and landscape mode.

Export - In v2008 vol 1 we've implemented new methods that allow you to provide custom names for exported worksheets.

Header Area Visibility - In v2008 vol 1 the ASPxPivotGrid provides new options that control header area visibility. For instance, this allows you to hide column field headers, as shown below. As a result, end-users won't be able to change column header data.

What's new in ASPxPivotGrid Suite v2007?

Complete Callback Support -The ASPxPivotGrid now uses callbacks for all operations, except for those that are done directly on the client side. You can of course continue to use postbacks instead of callbacks - simply toggle a single property.

Embedded Pager - If you are working with large datasets, you can now dramatically increase your application usability by exploiting the PivotGrid's embedded pager. The grid's content will be automatically split across multiple pages based upon a specified page size. The pager can be displayed above, below or on both sides of the grid. You have full control over the embedded pager's appearance and behavior.

Add data mining and multi-dimensional analysis to your ASP.NET applications.

Pricing: ASPxPivotGrid Subscription Renewal for one year (for Subscriptions soon to expire or just expired), ASPxPivotGrid Subscription Renewal for one year (for Subscriptions soon to expire or just expired) - with Source code

Evals & Downloads: Read the Developer Express License Agreement - Requires Acrobat Reader, Read the ASPxPivotGrid help file, Download the DXperience v2011 vol 2 (V11.2.11) evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: ASP.NET WebForms, ASP.NET AJAX (ATLAS), .NET Class, 100% Managed Code, AJAX

Built Using: Visual C# .NET

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

Product Class: User Interface Components

Keywords: aspxxpivotgrid, devexpress pivot, devexpress pivot grid, devexpress pivotgrid, devexpress olap, aspx pivot grid, aspxpivot, developer express pivot, aspxpivotgrid suite, aspxpivotgrid subscription, aspxpivotgrid subscription with source, aspxpivotgrid , aspxxpivotgrid upgrade, buy aspxxpivotgrid, aspxxpivotgrid renewal

devexpress, developer express, dxperience, devexpress.com, devexpress controls, devexpress download, www.devexpress.com, devexpress dxperience, devexpress suite, devexpress components, devexpress tools, devexpress universal, devexpress upgrade

On-Line Analytical OLAP analysis analyze analyse

datagrid controls, datatable controls, datagrid components, datatable components, datagrid, data grid, data table, net gridview, net datagrid, data grid, grid control, net datatable, c# gridview, c# datagrid, asp.net datagrid, grid asp, vb.net datagrid

Mining analyze analyse analysis　データ分析

Part numbers: PC-517685-379120 517685-379120 PC-517685-379122 517685-379122