Blazor Pivot Table Documentation Overview

Introduction to Syncfusion Blazor Pivot Table

The Blazor Pivot Table is a powerful and feature-rich UI component designed for summarizing, reorganizing, analyzing, and presenting complex multi dimensional datasets in an interactive cross tabular format. Built for enterprise data intelligence, it transforms flat and relational records into dynamic pivot reports with full support for drill-down, drill-through, grouping, calculated fields, filtering, sorting, and conditional formatting.

Common use cases

The Blazor Pivot Table is ideal for a wide range of business intelligence, analytics, and reporting scenarios:

Use Case Description Key Features
Financial Reporting Summarize income statements, balance sheets, profit & loss, and operational budgets across fiscal years and accounting cost centers Aggregation, Calculated Fields, Formatting, Conditional Formatting
Sales & Revenue Analysis Cross-tabulate sales metrics by region, sales representative, product line, customer segment, and temporal periods Grouping Bar, Field List, Filtering, Sorting
Supply Chain & Inventory Monitor warehouse inventory levels, stock reorder points, shipping lead times, and supplier performance across distribution hubs Drill-Down, Drill-Through, Data Compression, Virtual Scrolling
Healthcare & Clinical Statistics Analyze patient demographics, diagnostic treatment outcomes, clinical trial metrics, hospital bed occupancy, and billing records Custom Grouping, Label & Value Filtering, PDF Export
Human Resources & Workforce Report on headcount, employee turnover, department payroll distributions, compensation benchmarks, and performance ratings Custom Aggregation, Batch Editing, Paging, Toolbar
Executive Dashboards & BI Build interactive enterprise portals allowing executives to switch between tabular summaries and analytical charts on the fly Pivot Chart, Built-in Toolbar, Smart Pivot Table, Report Persistence

Data connectivity

The Blazor Pivot Table enables multiple data binding approaches, offering flexibility in choosing the right strategy for different application architectures. It can work with in-memory collections, connect to remote services for scalable applications, bind to enterprise OLAP cubes, or offload processing to high-performance server side engines.

Data binding approaches

  • In-Memory Data - Bind pivot tables directly to local C# collections, List<T>, IEnumerable<T>, and ObservableCollection for instant client-side data binding without external dependencies.
  • JSON & CSV Data - Ingest raw data in both standard JSON object arrays and lightweight CSV text payloads for optimized bandwidth utilization.
  • Remote Data Sources - Connect to web services, REST APIs, and remote endpoints through Syncfusion DataManager with automatic request handling and response parsing.
  • OLAP Cubes - Connect natively to Microsoft SQL Server Analysis Services (SSAS) multi dimensional cubes and tabular models using XMLA protocols, honoring cube dimensions, measures, KPIs, named sets, and hierarchies.
  • Server-Side Pivot Engine - Offload multi dimensional calculations, aggregations, and layout operations to a dedicated ASP.NET Core server side engine to handle massive enterprise datasets containing tens of millions of records.

Database compatibility

The Blazor Pivot Table integrates seamlessly with various relational and modern database systems:

Database Key Benefit Best For
Microsoft SQL Server Enterprise ADO.NET and EF Core connectivity Enterprise applications, complex financial queries
MySQL Cross platform relational connectivity Web applications, open source stacks
PostgreSQL Advanced relational features and JSON querying Large scale analytical applications
SQLite Server Lightweight file based embedded storage Desktop apps, mobile apps, local storage
Oracle High throughput enterprise data warehousing Mission critical financial and ERP systems
Snowflake Cloud data warehouse with elastic scalability Massive cloud data analytics

Modern databases & Cloud platforms

Connect your pivot table application to modern cloud data platforms and real time stores:

Platform Key Benefit Best For
MongoDB Flexible document-oriented JSON storage Dynamic schemas, unstructured transactional data
Firebase Firestore Real time cloud synchronization Mobile apps, real time web applications
Firebase Realtime DB Low-latency live database updates Collaborative dashboards, live trackers
Elasticsearch Distributed full text search and analytical aggregations Log analytics, large scale search datasets

