Link result of formula to table

[mart10]

I am using CR XI

I am stripping out an account code from some data. The resulting code should also be in another table which I need to link to in order to retreive the codes name. How can i link the result of a formula to a field in another table?

 

[Madawc]

Crystal gets table data first and then evaluates tables. You could pass your value to a subreport, but that would take a long time if you did it at detail-line level.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

You can either use the subreport approach where you link the subreport on the formula field, or you could create a command to use as your sole datasource where you build the formula into the linking in the from clause, as in:

select table1.field1, table1.field2, table2.field1
from table1
inner join table2 on
left(table1.acct,4) = table2.acct

-LB