Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: create a query from a query Post Reply Post New Topic
Author Message
Bjackson
Newbie
Newbie


Joined: 20 May 2008
Location: Australia
Online Status: Offline
Posts: 1
Quote Bjackson Replybullet Topic: create a query from a query
    Posted: 21 May 2008 at 7:11pm
I am very new to crystal.I have created 2 separate from 2 separate databases, using the crystal query design tool,and now i need to create a new query that will join these querys-the two tables i want to join have a key.Is This possible?
   In the crystal users guide book it describes creating a query from another crystal query-i have followed those steps,but get stuck trying to add the 2nd query to the query thats selected as the base query
  Can someone point me in the right directionOuch
IP IP Logged
Iago
Groupie
Groupie
Avatar

Joined: 01 Oct 2007
Location: United States
Online Status: Offline
Posts: 52
Quote Iago Replybullet Posted: 23 May 2008 at 9:26am
I would step back from your plan.  Start a new report and in that report create two connections to the two different databases.  Then pull the tables from both that you need.   Performance always suffers with more then on database server. 
 
 
It is always a better idea to have the database server perform the join.  This can be done by linked tables or an ETL job to copy tables.
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.031 seconds.