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

Why PivotGrid shows "1" when no data?

1 Answer 20 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Tim
Top achievements
Rank 1
Tim asked on 26 Jul 2014, 09:01 PM
I'm counting number of appearing of a datafield by:
<telerik:PivotGridAggregateField DataField="StatusText" Aggregate="Count" Caption="Counts" UniqueName="Counts" IsHidden="false">
</telerik:PivotGridAggregateField>

The problem appears when I run the pivotgrid, there's a field of (blank) keeps on coming up with a value of "1" unexpectedly. I can see one common point for all (blank) data, they seem to happen to any columns that has no data in it. For Instance, in January 1st. I have no data for that day and the grid gives a value "1" with statustext = (blank) as a substitution. 

What property can I set to stop this? Below is my RadPivotGrid Settings. Thanks.
<telerik:RadPivotGrid ID="RadPivotGrid_DataView" runat="server" ConfigurationPanelSettings-DefaultDeferedLayoutUpdate="false" Height="100%" AggregatesPosition="Rows" AllowSorting="True" OnItemCommand="RadPivotGrid_DataView_ItemCommand" OnCellCreated="RadPivotGrid_DataView_CellCreated" DataSourceID="Sql_Contract_Details" EnableToolTips="True" EnableZoneContextMenu="True" EnableConfigurationPanel="True" OnFieldCreated="RadPivotGrid_DataView_FieldCreated" Skin="Metro" OnCellDataBound="RadPivotGrid_DataView_CellDataBound" Culture="en-GB" OnItemNeedCalculation="RadPivotGrid_DataView_ItemNeedCalculation" AllowPaging="True" PageSize="30">
                       <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox" AlwaysVisible="True" />
                       <Fields>...</Fields>
                       <ClientSettings EnableFieldsDragDrop="True">
                           <Scrolling AllowVerticalScroll="True"></Scrolling>
                       </ClientSettings>
                       <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" DefaultDeferedLayoutUpdate="True" LayoutType="OneByFour"></ConfigurationPanelSettings>
                   </telerik:RadPivotGrid>

1 Answer, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 31 Jul 2014, 07:20 AM
Hi Tim,

The described behavior is really strange and in order to advice you how to prevent it we need to replicate it first. Therefore, I would like to ask you to open a support ticket and send me the data source of RadPivotGrid,  as I guess the problem is related to the data rather than the pivotgrid.

Regards,
Pavlina
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.

 
Tags
PivotGrid
Asked by
Tim
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Share this question
or