Process and aggregate thousands of rows in milliseconds

Create Excel-like, web-based pivot tables in ASP.NET MVC with ComponentOne Studio's OLAP control. The smart pivot panel interprets data types and intelligently places fields in an intuitive, modern UI.

*Available only in ComponentOne Studio Enterprise and Ultimate.

Drag and drop pivot fields in the smart PivotPanel

  • Excel-like panel design feels familiar to users
  • Allow users to drag fields into "view" lists representing row, column, value, and filter
  • Save time with smart data interpretation — the panel intelligently places fields
  • Use same field multiple times in Values, e.g.: Sales (total) and Sales (count)
  • Asynchronous processing provides progress bar and background work
  • Save user's time with built-in save/load of views

Display Excel-like data summaries in PivotGrid

  • Manage large data sets with collapsible rows and column groups
  • Drill down into the data with the custom context menu
  • Extend your grid's formatting with the logical grouping for multiple date types
  • Group and manage data with subtotals
  • Export the grid to XLSX files. Read more about Excel export

Visualize aggregated data with PivotChart

  • Summarize data in multiple chart types, like column, bar, area, scatter, and pie
  • Convey the view structure with hierarchical axes
  • Contains both FlexChart and FlexPie and inherits from those ComponentOne Studio controls

Analyze large data sets and cubes

With the ComponentOne Studio Web API's DataEngine component, you can analyze and handle up to hundreds of millions of records in a fraction of a second.

You can use multiple data sources, including:

  • SQL server
  • SQL-based RDMS servers
  • NOSQL
  • Web service
  • Structured files from file and network systems

Read more about DataEngine Web API