I am using stored procedures in SQL SERVER 2000 which are getting data from joins of more than one table. I want to bind the result in crystal report (using vb.net) . The problem is that I am not sure of the Database name and Server name of SQL SERVER 2000 as the cleint can change it also. Can anyone provide with an example how to create crystal report with stored procedure using more then one table which binds server details at runtime or can be changed easily .
I am using this in my app.config
<add key="ConnectionString" value="Server=Aron1;Database=pubs;Trusted_Connection=True;" ></add>
Alternately I can use FILEDSN (with trusted connection) for crystal report.