Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Connecting Different Data Source Post Reply Post New Topic
Author Message
Krishna Kumar
Newbie
Newbie
Avatar

Joined: 21 Jan 2008
Location: India
Online Status: Offline
Posts: 10
Quote Krishna Kumar Replybullet Topic: Connecting Different Data Source
    Posted: 01 Feb 2008 at 5:20am
Hi,

We have an application in COBOL which triggers the CR (Version 8). The report reads from the flat file to populate the data thru CONOX. The database changes from one country to the other but table structures do not differ. Please let me know if it is possible to build a report which connects to five different countries in the same report and populate the data.

Thanks.
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 01 Feb 2008 at 5:40am
Brian or someone will have to answer if it is actually possible.  I'm guessing that it is not possible with COBOL, as you would need some of the API's from .NET to accomplish it.

The much simpler solution, though it may go against a number of "best practice" habits, is to create a separate report for each data source.  It is a relatively simple matter to open a report and change its data source manually.  Then, save it as a separate instance of the report.  Have your COBOL simply call the appropriate report, rather than trying to modify the report's data source when it's called.

Now, obviously, this doesn't work if the name of your flat file changes between executions (e.g., includes the current date, or some version number).  In that case, you may need to get a little more creative.  I would recommend actually running a little operation to copy the data from the flat file into a common temporary file, generate the report based on the temporary file, then either clean or delete the temp file.  This will be the best way to keep Crystal happy.


IP IP Logged
Krishna Kumar
Newbie
Newbie
Avatar

Joined: 21 Jan 2008
Location: India
Online Status: Offline
Posts: 10
Quote Krishna Kumar Replybullet Posted: 04 Feb 2008 at 12:52am
Thank you for your reply Lugh. We have found another way to do this (fingers crossed ;)). We have decided to get the replica of the flat file on to Oracle DB. Have synonym links for different countries and so a single report can be connected to different Data sources via synonym links.
 
Thanks once again.
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.000 seconds.