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

Hidding (Blank) Data in PivotGrid

1 Answer 18 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Pierre
Top achievements
Rank 1
Pierre asked on 17 Oct 2016, 02:34 PM
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 ?**

1 Answer, 1 is accepted

Sort by
0
Accepted
Pierre
Top achievements
Rank 1
answered on 18 Oct 2016, 09:33 AM
SOLVE: Count on a null value in the AggregateField Here ValueID.
Set IgnoreNullValues="true" And ShowGroupsWhenNoData="false".
Tags
PivotGrid
Asked by
Pierre
Top achievements
Rank 1
Answers by
Pierre
Top achievements
Rank 1
Share this question
or