I'm trying to programmatically achieve filtering out of empty strings in a column.
I.e. I wish to automatically set up the second grid in my attached image.
I've tried:
suffixFilter.DistinctFilter.RemoveDistinctValue("");
suffixFilter.DistinctFilter.RemoveDistinctValue(".");
suffixFilter.DistinctFilter.RemoveDistinctValue(string.Empty);
and also:
suffixFilter.FieldFilter.Filter1.Operator = FilterOperator.Contains;
suffixFilter.FieldFilter.Filter1.Value = ".";
but these only achieve the first grid. Please help!
Many thanks,
R