can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?
From: Jorge Cavalheiro (anonymous_at_discussions.microsoft.com)
Date: 02/25/04
- Next message: v-jetan_at_online.microsoft.com: "RE: XML to plain text"
- Previous message: onedaywhen: "Re: Linking to Access in VB"
- In reply to: Bernie Yaeger: "can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?"
- Next in thread: Jorge Cavalheiro: "can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?"
- Reply: Jorge Cavalheiro: "can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 01:42:20 -0800
Hello Bernie
You can use the SQL-DMO ListAvailableSQLServers to
retrieve all SQL servers on your client. If there's only
one then use that one if not ask the user which one to
use.
And when you define the ConnectionInfo of the report you
can use .ServerName = <your variable>
Kind Regards
Jorge Cavalheiro
>-----Original Message-----
>I can't believe that there aren't lots of developers who:
>
>1. create a crystal report that connects to sql server
>2. calls the report using the crystalreportviewer
control to view it and
>then, if appropriate, print it
>3. tries to deploy that report to the client's
database, but now it calls
>for a different database name
>
>Yet I can't get an answer to the question:
>I have developed numerous reports in an app (Windows
Database App) that is
>soon to go into production. When I built each report,
CR connected to sql
>server on my development platform. The connection
string is different than
>it will be at my client.
>
>How can I change the connection string so that it
recognizes my client's
>server instead of mine for each of these reports?
>
>Of course, I could install a version of crystal on the
client and rebuild
>the reports there, but that seems a terrible pain - and
for every customer
>with sql server? I've written to crystal and I get
links to unhelpful kbase
>articles.
>
>Thanks for any help.
>
>Bernie Yaeger
>
>
>.
>
- Next message: v-jetan_at_online.microsoft.com: "RE: XML to plain text"
- Previous message: onedaywhen: "Re: Linking to Access in VB"
- In reply to: Bernie Yaeger: "can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?"
- Next in thread: Jorge Cavalheiro: "can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?"
- Reply: Jorge Cavalheiro: "can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
