How could I change database in DSN for Crystal Report using code in VB.Net?

Question

0.00/5 (No votes)

See more:

Dear All,
I have a problem with changing database for crystal report.
I have design a report using crystal report by using DSN as a data source.
I have two databases such as aces_database and aces_database_2.
When I log into the branch1, the report will take data from aces_database.
but when I log into branch2, I can make my DSN change database to aces_database_2
but the it still take data from branch1.
I have the method to change it in design view. but I couldn't find the way to change it by code.

How could I configure to change database for crystal report using vb.net?

Posted 13-May-14 18:54pm

Thynin ITE

Add a Solution

Comments

DamithSL 14-May-14 1:06am

can't you create another DSN for aces_database_2?

Thynin ITE 14-May-14 7:27am

If I create another DSN for that, how could I take my report to get data from that DSN?

Dave Kreskowiak 14-May-14 8:59am

The first thing you should be asking is why you're even using a DSN. A DSN is nothing but a text file with the data to create a connection string. This is something you can do in your own code with very simple string manipulation without ever touching a DSN.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

LAB63 · Answer 1 · 2014-05-25T10:10:00

Solution 1

Hi, This is how I have done it in the past

VB

Dim rptDriver as new ReportDocument
'... Load the report ect.
rptDriver.DataSourceConnections.Item(0).SetConnection(gDataBaseName, g_dbConn.Database, gUserID, gPWD)
rptDriver.Refresh

Posted 25-May-14 10:10am

LAB63

Updated 25-May-14 11:28am

v2