ORM & backend service integration

Seamlessly integrate with ORM frameworks and real time backend services:

Technology Key Benefit Use Case
Entity Framework Direct integration with EF Core Simplified database model binding and LINQ queries
Dapper (Micro ORM) High performance direct SQL mapping Lightweight database access with minimal overhead
SignalR Real time bi-directional communication Live data push and collaborative dashboard updates

API & service integration

The Blazor Pivot Table connects to diverse REST and RPC services via specialized adaptors:

Technology Key Benefit Use Case
OData V4 Adaptor Standardized query protocol support Enterprise services, standardized query endpoints
Web API Adaptor RESTful service binding ASP.NET Web API backends, REST endpoints
URL Adaptor Direct HTTP POST handling Custom endpoints, bespoke server contracts
GraphQL Adaptor Flexible and precise field querying Modern APIs, optimized payloads
Custom Adaptor Full control over request/response pipeline Proprietary backends, specialized protocols

Data shaping & Operations

The Blazor Pivot Table provides comprehensive data manipulation capabilities that empower users to slice, dice, analyze, and reorganize multi dimensional information efficiently:

Feature Purpose Key Benefit
Aggregation Calculate summary metrics using Sum, Count, Average, Min, Max, Distinct Count, and more Comprehensive built-in statistical functions
Calculated Fields Define dynamic runtime metrics using mathematical and logical formulas Custom business indicators without changing backend schemas
Grouping Cluster data by number intervals, date/time hierarchies (Years, Quarters, Months), or custom categories Multi level automated data categorization
Member Filtering Select specific members to include or exclude through a treeview interface Fast and intuitive checkbox based filtering
Label Filtering Filter row and column field text headers using comparison operators Text pattern matching (Equals, Begins With, Contains)
Value Filtering Filter field headers based on aggregated measure values and thresholds Rule based filtering (Greater Than, Between, Top N)
Sorting Order row and column headers alphabetically or by aggregated metric values Member sorting and value based ranking
Drill Down/Up Expand or collapse row and column hierarchy levels interactively Deep hierarchical exploration
Drill Through Inspect the underlying raw transactional records behind any aggregated cell Complete transparency into summary metrics
Editing Modify transactional records directly in cell or dialog editors and auto-update totals Real time what-if analysis and CRUD data correction

Report manipulation & User interface

The Blazor Pivot Table provides rich interactive UI tools that allow end users to customize and reconstruct reports at runtime:

Feature Purpose Key Benefit
Field List Drag and drop fields between rows, columns, values, and filters Self service report authoring via popup or embedded UI
Grouping Bar Re-order, sort, filter, and remove fields directly on the table headers Instant on the fly layout adjustments
Defer Layout Update Delay recalculations until the user explicitly applies configuration changes Seamless configuration for large scale datasets
Toolbar Single unified UI ribbon for creating, saving, loading reports, switching views, and exporting Streamlined end user experience
Report Persistence Save and retrieve report definitions to and from SQL databases or local storage Reusable, personalized user reports
State Persistence Maintain component layout, expanded states, and filters across user sessions Consistent user workflow and state restoration

Analytical visualization & Layout

Transform raw pivot numbers into intuitive graphical charts and customized spreadsheet layouts:

Feature Purpose Key Benefit
Pivot Chart Graphically visualize aggregated pivot data with 20+ chart types Visual trend identification and pattern discovery
Chart Types Column, Bar, Line, Spline, Area, Step, Scatter, Stacking, and Accumulation (Pie, Funnel) Comprehensive graphical representations
Multiple Axes Plot metrics with different scales simultaneously on separate value axes Side by side comparison of disparate metrics
Classic Layout Display row headers in separate columns rather than a stepped tree layout Excel-like tabular structure for clear cross referencing
Row and Column Adjust header dimensions, configure auto-fit, and control header freezing Tailored table structure and dimension sizing
Show/Hide Totals Toggle visibility of subtotals and grand totals for rows and columns Clean, organized executive presentations

