Blogs

Woody Pewitt - DevExpress Analytics Blog

> All Tags

AsyncMode for Pivot Grid & Chart Integration (available in v2011.1)

      

After my recent blog post AsyncMode for Pivot Grid (coming in V2011 vol 1) I received several questions in the comments and by email about how the chart integration feature would be affected. The good news is that it will not be affected at all and I have created the example below showing that an application containing that has the pivot grid and a bound chart. As you can see when the pivot grid has completed processing the data then and only then does it hand off the selected data to the chart to be rendered. In effect the chart control is totally uninvolved in the process until the pivot grid is all done with its work.

Pivot_Grid_AsyncMode_Chart

I am sure you will agree this make the AsyncMode feature even more interesting and useful.

Published May 09 2011, 09:49 AM by Woody Pewitt (DevExpress)
Filed under: , , , , , , ,
Technorati tags: Performance, Features, Pivot Grid, WPF, WinForms, v2011.1, charts, coming soon
Bookmark and Share

Comments

 

Sigurd Decroos said:

Not seeing a picture in IE9, FF nor Chrome :(

May 9, 2011 4:54 PM
 

Mohsen Benkhellat said:

I see that pivotgrid is getting more attention which is very welcome as I use it a lot.

It still though misses one major feature I need like this www.quantrix.com/.../tutorial.php (feel free to remove the link if it violates any forum rule).

Basically, it is about being able to let the user build the dimensions (rows/columns) right in the pivotgrid like they show in the video. It is something you can not do with XtraGrid or XtraTreelist.

What do you think?

May 9, 2011 4:55 PM
 

Woody Pewitt (DevExpress) said:

Sigurd,

Sorry for some reason my html got chewed-up and my flash tag was not working so I have created an animated gif file that has some unforchunate dithering but at least you can see what I was trying to show.

Thanks,

May 9, 2011 6:42 PM
 

Woody Pewitt (DevExpress) said:

Mohsen,

I am sorry but I don't get what you are stating or asking I just looked at the quantrix product and while I can see why some would find it interesting in the end the pivot grid gives you the same type of functionality but more to the developer. I could even see creating a lot of the quantrix features in for your users using the pivot grid but the big catch is the data source. We start from the source and build a view on top of it where quantrix starts with a view and then adds data. While I did not dig deep enough I am sure (or would hope) quantrix will allow you to bring in data from outside sources but it seams like a backward use case to me. With pivot grid a user is ensured that the data is correct and they just change the view as needed.

With the expressions users can create and the summery views that fields can display you can give your users all the features I saw available in quantrix I would like to be able to offer a a more visual way for end users setup there views but at this point you could code something yourself to allow for this. Imagine a visual designer that allowed for users to define fields and associate them with a datafield.

What do you think?

May 9, 2011 7:16 PM
 

Mohsen Benkhellat said:

Thanks Woody for your thoughts.

I know it is an unusual use for a pivotgrid but you would be amazed what uses cases users can come up with.

I will try to intercept some event that will let user to access the dimension (row or column) header and insert a record for that dimension and may be (not sure at this time) a zero value as a measure in the fact table at an intersection with the other dimension (don't know yet what the logic would be).

If I ever figure out some time later a way I will give feed back here hopefully.

Thanks again

May 10, 2011 9:42 AM
 

Paul Talbot said:

Mohsen, we do something very similar to this, we create pivot's with all elements that we want to display, there are over 140 columns in some of our pivot tables.

Customers can then use a form that we created to add/remove columns to their hearts content as well as formatting and changing of column caption etc.

Defer layout update would be ideal for us as we sometimes have large amounts of data and the software looks to have hung when they add/remove columns.

May 18, 2011 5:49 AM
More from DevExpress
DevExpress
About Us
Awards
Community Events
User Comments
Careers
Licensing
Contact Information		Press
DevExpress News
Logos
Reviews and Publications
Case Studies
DevExpress on Facebook
DevExpress on Twitter		Support
Knowledge Base
Ask a Question
Report an Issue
Online Documentation
Download Documentation
Technical Blogs		Training
Online Demos
Webinars
Videos
Courses
Partners
DXSquad
MVP Program
Community Group Support		Version History
What's New
Current Version/Build
Version History
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.
DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio. Whether using WPF, Silverlight, ASP.NET or WinForms, DevExpress tools help you build and deliver your best in the shortest time possible.
Your Privacy - Legal Statements
Copyright © 1998-2012 Developer Express Inc.
ALL RIGHTS RESERVED
All trademarks or registered trademarks
are property of their respective owners