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
>