Is there a good WPF pivot control?

Question

Does anyone have any experience with a good wpf pivot table control?

Answer 1

DevExpress Grid control has good pivot functionality. Used it for Winforms a lot. I think the WPF version is also available.

Answer 2

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.

Answer 3

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.

http://msdn.microsoft.com/en-us/magazine/cc164070.aspx

Answer 4

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.

Answer 5

Thanks, I'll have to take a look at all of those tomorrow.

Answer 6

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.

Answer 7

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

Answer 8

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.

Answer 9

We will be publishing a Silverlight version of Data Dynamics Analysis, the evolution of the original pivot-table component -DynamiCube- soon. If we get enough interest from the market we will also be making a WPF version. Let us know if you are interested on our Data Dynamics Analysis Forum.

Answer 10

I'm sorry for being a bit late:) DevExpress Pivot Grid for WPF is almost ready. It will be released in the first half of the year.

Answer 11

Visifire has good charting controls for both WPF and Silverlight and its free.