expand all columns

[Juliana]

Hello, I've been testing the PivotGrid using local data binding and have some questions:

Is there any way that I can make a button to expand all rows and columns with local data binding? I tried to do that in the column using

pivotgrid.dataSource.expandColumn("Dimension1&Value", "Dimension2");

but the grid's colspan was all wrong (see image attached). Is there any way to fix this? I tried to do the same thing on the row and it works fine.

[Georgi Krustev]

Hello Juliana,

In general, the widget allows to expand the first level of every dimension. If you would like to expand all possible tuples, then you will need to do that manually. Here is a demo that demonstrates how to do that:

• http://dojo.telerik.com/@ggkrustev/eNOxu

Note that you need to pass the fully qualified path of the tuple. The path actually is all unique names of the parent members plus the unique name of the concrete tuple member which we are about to expand.

Regards,
Georgi Krustev
Telerik

 

 

[Juliana]

Hi,

I am using this code to expand the rows:

pivotgrid.dataSource.expandRow(["Submercado"]);
pivotgrid.dataSource.expandRow(["Submercado&Sul", "UF"]);

 which generates the result shown on image 1, which is absolutely correct.

 When I wrote this code to expand the columns:

pivotgrid.dataSource.expandColumn(["Ano"]);
pivotgrid.dataSource.expandColumn(["Ano&2015"]);

you can see the result on image2 attached. As I've wrote in my question, the colspan that generated is all wrong, you can see in the image that the months are not aligned at all with the grid content. How can I fix this?

 

Also, which verson of the jquery.min.all.js is the most recent? I just download the kendo ui and it came with the v2015.2.624, but on a dojo demo I found a v2015.5.805, which corrects some of the bugs that I have had with expanding columns. Which one should I use and is the most recent?

[Juliana]

Also, when I added this code:

pivotgrid.dataSource.expandColumn(["Ano"]);
pivotgrid.dataSource.expandRow(["Submercado"]);
pivotgrid.dataSource.expandRow(["Submercado&Sul", "UF"]);

you can see in the image attached that the rows are correct, but take a look at the columns (again, they are not aligned with the months)​

[Juliana]

forgot to add the attached file

[Kiril Nikolov]

Hello Julia,

I was not able to reproduce the problem locally, this is why I would like to ask you to send us a runnable project that we can use to reproduce the issue and see what exactly is causing this behavior. Thanks in advance.

Regards,
Kiril Nikolov
Telerik

 

 

[Juliana]

http://dojo.telerik.com/ElEsa/3

[Kiril Nikolov]

Hello Juliana,

 

This looks like an issue with the PivotGrid that I have logged in our internal bug tracker and it will be fixed with an upcoming build.

 

Thanks for bringing this up.

 

Regards,
Kiril Nikolov
Telerik

 

 

[Joey]

I am encountering this same issue now.  Is there any update on when this will be resolved?

[Kiril Nikolov]

Hello,

It should be resolved with the latest version.

Can you please provide your setup in a separate ticket that we can look at?

Regards,
Kiril Nikolov
Telerik by Progress

[Joey]

One of my coworkers that I am working on my project with has already submitted a ticket for larger issues we are having with the pivot grid.  I think I will use that ticket to resolve this issue one the larger issues are resolved.