Does anyone have any experience with a good wpf pivot table control?
9 Answers
DevExpress Grid control has good pivot functionality. Used it for Winforms a lot. I think the WPF version is also available.

- 51,744
- 26
- 128
- 170
-
A native WPF pivot grid is available http://devexpress.com/Products/NET/Controls/WPF/Pivot_Grid/ – Eduardo Molteni Mar 22 '10 at 22:54
VIBlend's data grid control has pivot table capabilities. I'm not sure if they have a WPF version but you can certainly host WinForms controls in WPF. Another alternative is to try hosting the MS Office OWC.
The Xceed WPF Grid looks like it has a lot of great capabilities. We use their WinForms grid and it does a pretty good job. They have a demo app you can download that shows off the different ways you can use the grid.

- 2,533
- 18
- 29
-
2Not a pivot control, and they are not planning adding any pivot functionality (cording to forums) – Eduardo Molteni Mar 22 '10 at 22:55
I would suggest WPF Toolkit which can be downloaded from DatGrid available in Codeplex. This is compatible with the latest WPF(.NET3.5 SP1) which is free and have almost all the features for a general purpose(and even more than that) But there are commercial vendors who have good grid controls(Not really free). Like Xceed, Infragistics, Component One, Telerik

- 49,102
- 20
- 108
- 119
If possible, I also need to be able to drag column headers and make them row headers and have the data summarize and group accordingly. Something along the lines of old ActiveX DataDynamics Dynamicube.
http://www.datadynamics.com/Products/ProductOverview.aspx?Product=DC
Auto Summary, Filtering of the Data Items being used, etc. without having to write a lot of code to do it in a custom fashion.

- 281
- 1
- 4
- 8
-
Yes it has those features http://www.devexpress.com/Products/NET/Controls/WinForms/Grid/dataoperations.xml – Gulzar Nazim Sep 10 '08 at 21:55
Alternative:
Excel OWC is a great query and reporting tool if you are running OLAP. It's a little dated and poorly documented, but works well on the intranet and can squeak by over the net.

- 9,804
- 5
- 34
- 41
Currently there are no WPF Pivot Grid controls. The vendor most likely to have it, DevExpress does not yet have a WPF version of the XtraPivotGrid.
Your best bet is to use XtraPivotGrid hosted inside your WPF control.
The other thing you can do is to use another grid vendor and do the "pivoting" by using LINQ or by manipulating the DataTable manually.
I am a consultant at Infragistics and I've been working exclusively the last few weeks with the Infragistics XamPivotGrid. We've been working to make this control fast and memory efficient. As a user and a developer, I am highly impressed with the usability of this control. You can check out this control in the WPF and the Silverlight NetAdvantage Data Visualization products at www.infragistics.com!
:-)