Print Page | Close Window

> 1 Database? Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2741 Printed Date: 01 May 2024 at 12:14pm Topic: > 1 Database? Posted By: mikebird Subject: > 1 Database? Date Posted: 28 Mar 2008 at 6:00am Can I use more that one database at a time in a report? How? I don't seem to be able to make links between them Replies: Posted By: BrianBischof Date Posted: 28 Mar 2008 at 10:16am Yes, you can use more than one database at a time. However, there can be problems if you are using an older version of CR (they keep improving database connectivity with each release) and it helps to have indexes for the fields you want to join. There could also be difficulty depending upon the databases you are joining and their drivers (using ODBC is your best bet). It's usually easiest to have the main database connect to the other database and mimic the table as if it were its own (SQL Server does this). Then CR thinks that you are only referencing a single database. ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Print Page | Close Window