Link Multiple Databases WITHOUT Subreport

[Former Member]

Hello,

I have data stored in 2 databases which I want to pull into 1 Crystal report without using a subreport. There is a common ID between tables, so when I link via subreport, the information pulls correctly. However, is there a way to directly link these two databases without a subreport so that all the data is accessible in the main report? I tried to do this but keep getting errors.

Thanks!

[former_member11696]

Hi Dell,

Lots of people do it but it's not supported. You will get a pop up indicating this and to not use other things like Server side grouping or SQL Expressions.

The problem is it can generate multiple starting points so it may or may not be valid data.

Don

[DellSC]

You should be able to do this - lots of folks will use a join to an Excel file to filter their data. What type of file are you connecting to?

First off, I would try using a native Oracle connection instead of ODBC - there are some issues using ODBC with Oracle.

If you remove the file from the report so it's just working off of one data source, does it work? Does the file DSN work to get the data if you don't have a connection to Oracle?

What version of Crystal are you using?

-Dell

[Former Member]

@Dell Stinnett-Christy, thanks so much for the reply! Please also excuse my novice interpretations:

1.) Per IT, we no longer have the native Oracle connection. We only have OBDC.

2.) If I remove the file, YES it works. Both reports work separately. Also, if I dump the data into Excel and link the Excel table to the report, it also works (as you mentioned).

3.) SAP Crystal Reports 2016 Support Pack 2, Version 14.2.2.1975

Thanks again for the help! Much appreciated.

[DellSC]

What type of data are you connecting to in the file?

-Dell

[former_member11696]

Hi Alisa,

No, that is why CR has subreports so you can add one or more data sources.

Create a View Server side or Stored Procedure than it will be one data source.

Don