Why PivotGrid shows "1" when no data?

2 posts, 0 answers
  1. Tim
    Tim avatar
    57 posts
    Member since:
    Oct 2013

    Posted 26 Jul 2014 Link to this post

    I'm counting number of appearing of a datafield by:
    <telerik:PivotGridAggregateField DataField="StatusText" Aggregate="Count" Caption="Counts" UniqueName="Counts" IsHidden="false">

    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" />
                           <ClientSettings EnableFieldsDragDrop="True">
                               <Scrolling AllowVerticalScroll="True"></Scrolling>
                           <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" DefaultDeferedLayoutUpdate="True" LayoutType="OneByFour"></ConfigurationPanelSettings>
  2. Pavlina
    Pavlina avatar
    6182 posts

    Posted 31 Jul 2014 Link to this post

    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.


    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.

Back to Top