Silverlight PivotGrid in UI for Silverlight General Discussions - Telerik Forums

Andrea Rapuzzi

31 posts

Member since:
Apr 2010

Posted 05 Jun 2012 Link to this post

Please add me too.

I really love your products, but please this time be serious about Pivot !

Thanks!

Hristo

Admin

408 posts

Posted 07 Jun 2012 Link to this post

Hi,

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 >>

Michael

22 posts

Member since:
Jun 2012

Posted 08 Jun 2012 Link to this post

Would you please add me as well. I could not make an argument of moving our development tools to yours without a Pivot Grid control

thank you.

John

1 posts

Member since:
Dec 2011

Posted 11 Jun 2012 Link to this post

Please add me as well

Thanks

Milan

Admin

1989 posts

Posted 12 Jun 2012 Link to this post

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 >>

Steven

10 posts

Member since:
Mar 2011

Posted 14 Jun 2012 Link to this post

Hi, could you please add myself to the list?

Cheers,

Steven

Milan

Admin

1989 posts

Posted 15 Jun 2012 Link to this post

Hi,

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 >>

Steven

1 posts

Member since:
Jun 2012

Posted 20 Jun 2012 Link to this post

Please add me to the list as well.
Thanks.

Milan

Admin

1989 posts

Posted 20 Jun 2012 Link to this post

Hello,

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 >>

Morten Bergman

3 posts

Member since:
May 2010

Posted 25 Jun 2012 Link to this post

Milan,
We are looking for a pivot grid as well. Can you please add us to this list? Thank you.

Milan

Admin

1989 posts

Posted 28 Jun 2012 Link to this post

Hi,

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 >>

Annie

11 posts

Member since:
Mar 2011

Posted 28 Jun 2012 Link to this post

Hi,

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.

Milan

Admin

1989 posts

Posted 28 Jun 2012 Link to this post

Hi,

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 >>

Jackie

5 posts

Member since:
Jun 2012

Posted 30 Jun 2012 Link to this post

Hi, can you please add me to the list?
Thanks.

Milan

Admin

1989 posts

Posted 02 Jul 2012 Link to this post

Hello,

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 >>

ngan hong

1 posts

Member since:
May 2011

Posted 02 Jul 2012 Link to this post

can add me to the list? i would like to evaluate the CTP. thanks

Milan

Admin

1989 posts

Posted 03 Jul 2012 Link to this post

Hello,

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 >>

carlos

14 posts

Member since:
Sep 2010

Posted 04 Jul 2012 Link to this post

please add me to the list as well. i would like to evaluate the CTP. thanks

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...)

Milan

Admin

1989 posts

Posted 05 Jul 2012 Link to this post

Hello,

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 >>

carlos

14 posts

Member since:
Sep 2010

Posted 05 Jul 2012 Link to this post

Hi. Thank you, I've received the email and started to take a look at it.
Any suggestions, questions, etc. should be posted here or through the support tickets?

Once again thank you so much.

Milan

Admin

1989 posts

Posted 06 Jul 2012 Link to this post

Hi,

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 >>

James

41 posts

Member since:
Jul 2007

Posted 06 Jul 2012 Link to this post

Hi

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

Keith

91 posts

Member since:
May 2007

Posted 06 Jul 2012 Link to this post

Hi

Please can you provide access to the CTP for me too? Also when are you expecting to release this control?

Thanks
Keith

carlos

14 posts

Member since:
Sep 2010

Posted 07 Jul 2012 Link to this post

Hi,
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.

Travis

11 posts

Member since:
Jul 2011

Posted 07 Jul 2012 Link to this post

Is this grid designed to work with OLAP data sources? Specifically, Analysis Services. Or not? That is the number one need I have for a pivot grid. Without this feature it has a large gap. Can someone explain? Thanks so much!

Semyon Akimov

13 posts

Member since:
Dec 2008

Posted 08 Jul 2012 Link to this post

Add me to list please! I would like to evaluate the CTP. thanks.

Milan

Admin

1989 posts

Posted 09 Jul 2012 Link to this post

Hi,

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 >>

Milan

Admin

1989 posts

Posted 09 Jul 2012 Link to this post

Hello,

@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 >>

Keith

91 posts

Member since:
May 2007

Posted 09 Jul 2012 Link to this post

Hi Milan

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

Milan

Admin

1989 posts

Posted 09 Jul 2012 Link to this post

Hi,

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 >>