PivotGrid ignoring values dragged and dropped into row fields

[Derek]

We have a pivotgrid that isn't working correctly. The data comes from a stored procedure that de-normalizes a bunch of data, so that users can do ad-hoc querying on the results. The table can run into several hundred thousand rows.

This used to work correctly, but recently (perhaps with the q2 2014 update?) we've noticed issues. Drag a column into the row columns group, wheel spins, eventually the original table returns with no column breakdown. Sometimes (not consistently) we can get it to work by right-clicking, selecting 'Move to COLUMN field', generate, then right-click and move to row field.

We were using Ajax on the grid, tried removing that with no change. We've tried deferring the layout update, no difference. It seems the columns that cause the issue are usually text columns, but there is no error thrown and nothing reported on screen, just no column breakdown.

The frustrating thing is this used to work, and neither code or data has changed. Here's the code used to generate the pivot. The data source is an objectdatasource, using a query running against SQL Server.

<telerik:RadPivotGrid ID="pivotData" runat="server" AggregatesLevel="-1" AggregatesPosition="Columns"
        DataSourceID="dsExpenditures"
        ShowColumnHeaderZone="False" ShowDataHeaderZone="False" ShowRowHeaderZone="False" EnableConfigurationPanel="true"
        Skin="Metro">
        <Fields>
            <telerik:PivotGridAggregateField Caption="Total Spend" DataField="TotalSpend" UniqueName="TotalSpend"
                DataFormatString="{0:n2}">
            </telerik:PivotGridAggregateField>
        </Fields>
        <ConfigurationPanelSettings LayoutType="OneByFour" Position="Left" DefaultDeferedLayoutUpdate="true">
        </ConfigurationPanelSettings>
    </telerik:RadPivotGrid>

[Nils C.]

We have the same bug. Its reproducable in the telerik demos:http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/applicationscenarios/persisting-radpivotgrid-settings/defaultcs.aspx

1. Uncheck ProductName
2. Drag ProductName to the Row Fields
3. Click Update

Product Name is missing under Row fields. This is working in the previous telerik version. Is there a workaround. This is a critical bug for us...

[Maria Ilieva]

Hi Derek and Nils,

I tested the online demo that Nils reported to present a problematic behavior and I could confirm that this issue is a bug and I already logged it into our tracking system.
However we could not be completely sure if the issue reported by Derek is the same or related to the one logged on our end.
Therefore in order to be able to further investigate the concrete problem, I would suggest you Derek, to open a regular support ticket and send us a sample runnable application that demonstrates the issue you are facing.
Thus we will be able to debug it locally and decide if this is separate bug or is related to the one that Nils reported.

Thank you for your feedback.


Regards,
Maria Ilieva
Telerik

 

 

[Derek]

This is exactly the same problem. I also tried something we have discovered that sometimes gets us around the issue.

- Remove product name from pivot.
- right-click product name, and choose 'Move to Column Fields'
- Update. Most of the time (but not always) the product name will appear as a column field.
- Right-click product name and choose 'Move to Row Fields'. Sometimes it will show up properly as a row field.

It doesn't seem to work if you try to move it directly to a row field. You can reproduce the same behaviour in your example with the CategoryName field. As Nils said, this problem only occurred with this version.

[Maria Ilieva]

Hello Derek,

I have added the additional information you have provided in the bug log and our dev team will take it in consideration when the bug is further research.

Thank you for your great cooperation.

Regards,
Maria Ilieva
Telerik

 

 

[Derek]

Wondering if there is any update on this.

[Radoslav]

Hi Derek,

The described issue was fixed and the fix is available into the latest internal build. Also it will be included into the official Q3 2014 release.

If you need further assistance, do not hesitate to contact us again.

Regards,
Radoslav
Telerik

 

 

[Derek]

How do I access the latest internal build?

I also note that the issue still exists in your online demo, as noted earlier.

[Maria Ilieva]

Hi Derek,

Note that the online demos are uploaded only on official releases which means that the current version of the demos still does not include the mentioned fix.

You could access the internal build for downloading by login to your Telerik account and use the link below.

http://www.telerik.com/account/your-products/internal-builds.aspx

Note that the Q3 2014 Beta release is scheduled this Wednesday , which means that you could directly download the beta instead of using the internal build.

Regards,
Maria Ilieva
Telerik

 

 

[Derek]

Thank you Maria;

Do the beta releases appear in the Control Panel? Or must they be downloaded from somewhere else, like the internal builds?

I still don't see any update today; I'm assuming the beta release hasn't happened yet.

[Maria Ilieva]

Hello Derek,

The Beta release was postponed with one day, but it was officially uploaded yesterday (2nd of October). It is available for downloading now, so that you could already test the fixes on your end.

Regards,
Maria Ilieva
Telerik