Do you plan a PivotGrid in Silverlight in the Future?
Regards
215 Answers, 1 is accepted
Thank you for the interest! Indeed we are already making the first steps to providing a Pivot Grid either as a separate control or as a mode of the existing RadGridView control .
We would be very happy if you share with us your expectations and requirements for such control . Any details on your business scenario and integration of such control will be helpful for us in the design process of the control.
Best wishes,
Pavel Pavlov
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
When do you think you will have a first release of the pivotgrid?
We are interested in such a control supporting the following features:
- drag&drop dimensions and measures
- hierarchical dimensions
- filtering(soft & hard) on dimensions also measures
- calculated fields(based on custom formulas of one or more fields)
- possibility to create schemas programatically
- customize totals (apply different formulas)
- possibility to save/load layouts(dimensions and measures, filters and sorting applied)
- possibility to replace values with colors or other representations(geometrics)
- printing
Best Regards
The pivot grid is in our plans and we already started the research phase. As a time frame our plans are to start the development after our Q2 2010 release and to put all the efforts to ship it with our Q3 2010 release.
Thank you for your valuable feedback! I have updated your Telerik points.
Best wishes,
Hristo
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
As I wrote in my previous post, we plan to ship a pivot table with our Q3 2010 release. Still there are a lot of things at our plate and this time frame is tentative.
All the best,
Hristo
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
I need two functionalities:
- Work on relational data
- Work with MS OLAP
Please feel free to contact me at noah.shipley@dfa.com
Thank you for your feedback and your eagerness to share with us more details about your scenario. The more requirement we get the better product we'll deliver.
Kind regards,
Hristo
the Telerik team
I'm also very much interested in this.
I would be happy with the above mentioned features.
Would be nice to see this in Q3 2010.
Best Regards
Bill
Essentially I have doubles/ints/strings described in multivariate space.
A simplistic data document for this might look like:
Each row or column should be draggable to reorganize or pivot the table. Because the amount of data involved is very large, virtualization is a pretty big must have (although this could be done behind the scenes by having us implement an interface and handle something along the lines of GetAt(coordinates).
Thank you for your feedback and suggestions! We'll include these points in some of our future discussions.
Sincerely yours,
Hristo
the Telerik team
Do you have an update on when the PivotGrid may be available and any information on functionality/features? Having reviewed the content for Q3 2010, it didn't seem to be listed.
Regards.
Unfortunately there are no specific details which can be disclosed at the moment.
Best wishes,
Hristo
the Telerik team
I too have an urgent requirement for the grid. My requirements are very simple however - maybe they can be achieved using an existing control, rather than waiting for the Pivot grid (which I haven't got time to do!)
I have a collection of objects which have three properties: let's call them Town, Sex and Population. I need to use this to populate a grid with a row for each town, showing the population for Male and Female in the columns. No dragging, dropping or anything fancy.
Can you help me do it?
Cheers,
Steve
Please have a look at this blog post describing the use of "Transpose" in RadGridView. Let me know if this approach fits your needs.
Sincerely yours,
Hristo
the Telerik team
I'm also in the queue for a Telerik Pivot Grid control! A very very anticipated control :) Let's hope for Q3 (maybe a ctp/beta?)...
For me the most important things would be:
- XMLA connection support (preferably via SOAP and not MS Analysis Services)
- flat datasource support (using any IEnumerable)
Basically it should have every feature that the Infr*gistics and S*ncfusion Silverlight Olap controls have :)
Best regards,
Tamas
I do not need to transpose my data, My data looks something like this:
Town Audience Population
London Men 10,000,000
London Women 11,000,000
London Children 5,000,000
Brighton Men 150,000
Brighton Women 120,000
Brighton Children 56,000
and I need to display it in the grid as:
Men Women Children
London 10,000,000 11,000,000 5,000,000
Brighton 150,000 120,000 56,000
Get the idea? There can be any number of towns or audiences. I can do this in the Infr*gistics PivotGrid by using a FlatDataSource, but I wondered in Telerik offer something similar. I have not yet decided which set of controls to purchase for my development.
RadGridView does not support this internally , but with a few lines of external code it can be easily achieved .
For this we may write an IValueConverter or a ViewModel - to transform the initial data to a flat pivot-like table suitable for RadGridView and use it for ItemsSource
Since the columns are not fixed ( as you say there may be many audiences ) , we may need to use something like http://blogs.telerik.com/vladimirenchev/posts/09-04-23/lightweight_datatable_for_your_silverlight_applications.aspx.
Let me know in case you need a working sample on that .
Best wishes,
Pavel Pavlov
the Telerik team
I am also very interested in Silverlight PivotGrid component. It´s very important for us in this moment...
We are developing our product using Telerik Silverlight controls. Our product was develop in Winforms ( last version ) , and we are using DevExpress PivotGrid control: http://documentation.devexpress.com/#WindowsForms/CustomDocument3409
But now, we are using telerik controls ( silverlight ), in our new version.
So, would be nice to see this new control in Q3 2010.
Thanks!
the Q3 version will support Olap Cube with MS Analisys Service??
Thanks a lot
Paolo
I cannot share too much about our plans in this space right now. However I can say that: We are actively working on something that we hope will solve your problems. It will be Silverlight based in the first version, but will not be limited to Silverlight only in the future. As soon as we have something stable to show we will announce it publicly.
Regarding the timeframe for the official announcement probably it will happen in the first months of 2011.
We do have a private beta testing mailing list of clients who want to participate and give an early feedback about the product. We will mail this people once we have something useful to show, but before shipping it to a broader audience. Anyone who wants to be included in this list please reply to this forum thread.
Hope this helps,
Stefan Dobrev
the Telerik team
I wish to be included in this mailinglist, thanks
Paolo
I'd also like to participate in the beta testing.
Thanks and best regards,
Tamas
Hello
I am very interesting in early feedback.
Please don’t hesitate to contact me in this metter.
You were added to the private beta testing mailing list.
Regards,
Hristo
the Telerik team
http://www.infragistics.com/dotnet/netadvantage/silverlight/data-visualization/xam-web-pivot-grid.aspx#Overview
Thank you for your feedback and involvement!
We are well aware of the competitive offerings and we believe that once our component is out it will be richer in terms of features and will suit a wider range of scenarios.
Regards,
Hristo
the Telerik team
I'm interested in the beta testing of the new pivot control as well. We need a pivot grid for a project we are currently working on.
Thanks,
Brian
You were added to the list.
Kind regards,
Hristo
the Telerik team
You were added to the list.
All the best,
Hristo
the Telerik team
As with the others on this thread, a Pivotgrid along the lines of the Infragistics offering is something we are very keen to have access to. I would be happy to be included in your beta testing group.
Regards.
I'd like to be part of beta testing for the Silverlight PivotGrid.
Please include me in the beta testing mail list.
Thanks.
B.Manohar
Thanks,
Nick
You were added to the list.
Greetings,
Hristo
the Telerik team
Regards
Wasif
I have added you to the list.
Best wishes,
Hristo
the Telerik team
I have a client who use telerik and im trying to persuade them not to buy into dundas dashboard i think this could help me alot
For the time being there is no beta code available which we can provide for review. I have added to the beta testers mailing list and you will receive a notifications once the early bits are available.
Kind regards,
Hristo
the Telerik team
Many Thanks
Toby
I've added you to the list.
Regards,
Hristo
the Telerik team
A Silverlight PivotGrid feature would be very nice!!!
However, an Olap client would be great as well. In fact, there was one in asp.net developped by dundas. Now, it's dundas dashboard (silverlight)... But it's more limited than the asp.net one.
Neverthless, I found an OLAP client for silverlight developped by ComponentOne.
http://demo.componentone.com/Silverlight/OLAP/
This demo is quite interesting because you can have a chart view or a grid view. It's quite similar to what dundas did in asp.net.
This is exactly this kind of feature that my organization is looking for... So, it might be a good value for Telerik to develop something like that.
Thank you for your involvement! We are actively working on introducing this functionality in our Silverlight offering.
Would you like to include you in the mailing list for early beta testers?
All the best,
Hristo
the Telerik team
I would be very pleased to be part of this mailing list :).
Thanks.
You were added.
Regards,
Hristo
the Telerik team
Thanks
Rich
You were added.
Best wishes,
Hristo
the Telerik team
As with other requirements that have been posted, I would like to know if the following capabilities are in the plans:
1. Editable Pivot grid
2. Ability to control the query (for example MDX) that is being sent to the data source
I am a new user to Telerik (Silverlight controls) and extremely happy with it so far
and awaiting for the PivotGrid!
Also, I am interested in getting the beta test version. Could you please add me to the beta testing list?
Thanks.
B.Manohar
Are you able to provide an estimate on timescales for the beta program?
Regards,
Mark.
@ Baskaran:
I've added you t the mailing list. The features you pointed out will be included in our next discussions regarding the features set in our Pivot Grid. Thank you for your feedback!
@ Bernhard:
I've added you to the list.
@ Mark:
We are doing our best to deliver the early bits in a few months.
Greetings,
Hristo
the Telerik team
Do you mind adding me to the list? That would be nice.
I'm in the need of an editable pivot grid...
Thanks a lot in advance,
John.
You were added.
Best wishes,
Hristo
the Telerik team
Thanks
jack
Many Thanks
Louis
I've added you to the list.
All the best,
Hristo
the Telerik team
Thanks a lot in advance
I have added you to the list.
Greetings,
Hristo
the Telerik team
Thanks
You were added to the list.
All the best,
Hristo
the Telerik team
You were added.
Best wishes,
Hristo
the Telerik team
thx!
You were added.
Greetings,
Hristo
the Telerik team
Paolo
we also require an olap grid.
the thing is we would need a serious release date estimate, to know if it is worth waiting for (say a release in a month or so) or if we must go to a competitor right away.
please give us a clear answer so we dont waste our time.
thanks
Hi Paolo, toto rto,
I understand your impatience in waiting and wanting clear answers and a ready-to-use pivot grid. I really do – believe me or not I’m even more impatient. The people involved in its development are determined and are working hard on developing a first-class product. The facts are that we are in the midst of the development and we still have a lot of work to do. Unfortunately, I cannot be more specific than that – we can be ready in a month or two with the beta version but for a fully functional version the time frame can be probably extended till the end of the year.
There are various reasons for this delay. One of the main ones is that we’ve collected a lot of various feedback and we want to deliver most (if not all) of the requested features at once. Releasing the product with so many features will ensure that it will meet the requirements of most of our clients. This however requires a lot of work (coding/testing) to make sure that the product will work as expected.
This being said, once again I’ll ask for your patience. I hope that you will understand our position on this matter.
Greetings,
Hristo
Unit Manager
the Telerik team
we will keep an eye out for the grid once it comes out.
thanks for the clear answer.
- select dimensions,
- select measements,
- filters,
- export to excel,
- save as report that i will be able to open once again,
but i would like to get component faster ;-) most probably like many others
Thank you for your feedback!
As I said in my previous post, the pivot grid is still work in progress and you will be notified once we are ready to show you the early bits.
Best wishes,
Hristo
the Telerik team
You were added to the list.
Best wishes,
Hristo
the Telerik team
Thanks
You were added to the private beta testing mailing list.
All the best,
Hristo
the Telerik team
There wasn't any mailing till today. You are in the list and when we have more news you'll be notified.
Regards,
Hristo
the Telerik team
You were both added to the list.
Greetings,
Hristo
the Telerik team
You were added to the list.
Greetings,
Hristo
the Telerik team
I have added you to the list.
All the best,
Hristo
the Telerik team
can you tell me, when the beta-tests starts?
We ar interessted in a SilverlightPivotGrid. Please tell us some facts about the Release.
Thank you!
Can you add me to the pivot grid beta program as well. Been using Viblend version but it not stable. Been using your controls for various companies and have always found them stable and good.
Thanks
Richard...
@ Richard, I have added you to the list.
Greetings,
Hristo
the Telerik team
We need to make a choice for the next version of our products so is it possible to be added in the private beta list ?
Thanks by advance.
There is still a lot of work to be done and it is not the time for a concrete date or releases. I have added you to the list.
All the best,
Hristo
the Telerik team
I cannot be more precise with the time frame of our pivot grid availability. Working in such dynamic environment force us to change the priority of some of our development endeavors. Still we expect to have the early bits in a couple of months.
@Andre,
I have added you to the list.
Best wishes,
Hristo
the Telerik team
1 - I go to the Public Issue Tracking system to have my vote on which features are important and I cant find anything matching Pivot - so we dont all go and vote on the wrong item.. can you please include the name and details of the Pivot grid in your current PITS list.
2 - In response to shivir 's post about the Ranet control.. That looks brilliant.. but I dont want to have my data require an OLAP cube before being able to use this... I am really after something where a user does a fairly simple search producing 50 to 500 records and then give them some tools to analyse that information, similar to Excel and its pivot table..
3 - I also agree with shivir's post about our expectations for a response from Telerik with more concrete information. I raised Ticket 268645 in December 2009 and received the following response
"We definitely have the PivotTable in our road map. We will release an early CTP of this next year, but it will be in post 2010 Q1 time frame. Stay tuned for more information on our site and blogs.
Sincerely yours,
Stefan Dobrev"
So if you "definitely have the PivotTable in our road map" then why can we not see something in the RoadMap now?
4 - What should we expect from being in the beta list? Are you going to email us all with a list of requirements? Lots of people posting here just say add me to the list expecting to then receive some more information about the beta ... but other than receiving regular copies of everyone elses "Please add me to the list"... I have not seen anything else. What is this list??
Yes I don't need OLAP support either, but it would be nice in a later version, does not need to be there in the initial release.
Since being on this list I have only got the updates to this thread and nothing else.
Come on Telerik, can you give use more information then please wait, because in a minute I am expecting more people to move to another provider for this feature request (thats been on the cards for over 1 year now).
Yes I know my account says I have not paid for any controls, but it does not mean I have not recommended and had them purchased by the client I work for.
Regards
Richard...
i would be happy to receive really simple olap grid where i can have functionality that i describe in 17march2011 in this thread,
but i really would like to see the beta, because it will enable to take me decision where to go?
and i really need DATE, it is important to be able to take a decisions;
i think also that all those people is still waiting beacuse they like Telerik products and your service,
but with Olap grid it is not your according Telerik rules, i hope ...
wake up telerik...
wake up ...
please give your decision if you will develop this or not!
all those people (below) is still waiting because of your other products, but i don't know how long?
I hope my previous statements were not vague in terms of our development plans and the fact that the Pivot Grid control is included and we are doing our best to ship it till the end of this year. The reasons for being uncertain about the timeframe are pretty trivial – ever-changing priorities and a lot of other clients’ requests which we have to implement in our suite. But I want to assure you that the Pivot Grid is already with the highest priority in our development plans and we are optimistic that it will be ready till the end of this year.
Once again I would like to thank all of you for your patience and understanding.
Kind regards,
Hristo
the Telerik team
For others reference on this List...
There is now a Pivot Table in the Public Issue Tracking System
Issue ID 6027 - New Control: Pivot Grid
http://www.telerik.com/support/pits.aspx#/public/silverlight/6027
I suggest you vote for this control and see if it gains support inside Telerik to make it a high priority.
""
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
""
Are there any news on this topic?
Thanks and best regards,
Tamas
There are no change in our plans - we are actively working on our Pivot control, and most probably we will be able to show you the early bits in a couple of months.
Best wishes,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
That's great, I'm looking forward to it!
Have a nice day,
Tamas
However, could you please advise the initial requirements you are working on for this Pivot Table.
My requirements are based on us providing an small dataset, such as 500 records and being able to analyze this information in a quick adhoc manner, and to be able to layout information in alternative ways.
I know others on this thread have talked about connecting the pivot table up to an OLAP server and a data cube. If this is what you are targeting, then its no use to me.
Thanks
There will be no problem to bind to such dataset and analyze the data in it using our Pivot offering.
Using OLAP will not be required.
Kind regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Another release, still not Pivot Table.
When does it go into Beta please. When can we see more than just talk.
we love telerik, but we have to have a chance to plan our development as we take a decision to be dependend on your future development,
might help explain why they avoid any real discussion about this grid for over a year now...
Hi All,
I would like to assure you that PivotGrid component is currently in development and it will be available for both Silverlight and WPF. I know that most of you have been waiting for quite some time now but we want to build the best PivotGrid in terms of performance and feature set which takes time.
A preview should be available around March/April.
Regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Can you give us any further information at this point about its capabilities?
Are you able to let us know what data sources it will support?
Thanks,
Adam
;-)
Nice Joke.
We are working on supporting various data sources like cubes, relational DBs, flat data, etc but it is a bit early to say if all of those will make it into our first release. The situation with the list of features is pretty much the same.
We plan to have several releases before the official one that will be used to gather feedback and adjust our priorities according to your needs.
Stay tuned.
Kind regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Hi,
As I have mentioned in one of my previous posts we expect to release a preview version at the end of March or early April. After that we will have a beta and some time after that we will have the official release.
For now I am hesitant to provide you with a concrete release date but we should be able to give you more information right after the preview is released and we gather some user feedback.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Hi,
I am afraid that the PivotGrid official release is still several months away and we might not be able to fit into your schedule. As I have mentioned the first unofficial release (Preview) should be available in a month or two.Regards,
Milan
the Telerik team
Are you supporting Copy / Paste functionality for the PivotGrid. And when do you have a release of PivotGrid for MVC Razor view
Regards,
Abhishek Varma
Hi,
Copy functionality is marked with hight priority for our first release and it should be available when the control is released.As for the MVC PivotGrid, a MVC PivotGrid is not in our immediate plans.
Regards,
Milan
the Telerik team
I've also been very interested in using a pivot grid for Silverlight. Please let me know as soon as there is a preview version available. I'm putting off going for competitor offerings in the meantime, but this feature has been a long time coming!
Regards,
Jason.
Thank you for your interest in our upcoming pivot grid offering. We will notify you as soon as the preview is available.
All the best,
Milan
the Telerik team
http://blogs.telerik.com/blogs/posts/12-03-12/get-excited-aspnet-ajax-pivotgrid-html5-chart-and-prizes-coming-soon-telerikcontrols.aspx
Best regards,
Jakub Wilk
Hello,
We are currently working on PivotGrid controls for both Silverlight and ASP.NET and what we are aiming at is, apart from the different UI, to have controls with similar functionality that target two different platforms.
If you have any general questions about the ASP.NET PivotGrid you could consider starting a new thread on our ASP.NET AJAX forums. Also we would really appreciate it if you could share what pivot (ASP.NET AJAX) features are key from your perspective.
Regards,
Milan
the Telerik team
Next week is the end of April, kindly let us know the status of PivotGrid.
As your previous feedback you have mentioned you all expect to release a preview at the end of March or early of April.
We are almost ready with the preview but we had to spend some time researching additional scenarios that might impact our architecture in the future. We are almost there and I would like to ask you to bear with us a little bit more.
Greetings,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Last time I checked this was landing in Q2 2012 release. What is the status now. I don't see this at all in your roadmap for Q2 which is published here... http://www.telerik.com/products/silverlight/roadmap.aspx.
Also, I am interested in getting the beta test version. Could you please add me to the beta testing list?
.:TH
I have added you to the list.
As for the progress, we are working on our Pivot Grid at full speed and I am positive that soon we will have some good news to share, so stay tuned.
Regards,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Thanks
can you add me to the list too? Thanks
Indeed the pivot Grid won’t be available with our Q2 2012 official release but our private CTP will be ready till the end of June and everyone in the list will receive it for review and feedback.It will be soon this time.
@ Hans, Tobias
I have added you to the list.
Kind regards,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Please can you also add me to the list for the private CTP review.
Thanks,
Adam
I have added you to the list.
All the best,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Can you also please add me to the list for the private CTP review.
Thanks,
Eric
In the mean time, can you also please add me to the list for the private CTP review.
Mike
Thanks,
Chris
You were all added to the list.
Kind regards,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Thanks,
Piotr
I really love your products, but please this time be serious about Pivot !
Thanks!
You were also added to the list.
Kind regards,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
thank you.
Thanks
Hi,
Thank you for your interest in our upcoming RadPivotGrid offering. You were both added to the list.
Greetings,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Cheers,
Steven
You have been added to the list.
Kind regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Thanks.
You are now on the list. Thank you for your interest.
Regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
We are looking for a pivot grid as well. Can you please add us to this list? Thank you.
Thank you for your interest. You should have received an email with further information on how to download our CTP bits.
Kind regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
May I know the status for Silverlight PivotGrid? Is it going to CTP release?
I would be interested on this component, so could you please add me to the list as well?
Thanks.
We have added you to the list. You should receive an email with more details shortly.
Kind regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Thanks.
You have been added to the list and you should also receive an email shortly.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
You have been added. Thank you.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Btw: pleeeeease release this as soon as possible, our company is in desperate need of this from telerik (we are currently using from radar... we bought the license with code and is full bad programming and bugs...)
Thank you for you rinterest. You should receive an email with more details shortly.
We would be glad if you could provide us with some feedback regarding the current state of RadPivotGrid. For example, are you missing any important features that are must-have for your projects. Any suggestions, ideas, feature requests, etc will be appreciated.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Any suggestions, questions, etc. should be posted here or through the support tickets?
Once again thank you so much.
Posting questions throught our support system is preffered but we also try to aswer questions posted here as soon as possible.
Kind regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
We received access to the CTP and were impressed with the level of completeness of the control.
In the demo system provided it worked smoothly and from a user interaction it did most things we wanted immediately.
We put together a wish list of additional features that were not obvious from the demo and investigated these at a code level - our feedback is below.
Other users should not rely on this as a definitive answer... and other more experienced developers or with more time might overcome some of the perceived shortcomings.
1. Drill through to obtain a list of source data.
We want select an individual cell and programmatically determine the criteria on that cell via row and column attributes so that we can then generate (outside of the pivotgrid) a data set for use in another control such as data grid. It was not obvious how we could achieve this.
2. More than just summation... need counts, min max, Avg, median
Not available in the demo, but available programmatically - Telerik PivotGrid appears to support all the following Sum, Count, Average, Max, Min, Product, StdDev, StdDevP, Var, VarP - all Good. Thanks
3. Calculated fields (user customisable instead of data driven) - it would be good to support Expression Fields like
http://demos.telerik.com/silverlight/#GridView/ExpressionColumn + http://demos.telerik.com/silverlight/#ExpressionEditor/FirstLook
It appears that the fields can only come from source data.
4. control of sorting of data labels (columns and rows).
It would be good to provide control over the sequence of columns - but this does not appear possible.
5. clickable links in data row headers and column headers
We believe this is possible.
6. Access the summarised data to feed into a graph component.
We would like to extract the summarised data from the pivot grid for use in export or as the source data for a chart control. This does not appear possible.
7. Exporting to excel, csv etc.
see 6 above
8. print/pdf options
would need access to source data
9. save/reload user configuration data
possible with manual coding
10. filtering within row filter, column headers.
Not yet supported.
Thanks
Please can you provide access to the CTP for me too? Also when are you expecting to release this control?
Thanks
Keith
The contribution of James is excelent and I would like to emphasize the suprisingly good performance and "Excel" pivot look.
That being said I would like to add the following to the list:
11 - OLAP support
I haven't been able to see that on the demos
12 - Possibility of creating a subset of information based on a couple of rows
This feature is interesting if I want to use multiple selection of rows, and see the "temporary" totals, avg, etc and the possibility to "group" those selected rows into a single row to evaluate it along with the rest of the information
I would like to suggest to the rest of the "testers" to keep posting their opinions and ideas here on this forum because this way we can share it with everyone.
Thank you all for the wonderful feedback.
@Keith - You should have received an email regarding the CTP. Enjoy.
@James
1. Drill through to obtain a list of source data. This feature is not available at the moment but it is listed on to-do list. Is this a must-have feature?
2. More than just summation... need counts, min max, Avg, median. All standard functions are available programatically. We are working on UI dialogs and menus that will allow users to easily choose any function.
3. Calculated fields. Currently not available. This one is also on our to-do list but it is unclear when we will be able to implements it. Is this a must-have feature?
4. control of sorting of data labels (columns and rows). Programatically available but at the moment custom code is needed. Working on providing UI dialogs and menus. By default, values are sorted in asceding order. If you would like to reverse the ordering you could try the following:
public
Example02()
{
InitializeComponent();
var provider =
this
.pivotGrid.DataProvider
as
LocalDataSourceProvider;
var description =
new
PropertyGroupDescription() { PropertyName =
"Product"
};
description.GroupComparer =
new
MyComparer();
provider.RowGroupDescriptions.Add(description);
provider.Refresh();
}
public
class
MyComparer : GroupNameComparer
{
public
MyComparer()
{
}
protected
override
Cloneable CreateInstanceCore()
{
return
new
MyComparer();
}
public
override
int
CompareGroups(IAggregateResultProvider results, IGroup x, IGroup y, PivotAxis axis)
{
// reverse the default order
return
base
.CompareGroups(results, x, y, axis) * -1;
}
}
5. clickable links in data row headers and column headers. Could you please clarify this? Is it possible to provide a scenario for this one?
6. Access the summarised data to feed into a graph component. Possible but not user friendly. Will try to provide chart integration in the future. Is this a must-have for your scenarios?
7. Exporting to excel, csv etc. Not available. It is on our to-do list but unclear when we will be able to implement this. Is this a must-have for your scenarios?
8. print/pdf options. Will consider it for the future.
9. save/reload user configuration data. Will support RadPersistenceFramework in the future.
10. filtering within row filter, column headers. We are currently working on this and the next version will have many improvements regarding filtering.
@ carlos
11 - OLAP support . Currently not supported but we are working on this.
12 - Possibility of creating a subset of information based on a couple of rows. Interesting feature that we will consider for future implementation.
@Travis
We are working on OLAP support and we will try to make this feature available as soon as possible.
We also have supoprt for IQueryable which allows you to use Entity Framework (or other IQueryable) for performing grouping on the server. This allow us to have lighting-fast grouping plus extremely low memory consumption - actual entities are not downloaded to the client. For example, working with 1 million entities will have barely noticable effect on memory consumption. What do you think about this? Do you find it compelling? Unfortunately it is currently only available for WPF.
Thank you for your time. Keep the feedback coming.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
@Semyon Akimov - You should have received an email with intruction on how to download the CTP bits.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
I don't seem to have received the email. Please can you send it again? (I've received notifications that this forum had been updated though so emails are definitely coming through to me!)
Thanks
Keith
I so not know the reason why you did not receive an email but you should be able to access the CTP bits by loggin in at telerik.com and following the link to your "Trial Downloads" (Manage products -> Trial Downloads). You should see an entry with name RadPivotGrid CTP.
Hope this helps.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Small correction - if you would like to simply choose between ascending or descending ordering you could use the SortOrder property of the respective Desciption. For example:
new
PropertyGroupDescription() { PropertyName =
"MyProperty"
, SortOrder = SortOrder.Descending };
Implementing custom IGroupComparer should be considered when you need custom ordering that cannot be achieved by simply setting the SortOrder property.
Greetings,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Thanks!
The RadPivotGrid very impress to us.
The only thing that we would to add on is the OLAP Cube/SSAS support, does you all have any time frame for this?
Can we know when will be the RadPivotGrid trial & official release?
Thanks.
I'm sorry to inform you that I haven't received an email for the CTP and I don't see the link in the trial page ...
Thanks!
Andrea
Thanks for the detailed reply.
1. I think it is quite important. The Pivot Grid allows the user to summarise various datasets, but once areas of interest are identified, then the ability to investigate further is necessary. Whilst my comment is titled Drill Through.. I dont require the control to provide this feature in its complete form. So long as I could click on a cell and receive an event which provided some details on that cell such as column dimensions and row dimensions, then I can use this to access the data directly from the source system.
For me - Priority 1
2. Telerik currently working on short cut menus to enable use of alternative stats fields. Great. I think this would be my 1st or 2nd priority.
3. Calculated fields - I am happy to wait for this. Lower Priority.
4. THanks for the code - we can make that work.
5. clickable headers.. For example, one data source I have would contain data with dimensions for Job Number, Supplier, Tasks. So one (simplified) use of the Pivot Table would have Job Numbers as Row Headings, Suppliers as Column Headers and Count(Tasks) as the data values. It would be useful to be able to allow the user to click on the Job Number and then navigate to another screen which shows details for that specific Job Number.
6. 7. 8. All about accessing the summarised data. I dont need built in PDF, built in export, or built in charting.. access to the data will meet our requirements, as most of the implementation will be fairly customised.
For me - I think this is the 3rd most important after items 1 and 2 above.
Thanks - as asked by other users - any details on expected beta version, and then full release would be much appreciated.
@James - Thank you once again for the wonderful feedback. We will consider all requests and suggestions.
Since there is a huge demand for cube support we have updated our priorities and we will put more effort into this feature and also try to give you bits with cube support as soon as possible. Currently, I cannot commit to a certain date but we will try to have this working in a month or so. We will post more details when we are ready.
Regarding the release cycle of RadPivotGrid, we plan to have an official CTP (which will include additional features and bug fixes) in 2-3 weeks, after that we will have an official Beta. Most probably the Beta will be released with Q3. V1 will be released after the beta phase.
We believe that having CTP and Beta phases is crucial for matching your expectations and providing you with the best pivot control on the market. As you can see, we are pretty flexible about the features that will make it into the official release and we want to make sure that those features are the ones that you really need.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
Thanks for keeping us updated.
As for the export feature I agree with James, it's not necessary at this point to have a built in - all good looking - export xls,pdf, etc.
A simple datatable (or list of objects of some class of yours) would be fine.
The component we are currently using has an export to file feature but we still create our own exports based on the data that it has because of specific layout needs.
Personally our company has this priorities:
1 - OLAP MDX support
2 - Export data
3 - Possibility to group (merge) selected rows into a single one (our clients have specific needs for this - for example when viewing thousands of rows of products they sometimes see products that are similiar (only colors differ for example) and they want to group all those colors into one single row of that product grouping all those rows to better compare the results along with the other products)
4 - [very low priority]
4.1 public events like:
cell selected
row selected
cell mouse over
4.2 allow adding aditional options to context-menu for a specific cell or set it's custom tooltip
4.3 for debugging purposes - some way of viewing the mdx query being executed
When the new update with olap support becomes available, please let me know and we will start more intensive tests to give you a more accurate and detailed report.
TIA
@Andrea and @Peter
You should have received an email with instruction on how to download the CTP bits.
Any feedback is much appreciated.
All the best,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
We are very interested in evaluating the PivotGrid - we are currently using the DevExpress version of a PivotGrid but are not particularly happy with it. Can we please get the instructions for installing the CTP?
Thanks!
Bill Vanderpol
Anterra Technology
I forgot to mention another very important - high priority - feature for us:
Ability to export the current "configuration/view" - preferably a xml.
Our clients like to create "views" for repetitive (monthly, etc) analysis, basically they select the measures, dimensions, do the groupings,etc and then they save to their user area on the db the xml that the control we are currently using allows to export. That configuration state (xml) will be loaded each time the user want's to use that view (obviously the xml only contains the settings... the data is fetched from the database uppon loading the xml)
I agree with Carlos about the need to allow the user to make configurations and save them and reuse them. This was my number 9 from our first list.
Thanks
We will consider all requested features.
If you think of something else, please let us know.
Kind regards,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Regards,
C.Balaji
You should receive an email shortly. Thanks you for evaluating the CTP.
Regards,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Thank you for your interest. You should receive an email with more details shortly.
All the best,
Milan
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Greetings Telerik - I have some questions and requests....
#1 - Need OLAP support
#2 - Need OLAP support ... (didn't copy paste that - very much need this :) ..
#3 - How come none of the demo/examples online shows a user defined filter criteria? When I add some dimension to as a to the "filter" box, it seems to have no effect - i.e., I get no ability to apply my filter. You have some filter example pages, but they are just hard coded button pushes.
#4 – Does this (or will this) pivot control have multi-select hierarchy controls that are similar to excel?
#5 – How much control do developers have over the style of individual parts of the “PivotFieldList”. So for example:
5.1: suppose I have a dimension that I want to show in RED font – Is that possible?
5.2: suppose I want to apply special business logic that removes dimension ‘Y’ from “Row Labels” automatically whenever dimension ‘X’ is added as a filter. Is that possible?
#6 – You point out that this control scales well with large datasets in one of your examples. But what about a massive dimension? For example, suppose I have a dimension with a million members. If I drop this on the Y-Axis, will this control break? If I drop it as a filter, and then uncheck just one item, will this control generate an exclusionary WHERE clause with just that one member? Or will it generate an inclusion list with the other 999,999 members?
#7, #8, #9 #10…. NEED OLAP Support J
Thanks!
please add me to the list so that we can also evaluate this CTP.
thanks
RadPivotGrid is public CTP now (available for ASP.Net, WinForms, WPF and Silverlight) and you can download it from "My Account" by downloading the lastest release (2012 Q2 SP1).
Demos are available here (for SL & ASP.Net):
http://demos.telerik.com/silverlight/#PivotGrid/Layouts
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx
Now is the time for feedback so please let us know what you think and what you need.
You can use this corresponding forum:
http://www.telerik.com/community/forums/wpf/pivotgrid.aspx
http://www.telerik.com/community/forums/silverlight/pivotgrid.aspx
http://www.telerik.com/community/forums/aspnet-ajax/pivotgrid.aspx
http://www.telerik.com/community/forums/winforms/pivotgrid.aspx
Regards,
Hristo
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Thanks for the PivotGrid. Is there any plan to include the ability to edit/save/design mdx queries?
Also, we are planning to use Pivot grid in ipads. Do you think we would have pivot grids for html too?
Thanks
Currently it is not in our plans to include working with mdx queries. In the moment we are working very hard to provide support for cubes, but we will not have mdx expression editor or render user generated mdx queries. In fact could you share some details why do you need such queries and how do you plan to use them? Maybe we'll find a way to help you with the current planned features. Please share the details and we'll do our best to help you for this problem.
For your second question - the pivot will be available for ASP.NET and it will have support for ipad. Current version is not tested with it, but when we release the official one you shouldn't have any problems using it on ipads.
Thanks for evaluating RadPivotGrid! You can contact us if you have any other questions or suggestions.
Regards,
Rosen Vladimirov
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
"RadPivotGrid is public CTP now (available for ASP.Net, WinForms, WPF and Silverlight) and you can download it from "My Account" by downloading the lastest release (2012 Q2 SP1)."
I can't seem to find any RadPivotGrid related information inside "My Account" nore any download link to the latest release of the RadPivotGrid 2012 Q2 SP1 :(
I did download the TelerikControlPanelSetup_2012_2_809.exe but the RadPivotGrid is not a part of the updates it provides.
Do I need glasses or just some kind of super ninja power access?
Kind Regards
Wolfsberg
when we can expect version of asp.net control that will be able to connect to analysis services cube?
great job and i wait for more;
I noticed you have downloaded RadControls for WPF and Silverlight. The RadPivotGrid is part of them so you are able to use them. For more information how to do it you can check our online demos here. Currently we don't have online help so if you face any problems you can contact us directly.
All the best,
Rosen Vladimirov
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
You can find examples for asp.net PivotGrid here. The RadPivotFieldList will be ready for Q3 and you'll be able to use it.
Currently we are working on the cube support but we are still not ready to give you exact date when it will be ready.
Thanks for evaluating RadPivotGrid and using RadControls.
Regards,
Rosen Vladimirov
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
How can I subscribe for that?
Our RadPivotGrid will have OLAP support. In fact it is currently in development and hopefully it will be ready for our Q3 release (in October). You don't have to subscribe for that, you should download our official releases. As the RadPivotGrid is currently in development you can download our latest internal builds as well and use them, because we are trying to include all new features in these builds. You may follow our discussion in this forum and send us your feedback and suggestions how we could improve the RadPivotGrid.
Hopefully this helps.
Kind regards,
Rosen Vladimirov
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Is there a silverlight version of the RadPivotGrid control?
Thanks.
Yes, there is such version. It is still CTP version, but I'm sure you'll find it very interesting and useful. The RadPivotGrid is part of our RadControls for Silverlight package, so if you have it you are able to use the Pivot. You can check our online demos here for more information and some help how to use it. Don't hesitate to contact us if you have any questions or suggestions.
Kind regards,
Rosen Vladimirov
the Telerik team
Time to cast your vote for Telerik! Tell DevPro Connections and Windows IT Pro why Telerik is your choice. Telerik is nominated in a total of 25 categories.
Now 11/Dec/2012, You Have One Control That Connect To Olap Data Source ?(In ASP.net)
Can I Used Pivot Grid And Connect To Olap DataSource?
RadPivotGrid for Silverlight can use OLAP Cube as data source so you can try it. More information can be found in our online help and in our online demos. Our team is working very hard to provide this functionality in ASP.NET RadPivotGrid and it should be ready for 2013 Q1 release.
Don't hesitate to contact us in case of any problems or concerns.
Regards,
Rosen Vladimirov
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Regards
Mikael
RadPivotGrid is already public and you can find it by downloading our latest official release of RadControls for ASP.NET AJAX. You can find more information here and also in the online help. If you face any problems with RadPivotGrid you can open a new support ticket or forum thread in the respective forum (in your case RadPivotGrid for ASP.NET AJAX (note that this forum is for Silverlight).
Don't hesitate to contact us if you have any suggestions or concerns.
Greetings,
Rosen Vladimirov
the Telerik team
Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.
Hi,
How to remove row from PivotGrid if data is empty or null ? Right now if property is null in Header Row have text '(blank)'
I want have row with different count leve. Right now I can have alway the same numbers of levels.For Example below want to show just two level:
PivotItem.TestDataLevel1 = 'Title 1';
PivotItem.TestDataLevel2 = 'Title 2';
PivotItem.TestDataLevel3 = null;
LocalDataSourceProvider.RowGroupDescriptions.Add(new PropertyGroupDescription { PropertyName = ExpressionMiner.ExtractPropertyName<PivotItem>(val => val.TestDataLevel1 ) });
LocalDataSourceProvider.RowGroupDescriptions.Add(new PropertyGroupDescription { PropertyName = ExpressionMiner.ExtractPropertyName<PivotItem>(val => val.TestDataLevel2 ) });
LocalDataSourceProvider.RowGroupDescriptions.Add(new PropertyGroupDescription { PropertyName = ExpressionMiner.ExtractPropertyName<PivotItem>(val => val.TestDataLevel3 ) });
With the current implementation of the control there isn't built in functionality for achieving the desired. What I can suggest you would be to try adding a Label Filter in order to hide the items with null value. You can also change the text of the blank cells using the EmptyValueText property of the PivotGrid.
Hope this helps.
Regards,
Kalin
Telerik