CODEWITHSUNDEEP
crystal-reportscrystal-reports-xi
Vbasic4now
Vbasic4now

Reputation: 589

Crystal reports selecting record that contain empty strings or "null"

I have a report that for a field called JobNo there are some records that have "null" as the the cell value and some that have an empty string "". there is another field called AccntNo that im also selecting by in the same selection formula.

This is what i have tried without success in the selection formula for crystal reports.

{accnt.accno} = "7015" and
{accnt.jobno} = "" or {accnt.jobno} isnull

any help is apreciated

Upvotes: 0

Views: 2024

Answers (1)

Emanuele Greco
Emanuele Greco

Reputation: 12721

Selection formula doesn't work as expected, sometimes.

I suppose that this will work

{accnt.accno} = "7015" and
( isnull({accnt.JobNo}) or {accnt.jobno} = "" )

First of all I put parenthesis on 'or' clause.
But, the strangest thing, is that isnull clause must be evaluated before other comparison clauses.

Upvotes: 2

Related Questions