Using record selection to display a 'blank'

[petercav]

Hi everyone,

Is it possible to have a record selection which picks up everything without a value in a file?

Iam using AS400 and what i want to do is display results when there is no value in table 'LHDES'

Any ideas?

thanks

 

[Madawc]

In Crystal 8.5, do a left-outer link, so the value need not be there.

Do a test for a field on the file having a null value:

if isnull({file.accno})

Choose something that can't be null except where the record is missing. That should do it.

Madawc Williams
East Anglia, Great Britain