Hi All,

First post here, I am a relative newbie to Crystal, just been using it on and off with my job. Been asked to amend a current report we do so that it includes records with No Values in a certain field. I have managed to do this by adding a ISNULL and Not(isnull) statement to the record selection.

This is great, it includes the previously excluded values I was missing before. The problem is now that another part of my record selection is being ignored for some reason.

I'll attached screenshots so that it's easier to see what I mean.

Please see attached album:Link to album

Hi Kevlray.

I'm essentially trying to retrieve all the part numbers in a range (E1 - F99999) that includes all the part numbers that may not have a supplier code attached to them, which is why I felt the need to put in the ISNULL and NOT(isnull) statements.

The report now includes the Part numbers without supplier codes however its also including some part numbers which are not within the range E1 to F99999 as shown in the last picture.

I'm just at a bit of a loss on how to rememdy this.