Print Page | Close Window

Combining like databases

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2970
Printed Date: 28 Apr 2024 at 6:50am


Topic: Combining like databases
Posted By: cfrey
Subject: Combining like databases
Date Posted: 18 Apr 2008 at 9:21am
We have two Universe databases that I access through ODBC. I need to create a report which combines data from both. I know I can use a subreport but is there a way to access them both at the same time.

I am able to bring in the files in the Data Expert. When I tried running a selection statement based on date I errored out "Cannot setermine the querioes neccesaary to get data for this report.

My selection went sonething like this:

{Date} in {?Current Range} or {Date_1} inn {?Current Range}

where {Date} is from one database and {Date_1} is from another.

Any help is appreciated.

Thanks


Print Page | Close Window