Formula result question 2

[Crystalfire]

I have a simple formula
{QUOTE.CITY}+" "+{QUOTE.STATE}+" "+{QUOTE.ZIPCODE}
which sometimes works fine and other time does not bring over any info when there should be. If I use the fields by themselves then the info comes over. Any ideas would be apprieciated.
Using Crystal 8.5

 

[sim133]

You may have a null value in one of your fields. Try it by convertion null values to default values using Reporting Option

 

[synapsevampire]

Try:

whileprintingrecords;
stringvar MyCityStZip:="";
if not(isnull({QUOTE.CITY})) then
MyCityStZip:={QUOTE.CITY} & " ";
if not(isnull({QUOTE.STATE})) then
MyCityStZip:=MyCityStZip & {QUOTE.STATE} & " ";
if not(isnull({QUOTE.ZIP})) then
MyCityStZip:=MyCityStZip & {QUOTE.ZIP};
MyCityStZip

Or you can turn on the File->Report Options->Convert null values to default and it will handle it for you.

-k

 

[BobSuruncle]

Or just place the 3 fields into a Text Object with a space between the fields.


Bob Suruncle