I have a crystal report written for Goldmine CRM. I wanted to run the report independently. In one of the formula fields displayed on the report, the formula says
GMSMContactRecordbyField('Contact1','Company',Cal. ACCOUNTNO}). When I try and check for errors I get the message that the remaing text not part of the formula. I understanding is that instead of displaying the account number on the report they want to display the associated company name and the account no is stored in a table called CAL and the company name is stored in the table CONTACT. In other wors they want to join the two tables on the basis of the accountno field. How do I write the formuls in such a case without using the report expert. I mean I wanted to create the report manually.