ASP.NET Web Forms Pivot Client Control for slice and dice

Data binding

The ASP.NET Web Forms Pivot and OLAP browser provides extensive support to bind OLAP and pivot data sources.

• OLAP data sources - SSAS, Mondrian, ActivePivot, and Oracle.
• Pivot data sources - DataTable, DataView, DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List and ArrayList.

Axis element builder

The axis element builder is similar to the pivot table field list in Excel. You can create and manage the control with either multidimensional or pivot data sources. End users can drag fields and filter them at runtime to create reports.

Pivot and cube browser

• OLAP cube organizes its elements such as dimensions, hierarchies, measures, KPIs, and named sets, from the selected cube in a tree-like structure.
• For the pivot data source, fields are loaded in a tree-like structure.

Sorting

Order the column and row header text in ascending or descending order.

• Sorting example
• Sorting documentation

Member editor

The member editor dialog display members of the selected field in a tree-like structure. You can search those members, apply filters and order them in either ascending or descending order. Also, members can be paged when there are large amount of records bound to the control.

Number and date formatting

Number formatting and date formatting help to transform the appearance of the actual value for pivot charts and pivot grids. This is applicable only for pivot data sources.

Toolbar

The following options are available in the toolbar to perform reporting operations:

• Filtering: Filter the members based on the grand total of the specific measure.
• Sorting: Sort the headers based on the grand total of the specific measure.
• Chart types: Change the chart types at runtime.
• Full screen: View the pivot chart and pivot grid in the full screen of the device.
• Toggle axis: Toggle the fields in the row axis and column axis.
• MDX: Show the MDX query of the current report.

NOTE: Filtering and sorting are supported only in OLAP server mode.

Report manipulation

• New: To create a new report collection.
• Add: Add a new report to the current report collection.
• Rename: Individual report names can be modified in the current report collection.
• Remove: Individual reports can be removed from the current report collection.

Save and load reports

You can save reports from the current session as a stream in a database for later use. UI support provided for save, save as, rename, delete, and load report operations from database:

• Save: Current report collection can be saves in the database.
• Save AS: Existing report collection can be resaved with a different name in the database.
• Load: Any of the saved reports collection can be retrieved back from the database.
• Remove: Any of the saved reports collection can be removed from the database.
• Rename: Any of the saved reports collection can be renamed in the database.

Layout customization

Render the control in different layouts with the help of built-in properties:

• Customize the control’s size through the API.
• Display either a pivot grid or pivot chart as the default view during initial loading.
• Display either pivot chart or pivot grid alone.
• Collapse view support for pivot or cube browser
• Place control in either tab or tile view.

Exporting

You can export a pivot table or pivot chart to Excel, Word, or PDF documents.

• Exporting example
• Exporting documentation

Web accessibility

Our ASP.NET Web Forms Pivot and OLAP browser has been developed to make it possible for people with disabilities to use and interact with the control.

Cross-browser and cross-platform

The ASP.NET Web Forms Pivot and OLAP browser will work on all major browsers across Windows and macOS. It is written in jQuery to provide the same working experience on popular browser like Chrome 17+, Firefox 22+, and Internet Explorer 8+. It also works with platforms like ASP.NET MVC and ASP.NET Core.