Crystal 9 report using differet databases

[sexydog]

hi

I have created a crystal 9 report using a stored proc on a sql server 2000. the problem is that that this report only works on the database name on which i created it...i need the report to work on different databases names located on different servers....i know how to do this in crystal 8.5 by removing the database owner in the "set database location" option....can this be done in crystal 9 and if so how...

Thanks
DJ

 

[FVTrainer]

How are you deploying your report? Via a 3rd-Party tool? the RDC in vb or another development environment? RAS/CE? And are you using an ODBC connection or an OLEDB connection to Sql Server 2K?

 

[sexydog]

Hi

i am using OLEDB connection to Sql Server 2K

Thanks
DJ

 

[Stoffel24]

I assume you know about the option under the database menu - set datasource location. But I see that you cannot change the database owner here.

 

[FVTrainer]

Well, if you're just interested in running the report from within Crystal Reports, then the Set Location option in the Database menu lets you select the current connection and map it to another connection. The following KB article deals with this issue, although not in great detail:

http://support.crystaldecisions.com/library/kbase/articles/c2012382.asp

However, is your question really about how to change the connection information from within the Crystal Designer? That is why I asked how you are deploying the report, because if you are deploying it in a vb app or via CE/RAS, there are ways to deal with connecting to the correct server at runtime.

 

[sexydog]

HI

I am using to following code in vb6

the_crystal_report.database.Tables(1).SetLogOnInfo server, database,user_id, password

my problem is that it at runtime it looks for the database that i created the report on not the one i specify above....

when i write a new report i usually write it in crystal 8.5 where i remove the database owner and the convert this report to crystal 9. after doing this the report works of any database name or server name that i specify at runtime..

the reason i cant do this now, is because i am updating this report with some additional parameters...this means i cant convert back to 8.5


hope you understand my problem

Thanks
DJ

 

[GMcNamara]

I had a similar issue. Here is a link to my post.

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/100/pid/149/qid/444122