<div>
I don't believe you can link tables from different datasources in CR.<br />
<br />
Can you modify one or the other database? &nbsp;Are they the same type of database?<br />
<br />
If you have 2 Access databases yu can create a linked table in one to the table in the other. &nbsp;You could then join the tables. &nbsp;<br />
<br />
Don't know if that will work or not in your case.<br />
<br />
mlmcc
</div>


I don't believe you can link tables from different datasources in CR.

Can you modify one or the other database?  Are they the same type of database?

If you have 2 Access databases yu can create a linked table in one to the table in the other.  You could then join the tables.  

Don't know if that will work or not in your case.

mlmcc

<div>
DO you have smart-linking on by chance?<br />
<br />
In CR7 it is in FILE --&gt; OPTIONS<br />
on the database tab.<br />
<br />
mlmcc
</div>


DO you have smart-linking on by chance?

In CR7 it is in FILE --> OPTIONS
on the database tab.

mlmcc

<div>
<div class="content wysiwyg-content">
In CR8.5, when I join two tables from two different data sources, I encounter the following problems.<br />
<br />
1) &nbsp; &nbsp; We are unable to specify the type of join (In Report Expert-Link Options, Equal is checked. All SQL Join types are disabled).<br />
<br />
2) &nbsp; &nbsp; ‘Show SQL Query’ menu option (in Database Menu) is not enabled. This is enabled only when the selected tables are from same data source.<br />
<br />
In Short, OUTER JOIN is not possible in the above case. But I need to edit the query to make the join outer. How can i do that? Please suggest me a solution.<br />

</div>
</div>


In CR8.5, when I join two tables from two different data sources, I encounter the following problems.

1)     We are unable to specify the type of join (In Report Expert-Link Options, Equal is checked. All SQL Join types are disabled).

2)     ‘Show SQL Query’ menu option (in Database Menu) is not enabled. This is enabled only when the selected tables are from same data source.

In Short, OUTER JOIN is not possible in the above case. But I need to edit the query to make the join outer. How can i do that? Please suggest me a solution.


A Join Problem

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.