Manualy link 2 unlike fields

[Golfnit]

Hello all!

Crystal Reports 8.0
Direct Database on local HD

I have a Database field ‘FieldA’ that contains 4 characters; I have chopped off the first 3, which leaves me with 1. I used this formula:

StringVar TmpString: = Right({FieldA},1)

I need to “link” this one character (or the variable ‘TmpString’) to the field ‘FieldB’ in database 2. I ultimately want the ’FieldC’ to show up in the report.

DB 1 DB 2 DB 2
-------- ----------------------
FieldA FieldB FieldC
-------- ------ ------
NNNC A Joe
NYND B Bob
NYYX C Scott
NNNZ D Ann

I have thought about a loop to search database 2 for the link between TmpString and FieldB. But I don’t know if that is possible.

Thanks in advance!

 

[dgillz]

The only way to link on formula fields is to use subreports.

Make the formula field in the main report and link to the other table in your subreport with the formula field linking to FieldB of DB2. Any subtotaling involving both the main and teh subreport will have to be done with shared variables. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com