Multiple DSNs on Crystal Server

[sandy01]

Hi,
Wanted to know that if there are two DSNs on Crystal Server
pointing to the same database.
How can i choose from the available DSNs. That is, how can we set one of the available DSN to which the Crystal Server (8.5) would point to.

Thanx

 

[Turkbear]

Hi,
The datasource is selected when the report is designed or re-designed ( using the Set Location option)...

It is up to the developer to have the same DSNs on their designer workstation as are on the Server...

If I have missed your point, please clarify..

 

[sandy01]

I agree to what you have said but is there any way by which we can set the DSN specifically for all the reports in one go thru some settings on the Server. That is, whenever I wish I can make Crystal Server refer a particular DSN from the two DSN available.