Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a Case Statement to select which database to use within a Routine
Hello, I am trying to eliminate the need for creating multiple Routines which are doing the same thing on different databases. I would like to use the "USE DB1;" syntax at the beginning of a routine to determine which database to look at. Each database has the same structure (Tables/Views)... -
Combining SQL Server with MYSQL Views in Crystal 2008
Thanks for the insight. That makes sense, keep it on 1 server and have all of the linking done on the server side. It sounds like it would work. I've been doing some digging, and have read that there are ways to link to a server in MS SQL, but I dont have any idea on how to do it. Hopefully I...- CruzN
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Combining SQL Server with MYSQL Views in Crystal 2008
I am connecting to 2 different datasources (SQL Server and MYSQL) in CR 2008. I am joing a SQL Server Stored Procedure to a MYSQL View on Date and User ID. (I am trying to retrieve the records for over 300 CSR's by day for a drill down report). My problem is that even when using the stored...- CruzN
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 2 Data Access
