create a query from a query
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=3242
Printed Date: 02 May 2024 at 11:18am
Topic: create a query from a query
Posted By: Bjackson
Subject: create a query from a query
Date 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 direction
 |
Replies:
Posted By: Iago
Date 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.
|