Database Join based on Formula Result

[gtrthang]

OK, Here is my Data.

Table Bug1 - has several returned column, but here is the column in question.

Assoc Defect
10360, 10237, 10012, 8544
10805
8208

Bug2

Defect Status
10360 Open
10237 New
10012 Closed
8544 Ready for Retest
10805 New
8208 New

On Bug1, I've written a formula to split Associated Defect field into into separate columns on the report (for up to 5 values) The first formula (named Defect1) for this is:

if Length ({BUG.BG_USER_24}) > 0 then
ToNumber(
if Length ({BUG.BG_USER_24}) < 6 then
Mid ({BUG.BG_USER_24}, 1, 5)
else
Mid ({BUG.BG_USER_24}, 1, InStr ({BUG.BG_USER_24}, &quot;, &quot - 1)
)

and there are other versions of the same for each other iteration. (formulas Defect2-Defect5

What I want to do is use the results of Formulas Defect1 to Defect5, so link to Table Bug2 to get the Status field.

Is there a way to do this?

Thanks for your help.

 

[dgillz]

You cannot link tables on a formula field. You have to write a subreport, and link the subreport on the formula field.

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

http://www.trianglepartners.com