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

filtering (blank) from columnfield

0 Answers 41 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
DANA
Top achievements
Rank 1
Veteran
DANA asked on 01 Jun 2020, 07:50 AM

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>

 

No answers yet. Maybe you can help?

Tags
PivotGrid
Asked by
DANA
Top achievements
Rank 1
Veteran
Share this question
or