Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Golmine 6to 6.5 AND Crystal 8.5 to 9 problems

Status
Not open for further replies.

kevinbellnj

IS-IT--Management
Apr 15, 2004
11
US
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.

CR_before.gif

CR_after.gif


The formula field is written 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top