I'm trying to find a way where the database name and the server name can be dynamic.
I'm developing an application which uses C# and crystal reports. Both application and the reports use the same database which is setup on a separate database server. This application now needs to be deployed elsewhere, where the database name and the server name may not be the same as what is used while developing.
I can use easily edit the config file for the application accordingly to change the name of server and database to look for, but i cant find a way to edit the these details for the crystal reports.
The reports were built using the crystal reports within Visual Studio 2005. 'Database expert' is used for connecting to the database and designing the query.
Is there any way to have these parameters set dynamically through a config file or code for crystal reports?
Im using C#. I've tried using ConnectionInfo for the report and for the tables etc in the code but it doesn't work.. Please help!!