How to do a FULL OUTER JOIN? 1

[BeginnerUser]

Hi there,
Can anybody help? How do I do a full outer join in crystal? I have crystal 8.5. Thanks!!!!

 

[synapsevampire]

If you database supports it, just create a LEFT OUTER JOIN in Crystal, then go to Database->Show SQL Query and manually change the LEFT OUTER JOIN to a FULL OUTER JOIN.

Keep in mind that all changes will have to be done manually from that point forward.

Try to create a View or SP to handle this.

-k

 

[shokti]

open your report in crystal and goto database in the menu & select visual linking expert. link the tables to their respective fields. right click the link & select option then in the join type select the left outer join then click ok. your table is now joined.

 

[BeginnerUser]

Thanks synapsevampire,
When you say "all changes will have to be done manually from that point forward.", do you mean changes to the link only? Or all changes including the select expert and everything else?

What do you mean by SP? Thanks so much, I did it thru a view.

 

[synapsevampire]

Shokti: They wanted a Full Outer, not a Left Outer.

BU: SP = Stored Procedure
I mean that anything in the report that might effect SQL will have to be handled manually.

Create the report without the FULL OUTER, then when you're done, go manually adjust the SQL. I'd also keep a copy of it without the SQL adjusted to simplify maintenance.

-k

 

[BeginnerUser]

Thank you so much, I really appreciate it!