Select Expert 1

[needmoremoney]

Is there a way to filter out a complete line of records based on one field?

Example

Jobcode Id Name Amount1 Amount2
1 12 JH 123.09 333.22
1 12 JH 333.34 543.02
11 HK 222.22 1211.03
3 11 HK 233.33 333.33
5 32 AX 234.23 233.11

See.. for the third roll, I want to omit the entire line because there is no jobcode. The jobcode field is a string field. I tried this through the select expert but couldn't get it working.

Any ideas? Thanks much..

 

[synapsevampire]

Try Report->Selection Formula->Record:

isnull({table.jobcode})
or
trim({table.jobcode}) = ""

-k

 

[needmoremoney]

Hmmm. doesn't seem to work.

 

[synapsevampire]

Sorry, I gave the the reverse...

Should be:

not(isnull({table.jobcode}))
and
trim({table.jobcode}) <> ""

-k

 

[needmoremoney]

Hey synapsevampire, Thanks much. The codes works great but I found out that what I wanted to do was totally different from my original thought process. Thanks much.