I'm counting number of appearing of a datafield by:
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: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
0
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
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.