Syntax for no record found

[mouser4069]

What is the syntax for "no record found" in Crystal"?

We are writing a pending report and the pending formula is returning one record when there is none. We are trying to suppress various things in our checkbreak such as OnFirstRecord and OnLastRecord, else... However, we need the syntax for no record found.

Any help?

 

[synapsevampire]

There isn't specifically, there's a recordnumber function, which might serve your purposes.

Another way is to check for null against a column which could never be null, such as:

if isnull({table.recordid})
or
recordnumber = 0 then
"no records found"

-k