Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Combining like databases Post Reply Post New Topic
Author Message
cfrey
Groupie
Groupie


Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 55
Quote cfrey Replybullet Topic: Combining like databases
    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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.