Multiple Datasources in one report

I am very new to crystal so please excuse if this is a basic request...

We are using Crystal 9.2. I have two datasources, one in oracle and the other in sqlserver. I need to join the two datasources together with the full outer join option, but that option is grayed out in the Links tab in the Database expert window. I basically need to do a UNION ALL between the two datasources, I want to display all the rows from both datasources. Is this possible? What am I missing? Do I need to use a subreport? I need to do grouping/totaling between the two datasources.

What would be ideal, is if I could create a view between the two datasources (using the union all option) and then use that view as the datasource for the report. Is there anything like this available?

Any pointers would be greatly appreciated!Migrate data and keep them in a single datasource