We help IT Professionals succeed at work.

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

ai4u
ai4u asked
on
Medium Priority
1,247 Views
Last Modified: 2007-12-19
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.
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.