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>