Sage 100

BIE - Business insight explorer Filter to include null or blank values We are using BIE to display information on sales orders and we have an issue with filters that seems odd. We are simply trying to see all orders that do not have ""PLANT"" in the ""Ship via"" field. If we set a filter for ""Ship Via Does not equal PLANT this filters out all of the PLANT orders but it also filters out any orders that have a BLANK ship via field. I can duplicate this in ABC company. . Has anyone run into this? I have not found a workaround yet and they are going to go live next week and sort of need this. I'll open a case with Sage if nobody has a suggestion.

OK this is my inexperienced use of filter (and BIE in general) I was completely ""not seeing"" the I could put an OR statement and do Ship Via does not equal PLANT OR Ship Via IS BLANK. that was my workaround. But I still have to whine and point out that BLANK is not equal to PLANT and should have shown up in the first place.

It appears that BIE has the same problem that you run into with SQL Server. A field with nothing in it, in this case, is a NULL field rather than a blank field. In Crystal you can check a box to tell it to treat NULL as blank. I could not find anything in BIE that allows the same thing. I suppose you could create a calculated field from the ShipVia and use the IFNULL() function to make the null values into blanks. What a pain!