How to use 'UNION' between two different databases
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21270
Printed Date: 27 Apr 2024 at 7:52am
Topic: How to use 'UNION' between two different databases
Posted By: benalla
Subject: How to use 'UNION' between two different databases
Date Posted: 12 Jan 2015 at 9:07pm
Hello,
Could someone help me out. I am trying to find out if and how to use 'UNION' between two different databaseservers.
We have 2 different queries, each queries on a different database; one MySQL the other MSSQL.
Could someone tell me how to use 'UNION' between these 2 queries?
Thanks in advance,
Samir Benalla
|
Replies:
Posted By: paulhoving
Date Posted: 13 Jan 2015 at 7:21pm
As far as i know that's not possible.
You use a UNION command in a custom command. A custom command is used against one database.
|
Posted By: kevlray
Date Posted: 14 Jan 2015 at 4:15am
I have created a query in Excel that will access two databases, thus it stands to reason you can do it with a stored procedure, but I do not think Crystal will let you.
|
Posted By: Vimal Nair
Date Posted: 27 Jan 2015 at 1:45am
AM not sure whether this is possible or not. But try to use 2 separate sql commands to use values from 2 different database by different data connections and if there is a link, link it at crystal level. Since its a union, I don't think that its required.
-------------
Born To Live
|
|