Records don't add up

[KidFix]

hiya

if I run my report without any form of select it returns 2,565 records.

if I take the same report and use the select expert to return records where op_id = "PPM" it returns 30 records.

if I then take the same report again, but change the select so that the report returns records where op_id <> &quot;PPM&quot; it returns 2,323 records

but I don't understand how this can be surely every single record in the database either has an op_id of &quot;PPM&quot; or not, but why don't the figures add up? I've checked the database and there are no records where op_id is null either. Anyone have any ideas what's going wrong here??

Thanks in advance

 

[kskid]

If I am not mistaken, I seem to recall on one of my selects, it did not pick up any nulls.

See what you get with isnull(op_id)

 

[synapsevampire]

What version of CR and database are you using?

It might be a isnull() concern, try fully qualifying, as in:

isnull({op_id}) or op_id <> &quot;PPM&quot;

-k

 

[KidFix]

how would I select null records in my sf where?

 

[KidFix]

Thanks for the replies

how would I select null records in my sf where?

 

[KidFix]

that is if I'm passing the where clause into the report in a query string in the form of report.rpt?sf={op_id} blah blah, how do I select null values of op_id? thanks again, and sorry for the multiple posts!