15

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

Bill Mahoney
  • 281
  • 1
  • 4
  • 8

9 Answers9

7

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

Gulzar Nazim
  • 51,744
  • 26
  • 128
  • 170
1

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.

1

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
  • 2,533
  • 18
  • 29
0

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
  • 49,102
  • 20
  • 108
  • 119
0

DevExpress Pivot Grid for WPF is almost ready. It will be released in the first half of the year.

NoNaMe
  • 6,020
  • 30
  • 82
  • 110
Ivan N
  • 1
  • 1
0

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
  • 281
  • 1
  • 4
  • 8
0

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

jason saldo
  • 9,804
  • 5
  • 34
  • 41
0

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.

-1

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!

:-)