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>