This is a migrated thread and some comments may be shown as answers.

PivotGrid ignoring values dragged and dropped into row fields

10 Answers 162 Views

PivotGrid

This is a migrated thread and some comments may be shown as answers.

Derek asked on 18 Aug 2014, 08:28 PM

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>

10 Answers, 1 is accepted

answered on 21 Aug 2014, 12:46 PM

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

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

answered on 21 Aug 2014, 02:47 PM

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.

answered on 29 Sep 2014, 09:34 AM

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

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.