Data access in crystal reports

Question

0.00/5 (No votes)

See more:

Hi,

I have a VB.net application that is connected to an Access database. In the application I am running a Crystal Report that is connected to the same database. In order to be able to add a custom command, I had to connect to the database directly through the CR database expert since using the ADO connection provided by Visual Studio does not allow me to create custom commands.
Everything works just fine inside the Visual Studio 2010 environment, but once deployed on a test machine the report does not work anymore. Setting up the database connection through a ConnectionInfo does not work (CR keeps on asking for a user/pass and there is no pass to the database.
Can anyone tell if it is at all possible to add a custom command to an ADO.NET dataset? If not, what is the proper syntax to connect CR to an Acces database (by providing the Access file name)?

Update: Setting the connection on the DataSourceConnections causes CR to prompt for the user/pass of the Access file. The mdb file (Access 2010)is not password protected (file and workgroup level).

Cheers

Posted 3-Feb-11 8:33am

Tom Geyzen

Updated 5-Feb-11 2:58am

v2

Add a Solution

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)

Kschuler · Answer 1 · 2011-02-03T09:36:00

You need to look at the ReportDocument object, specifically the DataSourceConnections property. I'm guessing that when you deploy your access database is located in a different directory than your development machine and you have to set that for the report. Should look something like this:

ReportDocument1.DataSourceConnections.Item(0).SetConnection(strLocationOfDatabase, "", False)

or with login credentials:

ReportDocument1.DataSourceConnections.Item(0).SetConnection(strLocationOfDatabase, "", "UserName", "Password")

This article[^] looks like it can explain it pretty good. Or you could google[^].

If this is not the case and you deploy differently, please edit your question to specify. Hope this helps.