0

I am creating a report with Crystal 2011. With all the reports I create with Crystal, I code the SQL first, then drop it into Crystal and use its formatting tools.

We have Intersystem's Cache database. In the report I am currently creating, I need to pull data from our production, testing, and sandbox environments into this single report. Each environment has a unique jdbc url.

In the report I will be comparing data between the environments looking for discrepancies.

Does anyone have any ideas how to pull data via multiple jdbc/odbc connections into a single report?

Any suggestions would be greatly appreciated!

swimsterx
  • 15
  • 4

1 Answers1

0

Sub Reports can can point to different database connection.

Pals
  • 131
  • 8
  • I have three subreports and each one is pointing to a different database connection. The Main Report is not pointing to any database connection. I would like to somehow pass data from each subreport to the main report via a variable, or array and perform calculations on the data. Is that possible? The more I have been trying to figure it out, the more I'm leaning toward it is absolutely impossible, unless someone knows something i don't. Thanks! Steve – swimsterx Jul 02 '20 at 20:54
  • Look for shared variable, these allow to pass value from sub report to main report. – Pals Jul 03 '20 at 18:34