A comprehensive feature-rich control designed specifically for the .NET Framework the ASPxPivotGrid gives you the maximum capabilities for organizing, summarizing and analyzing your business data.

Below is a list of the main features of the ASPxPivotGrid control.

An Extremely Easy Way to Create Cross-Tab ReportsThis report type is one of the most effective ways to analyze data. Instead of browsing tons of individual records, you can slice and dice the data in any manner you need. As a result, you get a compact report that allows you to easily compare the desired values and to analyze trends. End-user Report CustomizationEnd-users have a total freedom in report layout customization. They can achieve any level of detail and view data from any perspective by simply dragging field headers. Data Filtering is Fully SupportedThe ASPxPivotGrid offers you the same data filtering UI as you would find in Microsoft Excel or Microsoft Access applications. End-users can click filter buttons within field headers to invoke filter check lists. In these lists, they can uncheck any values they want to be filtered out, i.e. those values that will be ignored in calculations. Customizable Value Detail LevelThe ASPxPivotGrid offers you several predefined value grouping algorithms so that you can achieve the desired level of detail. For instance, you can group string values alphabetically or group date-time values by months. This can make it easier to browse data and analyze trends from a more general perspective. Hierarchical Value DisplayYou can have multiple fields in column and row areas to create nested groups of values. In such cases, end-users will be able to collapse and expand parent groups thus controlling the report’s detail level. Summary Variation DisplayIf you are interested in how a particular value changes with time, rather than the value in each particular time period, the summary variation feature will be useful for you. If enabled, data cells display the differences between neighboring cells. You can display either absolute or percent difference values. Sort Data By SummaryValues displayed in row and column headers can be sorted by the corresponding summary values. For instance, you may sort trademarks by the corresponding sales amount. In most cases, this makes a report much more informative. Display Top ValuesThis feature is particularly useful if you sort data by summary. In this case, you can display only a few best or worst values. If a hierarchical display is used, you can show a few best or worst values in each category. This allows you to concentrate on the most important data and make reports much more compact as a result. Automatic and Manual TotalsThe ASPxPivotGrid can display grand totals – rows and columns that sum up data from all the available data cells. You can also enable group totals to display a summary for each group of values (category). Cross-Browser CompatibilityWith our controls, you won't depend on operating systems or on a particular web browser. We currently support the following browsers: Internet Explorer 5.5+, Mozilla, Mozilla Firefox, Netscape 7.2+, Opera 8+, Safari. Appearance CustomizationThe ASPxPivotGrid control fully supports style properties so that you can customize the appearance of individual elements and manage the overall appearance of the ASPxPivotGrid control. In addition, The ASPxPivotGrid ships with a number of predefined auto-formats / presets. These presets allow you to specify the control’s appearance and behavior as your business needs dictate. AJAX SupportThe ASPxPivotGrid control gives you the ability to update control content using callbacks - thus eliminating the need to re-load the entire page.

Loading…