Crystal 8.5 to 9 & Golmine problems

[kevinbellnj]

I have recently found out that CR 8.5 (which was shipped with Goldmine 6) is not completely compatible with Goldmine 6.5 and so you must upgrade to CR9.

Well I have done this and my formula fields have turned to jibberish(sp?)...

I have tried to rebuild the formula fileds in the new appication (CR9) but to no avail.

I have to think that this is a bug or something because when I insert the field it originally is legible. Its when I resize the field to see the entire result that the field turns into something illegible.

I have posted a link to a picture of some screen shots to help visualize what I am talking about.

The formula field is writeen as follows:

StringVar sCompanyNameAddress:='';
StringVar sCompany:= If isnull({CONTACT1.COMPANY})
or {CONTACT1.COMPANY} = ''
then '' else 'Company: '+ {CONTACT1.COMPANY} ;
StringVar sDBA:= If isnull({CONTACT2.UDBA})
or {CONTACT2.UDBA} = ''
then '' else chr(13) + 'DBA: '+ {CONTACT2.UDBA} ;
StringVar sAKA:= If isnull({CONTACT2.UALIAS})
or {CONTACT2.UALIAS} = ''
then '' else chr(13) + 'AKA: '+ {CONTACT2.UALIAS} ;
StringVar sAddress1:= If isnull({CONTACT1.ADDRESS1})
or {CONTACT1.ADDRESS1} = ''
then '' else chr(13) + 'Address: '+ {CONTACT1.ADDRESS1} ;
StringVar sAddress2:= If isnull({CONTACT1.ADDRESS2})
or {CONTACT1.ADDRESS2} = ''
then '' else chr(13) + ' ' + {CONTACT1.ADDRESS2};
StringVar sCity:= If isnull({CONTACT1.CITY})
or {CONTACT1.CITY} = ''
then '' else chr(13) + ' ' + {CONTACT1.CITY} + ', ';
StringVar sState:= If isnull({CONTACT1.STATE})
or {CONTACT1.STATE} = ''
then '' else {CONTACT1.STATE}+ ' ';
StringVar sZip:= If isnull({CONTACT1.ZIP})
or {CONTACT1.ZIP} = ''
then '' else {CONTACT1.ZIP} + chr(13);


Does anybody work with goldmine enough to have seen this before? I am ssuming its a software issue and not a scripting issue because it worked fine in the previous version of the application. This is not the only field, it is happening with any of the formula fields that combine more than one piece of data.

 

[synapsevampire]

Looks whacked alright...

That doesn't look like a Crystal screenshot, is it?

Is there a UFL or a special font used? Try changing the font and seen what it does (before expanding it).

-k

 

[kevinbellnj]

Whacked...yes..
Yeah it is a crystal 9.2.2 screen shot
Tried changing the font - that didn't fix it.

The first picture is what comes out when you insert the formula field

The second picture is immediately after you resize the field to accomodate all of the information that is supposed to be displayed.