C# CrystalReports Problem

Question

0.00/5 (No votes)

See more:

I generated Crystal Report using Parameters and I am listing the Code below.
I am having Database Login Prompt Problem. Can I get the Solution for Database Login programatically.

C#

private void Form1_Load(object sender, EventArgs e)
 {
  crystalReportViewer1.ReportSource = ReportPath;
  CrystalDecisions.CrystalReports.Engine.ReportDocument objReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
  objReport.Load (ReportPath);
  ParameterField f1 = crystalReportViewer1.ParameterFieldInfo[0];
  ParameterDiscreteValue v1 = new ParameterDiscreteValue();
  v1.Value = Value to be passed;
  f1.CurrentValues.Add(v1);

  ParameterField f2 = crystalReportViewer1.ParameterFieldInfo[1];
  ParameterDiscreteValue v2 = new ParameterDiscreteValue();
  v2.Value = Value to be passed;
  f2.CurrentValues.Add(v2);
  }

Posted 15-Oct-11 6:24am

ravicnd

Updated 15-Oct-11 7:24am

v3

Add a Solution

Comments

Pravin Patil, Mumbai 15-Oct-11 12:51pm

Can you elaborate on problems....?

2 solutions

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)

**theanil** · Answer 1 · 2011-10-15T07:37:00

Solution 2

Crystal Report in visual studio 2010 C#[^]

Posted 15-Oct-11 7:37am

theanil

Comments

RaviRanjanKr 16-Oct-11 16:58pm

My 5 for Link.

theanil 17-Oct-11 1:05am

Thank you :-)

Uday P.Singh · Answer 2 · 2011-10-15T07:33:00

Try this:

C#

objReport.SetDatabaseLogon("username", "pwd", "server", "database");

set the parameters according to your connection. This will remove Login prompt issue.

Or you can do this:

In Crystal Management Console (CMC) at each report level. Login to CMC, open ur report > Process > Database. At the bottom of the page u can specify "Prompt the user for database logon", "Use SSO context for database logon" or "Use same database logon as when report is run". Select the third option for using the credentials stored in the server.

And what is the problem in ReportTitle? please elaborate it.

hope it helps :)