hey guys help me regarding crystal report issue.

Question

0.00/5 (No votes)

See more:

I have developed an application & using crystal report in it. But when i run that application in another system it ask for database credentials (user name, password, server, database) & server, database shows in textbox read only format. The matter is that i had already set new database (new system) credentials in web.config & in coding part. But i dnt know why it show previous system databse connection.

May be this is possible, when i create crystal report i had set a wizard connection in it (user name, password, server, database). So i shows wizard connection rather than C# coding connection.

One more question if we have to change wizard connection then how we run application on server because at there we provides server database credentials. So in this case we have to change database connection while we live our application with crystal report. Or we set our database connection somewhere.

Anyone who know the solution, kindly guide. Thanks in Advance.

Posted 12-Jun-12 23:53pm

Mas11

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)

Anoop Ananthan · Answer 1 · 2012-06-13T01:45:00

Do not try creating reports directly from tables or stored procedures.
Load the required data in datasets or datatables. Set these dataset or datatable as the report source for the report. That way you will not be prompted to give the database credentials.

Just follow the simple steps:
1. Create a command object with "select * from employee"

2. Use a dataadapter to get the data and populate it in the dataset.

3. Use the ds.WriteXmlSchema("A local folder in hard drive") function. Run and stop
the application. so that schema will be saved at the given path.

4. Add Crystal Report to your project from Solution Explorer.

5. Crystal Report Wizard will prompt you to give the data source. Choose the
ADO.NET(XML) and the path of the schema file. The report will be created
using the schema.
6. If there is any change in the structure just click "Verify Database".