Linking by formula field

[paulcedarhill]

Using Crystal 10 with a sql database in ODBC I need to be able to link to a table using a formula field.

I need to be able to print a sales rep's name from table.users that is read from one of 2 fields in table.contacts, contingent on the value of a different field for product line in table.contacts.

I have written an if statement to bring in the correct "rep", but now need to pull their name from the table to print in a letter.

Dim rep as string
IF {tblMemo_Details.fldCategory_Desc} = "Wall Coverings" Then rep = {tblMemos.fldWC_Rep} else rep = {tblMemos.fldAP_Rep}
formula = rep

Thanks in advance

 

[dgillz]

You cannot link on formula fields in crystal, you must use a subreport.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[paulcedarhill]

Thanks, I was not aware of the link option to fomula fields, that is great. I got it to work wit hsome gyrations of suppressing sections in order to make it fit the main report forms.

Thanks again.