Hidding (Blank) Data in PivotGrid

2 posts, 1 answers
  1. Pierre
    Pierre avatar
    56 posts
    Member since:
    Jun 2016

    Posted 17 Oct Link to this post

    1/. My DataBase SquetchUp , and Request:

    I have those 2 table :
    Table_EC:                                   Table_P:
    +------+---------+------------------+       +---------+--------+--------+
    | Name | IdValue | ManyOtherInfo... |       | IdValue | Value1 | Value4 |
    +-----------------------------------+       +---------------------------+
    | STR  |  INT    |     ManyTYPE     |       |  Int    |  Label | OrderBy|
    +------+---------+------------------+       +---------+--------+--------+

    In order to diplay in a cross table  I do this request:
    SELECT  NAME , VALUE1
    FROM Table_EC
      RIGHT JOIN Table_P
       ON Table_EC.VALUE1= Table_P.VALUE1
    ORDER BY PAR_VALEUR4

    2/. Telerik MarkUp 
    My `RadPivotGrid` declaration:

    <telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" OnNeedDataSource="RPG_RECAP_NeedDataSource" >
    <TotalsSettings RowGrandTotalsPosition="None" RowsSubTotalsPosition="None" />
    <Fields>
        <telerik:PivotGridAggregateField GrandTotalAggregateFormatString="" CalculationExpression=""
            UniqueName="Statut" DataField="Value1" Aggregate="Count"  >
            <TotalFormat Level="0" Axis="Columns" TotalFunction="NoCalculation" SortOrder="Ascending" />              
        </telerik:PivotGridAggregateField>                       
        <telerik:PivotGridRowField UniqueName="RowCLI" DataField="Name" />
        <telerik:PivotGridColumnField UniqueName="ColumnStatut" DataField="Value1" />     
    </Fields>
    </telerik:RadPivotGrid>


    3/. Current Result:

    Current Result.
    The expected result are the same but with out the (Blank) Row
    **How do i achieve this ?**

  2. Answer
    Pierre
    Pierre avatar
    56 posts
    Member since:
    Jun 2016

    Posted 18 Oct in reply to Pierre Link to this post

    SOLVE: Count on a null value in the AggregateField Here ValueID.
    Set IgnoreNullValues="true" And ShowGroupsWhenNoData="false".
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top