Empty Field

[Steve95]

Hi All

I have a report in CRXI Rel 1, from data source Stored Procedure. In one of fields which is data type 'String' their are blank values.

I need these blank values to return in my report, however I have tried every

where {field} = " "
isnull ({field}) etc etc

and I am running out of options.

Anyone any ideas how to return blanks from a SP?

Many Thanks

 

[TheBlondOne]

try

where isnull({field}) or
trim({field}) = "" or


-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[Madawc]

To expand on TheBlondOne's answer:

When writing formulas, any test for null values must come first. Without isnull, Crystal will stop processing the formula when it hits a null value; the default assumption being that null means show nothing. I made this mistake several times while I was learning Crystal, because it's not obvious to someone who's used to other programming languages.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10