Blazor Pivot Table Example - Toolbar
Grand Total |
|---|
Grand Total | No records to display |
This sample demonstrates the comprehensive toolbar options available in the pivot table, including report manipulations, formatting options, and export functionality for both pivot tables and pivot charts.
Users can generate reports at runtime and manage them using save, load, rename, and delete operations. Save and load operations are performed in local variables using the SaveReport and LoadReport events. Users can dynamically switch between pivot table and pivot chart views using toolbar options.
To enable the toolbar, set the ShowToolbar property in SfPivotView to true. The available toolbar options include:
| Create New Report | Allows users to create new reports at runtime. |
| Rename Report | Allows users to change the current report name dynamically through the UI. |
| Remove Report | Allows users to remove the current report from the report collection at runtime. |
| Save As Option | Allows users to save reports locally in browser memory. |
| Report List | Allows users to swap between reports within the report collection. |
| Pivot Table | Allows users to view data in cross-tabulation format. |
| Pivot Chart and Its Types | Allows users to view data in graphical format. Chart types include column, bar, line, area, and more. Options are available for showing/hiding legends and displaying chart series on single and multiple axes. |
| Export | Allows users to save data in PDF, Excel, and CSV document formats. |
| Hide Subtotals and Grand Totals | Allows users to hide grand totals and subtotals based on fields in rows and columns. |
| Conditional Formatting | Allows users to customize cells based on specific conditions. |
| Number Formatting | Allows users to dynamically apply number formatting to value fields. |
| Field List | Allows users to alter the report dynamically through the UI. |
To define toolbar options, create a list with the necessary ToolbarItems enumeration values and add it to the Toolbar property in SfPivotView.
For detailed information about the toolbar feature and customization options, refer to the toolbar documentation.