Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: 2 Different Servers 1 Report Post Reply Post New Topic
Author Message
Logle0917
Newbie
Newbie


Joined: 21 Jul 2011
Location: United States
Online Status: Offline
Posts: 14
Quote Logle0917 Replybullet Topic: 2 Different Servers 1 Report
    Posted: 13 Sep 2011 at 7:30am
Can I create a report in Crystal 2008 accessing Data from a SQL Server Database and a Oracle Database?  I have one application that is on SQL Server and One Application that is on an Oracle Database.  I need to create a report that uses information from both applications and combine them into one report.  Can I do this?  Thanks!
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 13 Sep 2011 at 9:30am

In theory this can be done. In your report you will need to create two connections. I suggest using a command object for each data source. You should see the two command objects in the report designer.  The issue will be how to relate the two data sources. I have never actually done what you are proposing Oracle and SQL Server so cannot speak to how that would be done. I do not know for example is the data linking will be able to set the relationships or not. Still its worth a try and in under 5 minutes you should have the answer.

 
Regards,
 
John W.
IP IP Logged
yggdrasil
Senior Member
Senior Member
Avatar

Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Quote yggdrasil Replybullet Posted: 14 Sep 2011 at 3:56am
Yes you can, as long as you have the connections to both. We have several reports here that link our Social Services database on SQL Server with the Education one on Oracle.
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.033 seconds.