Data formatting & Cell customization

Tailor cell values and visual presentations to match corporate branding and domain standards:

Feature Purpose Key Benefit
Number Formatting Apply standard currency, percentage, decimal precision, and custom masks Professional numerical and financial display
Conditional Formatting Highlight cells based on value criteria using colors, styles, and fonts Rapid identification of KPI targets, outliers, and anomalies
Hyperlink Render hyperlinks on headers or value cells to link to external resources Deep linking to transactional systems and detail pages
Tooltip Display contextual tooltips on headers and data cells upon hover Rich informational previews without screen clutter
Style and Appearance Personalize the visual appearance through CSS customization and themes Flawless alignment with application design systems

Large-scale rendering performance

The Blazor Pivot Table is engineered for exceptional performance, enabling smooth operation with datasets ranging from thousands to millions of records:

Feature Benefit Use Case Key Benefit
Virtual Scrolling Renders only visible row and column DOM elements; recycles on scroll Large datasets (100K+ rows) Smooth 60fps scrolling and ultra-low memory
Paging Segments massive cross-tabulations into navigable pages with pager UI Multi page structured reporting Fixed UI footprint and fast initial rendering
Data Compression Compresses repeated relational keys in memory before processing Memory-constrained environments Up to 80% reduction in client-side memory
Performance Best Practices Recommended configurations for optimal throughput and memory utilization Enterprise scale deployments Maximum execution speed across all platforms

Export & Reporting

The Blazor Pivot Table provides comprehensive export capabilities, enabling users to extract, analyze, and share reports in industry standard document formats:

Format Key Benefit Best For
Excel Exporting Export to XLSX with cell styling, conditional formatting, and custom headers/footers Spreadsheet analysis, financial workflows, and offline distribution
CSV Exporting Export raw cross tabulated data to lightweight CSV format Bulk data exchange and external pipeline ingestion
PDF Exporting Generate formatted PDF documents with custom page orientation, table and chart layouts, and page numbers Executive presentations, compliance reporting, and document archiving

Artificial Intelligence (AI) features

The Blazor Pivot Table integrates seamlessly with modern generative AI services (OpenAI, Azure OpenAI, Ollama):

Feature Purpose Key Benefit
Smart Pivot Table Natural language report generation, automatic data summarization, and dimension/measure prediction Instant business intelligence insights through plain English prompts

Accessibility & Keyboard navigation

The Blazor Pivot Table is fully accessible and compliant with Web Content Accessibility Guidelines (WCAG) standards:

  • WCAG Compliance - Built according to Level AA accessibility standards
  • Screen Reader Support - Comprehensive WAI-ARIA attributes (role="grid", aria-expanded, aria-haspopup, aria-selected, aria-sort) for assistive technologies
  • Keyboard Navigation - Complete operation via keyboard:
    • Arrow Keys - Navigate between row, column, and summary cells
    • Space / Enter - Expand/collapse hierarchy tree nodes, trigger buttons, and toggle checkboxes
    • Tab / Shift+Tab - Move focus between toolbar items, field lists, dialogs, and table cells
    • Escape - Close active popup dialogs and menus
  • Globalization & RTL - Support for Right-to-Left (RTL) rendering and localized UI strings in over 50 languages

System requirements

The Blazor Pivot Table works with:

  • Blazor Version: .NET 8.0 or higher
  • Hosting Models: Blazor Web App (Interactive Server & WebAssembly), Blazor Server, Blazor WebAssembly, Blazor Hybrid (.NET MAUI)
  • Browsers: Chrome, Firefox, Safari, Edge (latest versions)
  • Mobile: iOS Safari, Android Chrome

Getting Started:

Popular features:

Support & Resources