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!
Sub Reports can can point to different database connection.