filtering (blank) from columnfield

1 posts, 0 answers
  1. DANA
    DANA avatar
    19 posts
    Member since:
    Dec 2010

    Posted 01 Jun 2020 Link to this post

    I'm tring to remove the "(blank)" value from my columns values .

    the field  "aircraft" has blank values and I want to ignore the blank column.

    I've tried several things from code behind (working with vb.net) and nothing happens.

    If I try filtering this field from the webpage, I get an error of :

    "cannot convert object of type 'system.string' to type 'telerik.web.ui.pivotgrid.core.nullvalue'

    <telerik:RadPivotGrid RenderMode="Lightweight" AllowPaging="true" PageSize="10" Height="500px"
                  ID="RadPivotGrid1" runat="server" allowfiltering="true" emptyvalue="0">
                  
                  <Fields>
      
                      <telerik:PivotGridColumnField DataField="aircraft" showgroupwherenodata="false">
                      </telerik:PivotGridColumnField>
                      <telerik:PivotGridRowField DataField="Category" ZoneIndex="0">
                      </telerik:PivotGridRowField>
                      <telerik:PivotGridRowField DataField="ProductName" ZoneIndex="1">
                      </telerik:PivotGridRowField>
                   
                      <telerik:PivotGridAggregateField DataField="emp_num" Aggregate="count" >
                      </telerik:PivotGridAggregateField>
                    
                  </Fields>
                  <totalsettings rowgrandtotalposition="last"      />
              </telerik:RadPivotGrid>

     

Back to Top