selection formula

[raghu55]

HELLO
I have feilds like loan.disb_agent-code, loan.lender_sk.

selection : select those records
if loan.disb_agent-code not = loan.lender_sk
and (NULL OR SPACES)

I dint understand that condition.
I was put conditon as, in record selection formula

loan.disb_agent_code<>loan.lender_sk
and
loan.disb-agent-code="NULL"
OR
loan.disb_agent-code="SPACES" ITS NOT WORKING.
I was tried with Isnull(loan>disb-agent_code) its also not working. DO i need any changes more........

 

[synapsevampire]

Bit of a language barrier here, but I'll guess that you want:

(
isnull({loan.disb-agent-code})
OR
trim(loan.disb_agent-code)=""
)
and
(
loan.disb_agent_code<>loan.lender_sk
)

-k

 

[raghu55]

still iam not getting any records

 

[synapsevampire]

Still you haven't conveyed much.

Try eliminating part of the criteria until you get rows, then you'll know why.

I think that you misunderstand the data, or how this is filtering it.

-k

 

[raghu55]

let me clear,

I have to select those records, feild indicateing "NULL" OR "NONE"

 

[synapsevampire]

Meanning that a field has the text null or none in it?

What did you try, and where?

You need to spend more than 10 seconds on your posts, you aren't stating anything meaningful except that it isn't what you want.

Ttry posting:

Crystal version
Database/connectivity used
Example data
Expected output

The formula I posted checks for null of the exitence of a field without anything in it other than spaces.

Simplify it to:

(
isnull({loan.disb-agent-code})
OR
trim(loan.disb_agent-code)=""
)

Does that return rows?

-k

 

[raghu55]

i got rows
thank you.

 

[raghu55]

iam getting rows, but i want to display those records
haveing "spaces

 

[raghu55]

some fields have null
some fields have spaces

 

[Turkbear]

Hi,
Lets try again ( altho you seem reluctant to provide information)

What selection formula are you using?





To Paraphrase:"The Help you get is proportional to the Help you give.."