Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: How to use 'UNION' between two different databases Post Reply Post New Topic
Author Message
benalla
Newbie
Newbie


Joined: 11 Jan 2015
Location: Netherlands
Online Status: Offline
Posts: 2
Quote benalla Replybullet Topic: How to use 'UNION' between two different databases
    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
IP IP Logged
paulhoving
Newbie
Newbie


Joined: 21 Nov 2014
Online Status: Offline
Posts: 7
Quote paulhoving Replybullet 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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Vimal Nair
Newbie
Newbie
Avatar

Joined: 29 Dec 2014
Location: United Arab Emirates
Online Status: Offline
Posts: 26
Quote Vimal Nair Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.