Features and Benefits
You can bind JSON data to the control to work smoothly within applications. The JSON data can be obtained from a local file, remote file, or web service.
You can also bind CSV data to the control. The CSV data can be obtained from a local file, remote file, or web service.
OLAP data binding
Remote data binding
Optimized for mobile devices
All features will work on touch devices with ease. Features such as drilling up, drilling down, filtering, sorting, and report manipulation can be done on the fly.
Adaptable field list UI
The Pivot Table field list can be displayed on various devices in a presentable manner.
Pivot Table field list and group fields
Drill down and drill up
Provides built-in drill-down (expand) and drill-up (collapse) capabilities to visualize data in detailed views and abstract views, respectively. By default, the data is displayed in a grouped manner.
Defer layout update
Users can refresh the control on demand instead of during every UI interaction in the Pivot Table.
Defer layout update documentation
Editing and updating
Users can perform create, read, update, and delete operations for raw data at runtime and update their changes to the underlying data source, thereby reflecting the information in all corresponding cells. The control supports various edit modes such as inline, dialog, batch edit, and column edit through an interactive UI.
Editing and updating documentation
Built-in member function and Excel-like filters with advanced filtering options can be used to easily filter and view data as required. It is also possible to filter data programmatically in the Pivot Table.
Header filtering displays only selected values for a field. This can be achieved either through the UI or programmatically.
Normal filtering documentation
Use Excel-like filtering options across column and row headers based on label text, date, or number.
Use Excel-like filtering options across column and row headers based on grand-total values.
Order column and row header text either in ascending or descending order.
Column sorting, also known as value sorting, orders the column values either in ascending or descending order. It is performed by clicking the header of the column you wish to sort.
Users can perform calculations on a group of values using the aggregation option. By default, values are added together. The other aggregation types are average, minimum, maximum, count, distinct count, product, index, population standard deviation, sample standard deviation, population variance, sample variance, running totals, difference from, percent of difference from, and percent of grand total.
Calculated fields, otherwise known as unbound fields, generate unique fields with your own calculated values by executing a simple user-defined formula.
The drill-through feature easily obtains a list of raw items for a particular value cell or summary cell.
Subtotals and grand totals are calculated automatically by the pivot engine inside the control and displayed in the Pivot Table to help users make decisions more quickly. Also, users can show or hide subtotals and grand totals for rows and columns.
Show or hide totals documentation
Conditional formatting allows users to define conditions that, when met, format font style, text color, background color, and font size for values and summary cells.
Conditional formatting documentation
Number formatting and date formatting
Number formatting and date formatting help transform the appearance of the actual cell value.
Format settings in API documentation
Group dates and numbers
Grouping date and number documentation
You can freeze row and column headers to compare cell values with the corresponding row and column headers.
Columns and rows
Resizing allows changing column width at runtime by simply dragging the rightmost boundary of the column header. A scroll bar will appear when the content width exceeds the control width.
You can reorder columns either on user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns.
Users can retrieve information about a particular cell on clicking a hyperlink cell. It later allows them to perform custom operations programmatically.
Select a range of cells.
With cell templates, users can add features like images, check boxes, and text nodes to any cell with ease.
The Toolbar feature provides a built-in interface to select frequently used features interactively. These features include new report, save report, save as report, rename report, delete report, report list, show grid, show chart, show or hide totals, export reports, and more.
Custom styles and themes
Ships with a set of four stunning, built-in themes: Material, Fabric, Bootstrap, and high contrast.
You can customize the appearance of the control as little or as much as you like programmatically.
Globalization and localization
Globalization enables users from different locales to use the control by formatting the date, currency, and numbering to suit locale preferences. This uses an internalization (i18n) library for handling value formatting.
Right to left (RTL)
Supports right-to-left rendering and allows the text direction and layout of the control to be displayed from right to left.
You can localize all the control’s strings in the user interface as needed and use the localization (l10n) library to do so.
Web framework integration
Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 29,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.
email@example.com | www.syncfusion.com | Toll Free: 1-888-9 DOTNET