Skip to Content

Link Multiple Databases WITHOUT Subreport

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 31, 2016 at 04:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2016 at 08:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2016 at 09:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded