Crystal 8.5 Crashes on particular field.

[chuchuchui]

I am using Crystal 8.5 on Windows 2000 using IBM Universe Database. I am having trouble with a column called COVCLIMIT on my HO_COVERAGES table. I have six of these type of columns which all contain numeric data or NULL values. I set Crystal to convert NULL Field Value to Default. The five columns all return the numeric data they contain, COVALIMIT to COVFLIMIT (A though F). Everytime I try to run it to display COVCLIMIT the program crashes. Is there anyway to figure out what record it doing this?

 

[Madawc]

I can't explain your problem, but I can suggest a work-round, involving not trying to convert nulls. Instead adjust your report to handle them. E.g.

if isnull({your.amount}) then 0 
		         else {your.amount}

or

if isnull({your.date}) 
or {your.date} in [{Start-Date} to {End-Date}) then "OK"
else "not"

I hope this helps.

Madawc Williams (East Anglia, UK)