tags:

views:

3102

answers:

11

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

+4  A: 

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

Gulzar
A native WPF pivot grid is available http://devexpress.com/Products/NET/Controls/WPF/Pivot_Grid/
Eduardo Molteni
The bad news is that you have to buy the full the DXperience WPF package to get the control.
Eduardo Molteni
A: 

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.

Bill Mahoney
Yes it has those features http://www.devexpress.com/Products/NET/Controls/WinForms/Grid/dataoperations.xml
Gulzar
A: 

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

jms
+1  A: 

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.

Garo Yeriazarian
Not a pivot control, and they are not planning adding any pivot functionality (cording to forums)
Eduardo Molteni
A: 

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

Bill Mahoney
+1  A: 

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.

They have now a Silverlight Grid and planning a WPF one.
Eduardo Molteni
A: 

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

Jobi Joy
A: 

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.

Zeno Lee
A: 

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.

scott
All people reading this question will be interested. Just read the view count.
Eduardo Molteni
A: 

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.

Ivan N
+1  A: 

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

Jojo Sardez
As good as it is, it is not a Pivot control
Eduardo Molteni