Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR9: Trying to Set Datasource Location /w rpt containing SQL Command

Status
Not open for further replies.

JeffAnderson

Technical User
Joined
Jul 1, 2002
Messages
6
Location
US
I recently wrote several reports in CR9 using SQL commands. I wrote them on a direct copy of the client DB, so the schema I used is identical.
I sent the reports to my client , who the tried to open on his network and use 'Set Datasource Location'. When the report attempts to establish connection to his datasource, it still shows my connection info in the server conenction dialog window. He then types his connection info (Service, User ID, Password) and it says 'Logon failed'. He is definitely using the right info. I have been working with Crystal Support for a week now and they have been no help at all.
Does anyone know if it is possible to move a report containing SQL commands from one network to another (ie, not sharing a repository)?

Thanks in advance for any help!!

 
Don't know if this is still of any interest to you, but I had a similar problem which I only managed to resolve by running the latest Hot fix for CR9. I'm now on version 9.2.3.666 which seems to have sorted the problem
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top