<div>
<div class="content wysiwyg-content">
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 . <br />
I am using this in my app.config<br />
&lt;add key=&quot;ConnectionString&quot; value=&quot;Server=Aron1;Databa<wbr />se=pubs;Tr<wbr />usted_Conn<wbr />ection=Tru<wbr />e;&quot; &gt;&lt;/add&gt;<br />
Alternately I can use FILEDSN (with trusted connection) for crystal report.
</div>
</div>


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.

Passing Database Logon information from FileDSN at runtime in Crystal Report using VB.NET

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.