Crystal reports on client?

[al]

Hi,

If I use (in development) connection object from design tools in
ToolBox to get data from db to crystal reports, how can I make
changes to server name and security options in runtime. That is, is
there an option during "packaging and deployment" where I can make
connection setting as per client machine,instead of being to
develpment one??

MTIA,
Grawsha

 

[Bernie Yaeger]

Hi Grawsha,

No way that I know of. I do it in two ways:
1. change the name of the sql server server to be the same as the one I use
for development
2. run through your code and change throughout as necessary

The latter method sounds difficult, but it really doesn't take that long;
I've done it on some big apps and it goes pretty smoothly.

HTH,

Bernie Yaeger

 

[al]

Hi Grawsha,

No way that I know of. I do it in two ways:
1. change the name of the sql server server to be the same as the one I use
for development
2. run through your code and change throughout as necessary

The latter method sounds difficult, but it really doesn't take that long;
I've done it on some big apps and it goes pretty smoothly.

HTH,

Bernie Yaeger

Ok, This is good. I used design tools to connect to database (in
development) but when I moved the application to client and ran it,
there was an error saying "needs valid server to connect to" or
something close to this. How can I change the name of the server to
match what is on client??(I do not want to do this in development
time, as I really don't know what is the name the client has)

 

[Bernie Yaeger]

Hi,

I think you will have to do one of two things:

1. this is the best way - find a way through the api to capture the sql
server server name; then develop a routine that builds the connection string
with this captured name.
2. change your connection to 'hard code' to the name of the client's sql
server.

1 is far more elegant; 2 is easier for the moment.

HTH,

Bernie Yaeger