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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple Databases solutions for crystal?
Turkbear, Creating a view was my thought as well however this DB won't allow unions in a view, =========================================== Because it must be merged with the user's query, the SELECT statement on which a view is based cannot contain any of the following clauses: UNION The...- Nezpro
- Post #6
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Multiple Databases solutions for crystal?
the 5 databases are on the same server so all i do is select * from db1:tablename where ... union all ( select * from db2:tablename where ... ) etc.. they are identical databases, just different instances of it, but yes they are different DB.- Nezpro
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Multiple Databases solutions for crystal?
Hey, Currently i have 5 identical sql databases, The data is separated for reasons beyond my control. I have created many reports in crystal XI by first creating a report that meets the criteria, this is done for only one database. I then copy and past the sql statement into a new Command and...- Nezpro
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 2 Data Access
