Null value problem 1

[knulisch]

I have the following formula in my report in order to concatenate two fields (the wine type field will always have a value, the other designation field may not). Sometimes the field will not print any value even though there is a value in the wine type field. Am I missing something?

Thanks for your help.


stringvar x:= "";
If len({entry.entry_other_designation}) < 1
or isnull({entry.entry_other_designation})
or {entry.entry_other_designation} = &quot;&quot; then
x:= {entry.entry_wine_type}
else
x:= {entry.entry_wine_type} & &quot;, &quot; & {entry.entry_other_designation};
x;
[sig][/sig]

 

[kenhamady]

You are hitting the null here:

If len({entry.entry_other_designation}) < 1
or isnull({entry.entry_other_designation})

When you test for the null, it has to be before you use it in another part of the formula. Otherwise you are choking on the Null value before you get to the IsNull function. Reverse this pair of lines and it should work. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]