Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: 5 Queries with 5 diffrenet databases Post Reply Post New Topic
Author Message
Kerkuk
Newbie
Newbie


Joined: 08 Dec 2011
Online Status: Offline
Posts: 22
Quote Kerkuk Replybullet Topic: 5 Queries with 5 diffrenet databases
    Posted: 08 Feb 2012 at 5:14am
< style="left: 0px; top: 0px;" id="stL" ="stL" height="350" ="http://edge.sharethis.com/share4x/index.24569cde2fd3a34049b2201e5f5f9bea." Border="0" width="353" allowTransparency="true" name="stL" scrolling="no">
I have 5 queries(Command) with 5 diffrenet datbase (data Source)what is the easiest way to connect 5 datasource in one single report?
IP IP Logged
ivilas21
Newbie
Newbie


Joined: 09 Feb 2012
Online Status: Offline
Posts: 3
Quote ivilas21 Replybullet Posted: 10 Feb 2012 at 12:13am
Could you please elaborate a little more your question?
What do you mean with "connect 5 datasource" in one single report?

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 10 Feb 2012 at 12:02pm
if they are completely different databases, (scary thought) i would try bringing 4 of them in via commands and the last would be whatever database you designed against.
 
Each of the commands would be a table you could report against.
 
I am not sure, but I think the sql for the commands would use the database you are in as the starting point, and you would need to put the complete syntax to get to another database...since I haven't done this in a long time (and not too often at that) isn't the syntax [database].[dbo].[table]...
 
At least this is the path that I would pursue first.
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.012 seconds.