Skip to Content
0

Link Multiple Databases WITHOUT Subreport

Oct 31, 2016 at 02:25 PM

33

avatar image
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!

databases.png (6.0 kB)
error.png (10.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Don Williams
Oct 31, 2016 at 04:37 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Oct 31, 2016 at 08:17 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
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.

0

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

-Dell

0
Don Williams
Oct 31, 2016 at 09:01 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded