asked on

Crystal Reports - problem displaying informationwith common fields

I'm having a problem getting a particular field to display properly. There are two tables and her is the issue:

table1.original_original_vendor_id
table1.vendor_to_send

table2.vendor_id
table2.vendor_name

The tables are linked:
table1.original_original_vendor_id ----> table2.vendor_id (full outer join)
table1.vendor_to_send ----> table2.vendor_id (full outer join)

I'm using full outer joins because there is not always data to populate each record. Sometimes they are blank and that's okay.

The report correctly displays both table1.original_original_vendor_id and table1.vendor_to_send, but when I drop in table2.vendor_name, nothing is displayed.

How can I get the table2.vendor_name to display when it is linked to both table1.original_original_vendor_id and table1.vendor_to_send?

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GStoner

ASKER

table1.original_original_vendor_id and table1.vendor_to_send do have the same values.

I did not know you could add a table twice as an alias. I followed that suggestion and liked them separately and the report works fine.

Once again - thank you for your help and quick response.

GStoner

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for GStoner's comment #a39883406

for the following reason:

See my last comment.

Mike McCracken

Why accept your comment when my comment answered the issue.

mlmcc

GStoner

ASKER

I accidentally selected my response instead of the actual solution. Please cancel the close request so that I can choose the proper accepted answer. Thanks

GStoner

ASKER

Thanks for your help.

Mike McCracken

No problem. That is one reason the closure like that has a waiting period.

mlmcc