Use any declarative data source control (AccessDataSource, SqlDataSource, LinqDataSource, EntityDataSource, ObjectDataSource, XmlDataSource), or bind the Excel-like pivot table for ASP.NET to your custom objects on the fly. You can also bind RadPivotGrid programmatically by leveraging the NeedDataSource event fired only when the control needs to get fresh data instead of upon every postback. In addition to data grouping by a simple type, such as string or int, the advanced ASP.NET pivot table control allows you to group data by custom objects.
With RadPivotGrid for ASP.NET AJAX you enable users to see data from different perspectives by filtering, sorting, showing or hiding certain information or changing the row, column and filter fields. They can achieve this via:
Enable RadPivotGrid pagination for it to load only a portion of the data at once, for better performance. Define the page size and pager position which will best suit your end user experience. Choose between the built-in numeric, previous and next, slider or more advanced paging modes.
Enable calculations to allow users to further analyze the aggregated data by comparing cells to each other. For each cell they will be able to compute the percentage of the GrandTotal, compute the difference from its previous or next one, calculate its weighted average, etc., thus discovering its relative importance.
Allow your users to choose the details with which they want to examine data. Group multiple row or column fields to allow users to expand and collapse the parent groups and achieve the desired detail level.
If you need to define your own templates instead of using the built-in cell elements of the Telerik ASP.NET PivotGrid, you can easily define exactly what to be displayed in a certain cell. The control has12 different cell templates allowing you to customize each of its parts and even place other controls into the different types of cells.
Take advantage of the public methods, properties, and events found within our ASP.NET OLAP control in order to implement advanced and specific scenarios, such as integrating it with a Chart or Map control. Almost all user actions raise an event which provides all the arguments you need, both on the client and the server.
To make sure RadPivotGrid performs well, we:
Why should you build a mobile version of your application when the same app can work equally well on mobile and desktop devices? The Telerik ASP.NET PivotGrid makes this possible by handling touch events in the same manner as those triggered by a keyboard or a mouse. In addition, the control comes with a mobile skin especially designed for a better user experience on touch devices.
Try UI for ASP.NET AJAX with dedicated technical support.
See the UI for ASP.NET AJAX in action and check how much it can do out-of-the-box.
Check out the offers. Purchase an individual suite or treat yourself to one of our bundles.