OK so I'm running a report against a table based on the status field.
I want to return all rows where the status field is not DISABLED or DISPOSED.
The problem is that I thought this would also bring back all rows where the status field is NULL, however it doesn't. I think that this gives me a misleading view of the data. Is there an option somehwhere in crystal so that this data will also be returned?
Any help will be much appreciated!
IP Logged
