skills.rest
AleksaRistic216
AleksaRistic216COMMUNITY
Explore all skills by this author →
GitHub

wpf-devexpress-pivot-grid

Build WPF pivot table applications with the DevExpress PivotGridControl.

Updated Dec 11, 2025
Search Tags:#wpf#data binding#olap#devexpress#pivot grid#pivotgridcontrol#cross-tab report
One-click install
npx skills add https://github.com/AleksaRistic216/dotnet-playground --skill wpf-devexpress-pivot-grid-aleksaristic216
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wpf-devexpress-pivot-grid
Source: https://github.com/AleksaRistic216/dotnet-playground/tree/main/.github/skills/wpf/wpf-devexpress-pivot-grid
Command: npx skills add https://github.com/AleksaRistic216/dotnet-playground --skill wpf-devexpress-pivot-grid-aleksaristic216

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires DevExpress.Wpf.PivotGrid, DevExpress.Wpf.Printing, DevExpress.Wpf.Charts, and includes references (resource) components.

What problem does it solve? Building cross-tabular pivot reports in WPF requires correctly wiring the DevExpress PivotGridControl's DataSource, field areas, aggregation functions, and grouping intervals, which differs significantly from the standard GridControl and trips up developers on namespaces, binding modes, and engine selection. ## Core Features & Use Cases - Pivot Grid Setup & Binding: Add PivotGridControl to .NET 6/7/8+ or .NET Framework 4.6.2+ WPF projects and bind to DataTable, List<T>, Entity Framework, OLAP cubes, server-mode, or asynchronous sources. - Data Shaping & Aggregation: Configure PivotGridField objects in Row/Column/Data/Filter areas with Sum/Count/Average/Custom aggregation, date and numeric grouping intervals, sorting, filtering, and window calculations. - Advanced Visualization: Apply conditional formatting, OLAP KPIs, ChartControl integration, MVVM field generation, layout persistence, and print/export to PDF, XLSX, HTML, CSV, and more. - Use Case: A developer needs a sales dashboard showing total sales per Country by Year with drill-down and Excel export; the skill provides the XAML namespace, field setup code, grouping intervals, and export calls to build it. ## Quick Start Ask the AI to create a WPF pivot grid bound to a DataTable with Country in rows, Year in columns, and summed Sales in data cells using the DevExpress PivotGridControl.

Frequently Asked Questions about wpf-devexpress-pivot-grid

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I bind a DevExpress PivotGridControl to a DataTable in WPF?▼

Set the PivotGridControl.DataSource property to your DataTable, then call BeginUpdate, add PivotGridField objects with DataSourceColumnBinding for each column, assign their Area (RowArea, ColumnArea, DataArea), and call EndUpdate. Note it uses DataSource, not ItemsSource like GridControl.

What is the difference between DevExpress PivotGridControl and GridControl in WPF?▼

GridControl displays tabular records where each row is one record, while PivotGridControl shows aggregated data where each cell is a calculation at a row/column intersection. PivotGridControl also uses the dxpg: XAML namespace and DataSource property instead of dxg: and ItemsSource.

Does DevExpress WPF Pivot Grid support OLAP cubes?▼

Yes, it binds to Microsoft Analysis Services cubes by setting OlapDataProvider and OlapConnectionString with Provider, Data Source, Initial Catalog, and Cube Name. Fields bind to cube members using full names like [Measures].[Sales Amount].

Why is my WPF Pivot Grid empty after setting DataSource?▼

Setting DataSource alone does not render data; you must also add at least one PivotGridField to each of the Row, Column, and Data areas. Wrap field additions in BeginUpdate/EndUpdate after assigning the DataSource.

Can I use DevExpress Pivot Grid with .NET 8?▼

Yes, it supports .NET 6/7/8+ by targeting net8.0-windows with UseWPF enabled and installing the DevExpress.Wpf.PivotGrid NuGet package. It is Windows-only and requires a valid DevExpress license.

How do I group dates by year or quarter in a WPF pivot table?▼

Set the field's DataSourceColumnBinding.GroupInterval to FieldGroupInterval.DateYear, DateQuarter, or DateMonth. You can stack multiple fields on the same date column with different intervals to create an expandable Year-Quarter-Month hierarchy.

Related Skills

Explore More Software Engineering Skills→
syncfusionsyncfusion
5

syncfusion-wpf-olap-gauge

Visualize OLAP KPI data in WPF applications via OlapDataManager and OlapReport.

Official
Advanced
weisbergweisberg
1

reporting

Aggregate cross-skill analytics outputs into executive dashboards and multi-format reports.

Community
Advanced
AUD-DEV-TEAMAUD-DEV-TEAM
3

iaud-olap-formula

Create OLAP formulas for fields, items, and conditional formatting in i-OLAP environments.

Community
Advanced
DevExpressDevExpress
39

devexpress-wpf-pivot-grid

Bind WPF PivotGridControl to data sources and configure fields for aggregation.

Official
Advanced