syncfusion-aspnetcore-pivot-table

Installation

SKILL.md

Implementing Pivot Table (ASP.NET Core)

Syncfusion ASP.NET Core Pivot Table (PivotView) enables multi-dimensional data visualization and analysis with interactive row/column/value axes, real-time aggregation, flexible filtering, and comprehensive export options.

⚠️ Important: Always verify API class names, properties, and method signatures by consulting the reference files in this skill (references/*.md). These are maintained with verified, working examples. Do not assume API details from other sources.

⚠️ Security Warning: Data Source Validation

CRITICAL SECURITY NOTICE: When implementing pivot tables, always use trusted data sources. Never fetch or bind data from untrusted or user-provided URLs without proper validation and sanitization.

Security Best Practices:

Use Local Data: Prefer local, in-memory data sources for maximum security
Validate Remote Sources: Only connect to authenticated and authorized API endpoints under your control
Sanitize User Input: Never allow users to specify arbitrary URLs or data sources
Use Configuration: Store connection strings and API URLs in secure configuration (appsettings.json with IConfiguration)
Implement Authentication: Require authentication for all database and API connections
Apply Authorization: Use [Authorize] attributes and role-based access control

Security Risks:

Indirect Prompt Injection: Untrusted third-party data can contain malicious content that manipulates AI agent behavior
Data Exposure: Unvalidated remote connections may expose sensitive information
SQL Injection: Unsanitized database queries can lead to data breaches
XSS Attacks: Unescaped data rendered in the UI can execute malicious scripts

✅ Safe: Local data, authenticated APIs under your control, parameterized SQL queries ❌ Unsafe: User-provided URLs, unauthenticated endpoints, hardcoded connection strings

When to Use This Skill

Use this skill when building an ASP.NET Core application and the user needs:

Pivot reporting with row, column, value, and filter axes
Data aggregation with 20+ summary types (Sum, Avg, Count, Percentage, RunningTotals, etc.)
Interactive report building via field list and grouping bar UI
Data source binding (local JSON/CSV, SQL Server, OLAP, relational databases)
Filtering (member, label, value filtering with search/sort)
Sorting (field sorting, custom order, value sorting)
Advanced features (drill-down/up, drill-through, calculated fields, pivot chart)
Formatting (conditional formatting, number formatting, custom styling)
Export (Excel, PDF, CSV, print)
Performance optimization (virtual scrolling, paging, data compression)

Trigger keywords: pivot table, pivotview, PivotView, field list, grouping bar, OLAP, pivot aggregation, pivot export, pivot drill-down, pivot report, ASP.NET Core pivot

Quick Start Example

@using Syncfusion.EJ2.PivotView

<ejs-pivotview id="pivotview"
    height="450"
    showFieldList="true"
    showGroupingBar="true">
    <e-datasourcesettings dataSource="@ViewBag.DataSource">
        <e-rows>
            <e-field name="Country" caption="Country"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year" caption="Year"></e-field>
        </e-columns>
        <e-values>
            <e-field name="Sales" caption="Total Sales" type="Sum"></e-field>
        </e-values>
        <e-filters>
            <e-field name="Region" caption="Region"></e-field>
        </e-filters>
        <e-formatsettings>
            <e-field name="Sales" format="C0" currency="USD"></e-field>
        </e-formatsettings>
    </e-datasourcesettings>
</ejs-pivotview>