Sage 100 Version 5.20

Crystal 2011 for Sage

Window server 2012 R2 

Ok, here is an odd one.  We had been having incorrect data running a Inventory List via Crystal.  We have a total of 600 items.   When I add a filter for Category 2 data I am getting back an incorrect number of items.   With further testing, I decided to run the following filter:  Category2 <> "X".    We don't have any Category "X" data, so 600 records should be returned.  But that is not what happens.  I get back 230 records.   I look at the raw data in the DFDM and Category2 looks fine.  I entered an X via DFDM and removed it to see if that made a difference but it does not.    I exported both sets of data into Excel to compare the list with 600 and the list with 230 and I can't see any pattern.  I then ran the "Canned" Sage reports, "Inventory List" and used a filter Category2 "does not equal"  X.  All 600 records appeared.  So it seems as though this will only happen in my crystal report. 

Actions I have taken

1)  Rebuild/Reindex

2) Created the report from scratch, using only the CI file.  

3) Tested the other Categories, 1,3, and 4.  I have no problems with those, only Category 2.

4) I tried running the report on another server, with another installation of Crystal.

5)  This happens running the custom report when added to Sage's Custom Report or Outside; it does not matter

Any suggestions would be appreciated.   We have several custom reports that use the Category 2 field.  

Update:  Apparently the other 3 Category fields are affected.  I am finding if the fields are blank (null), is when this happens.  So if the field is blank, and I enter a filter for a value that does not exist, the blank records are not being returned.  This must be a setting in Crystal?  Still stumped. 

p.park

I.T. Manaager