Hi everybody,

I'm quite new to Crystal Reports, I'd really appreciate it if you could help me out.

I need to display a field that is on a different table into my report, if I just drag the field directly from another table the report just hangs.

Here's an example of what I'm talking about...

I've got a table called "enterprise", which I used on the main report, then there's a second table called "enterprise_status".

Enterprise Table
==================
ent_id
ent_name
...
...
enterprise_status_code
country_code


Enterprise Status Table
==================
enterprise_status_code
enterprise_status_descr

Now on the main report I need to display the enterprise status description which is in the second table. At the moment to make the report work I had to add a new field with the following formula.

if {enterprise.enterprise_status_code} = "00" then "NO STATUS" else
if {enterprise.enterprise_status_code} = "01" then "STATUS DESCR 1"else
if {enterprise.enterprise_status_code} = "02" then "STATUS DESCR 2"else
if {enterprise.enterprise_status_code} = "03" then "STATUS DESCR 3"

The above code works fine but now I need another field called country, and I can't write the same kind of formula because there are too many countries.


Country Table
==================
country_code
country_name


Thanks in advance!

No I didn't, how do I do that? The only thing I was able to link is a sub-report.

Thanks a lot, it works!