parameter field in crystal report

Question

0.00/5 (No votes)

See more:

getting error when i execute the below code

protected void Button1_Click1(object sender, EventArgs e)
{
//Instantiate variables
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

//Set instances for input parameter 1 - @vDepartment
paramField.Name = "depart_name";
//Below variable can be set to any data
//present in SalseData table, Department column
paramDiscreteValue.Value = "South";
paramField.CurrentValues.Add(paramDiscreteValue);
//Add the paramField to paramFields
paramFields.Add(paramField);

/* //Set instances for input parameter 2 - @iSalseYear
//*Remember to reconstruct the paramDiscreteValue and paramField objects
paramField = new ParameterField();
paramField.Name = "@iSalesYear";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "2004";
paramField.CurrentValues.Add(paramDiscreteValue);

//Add the paramField to paramFields
paramFields.Add(paramField);*/

CrystalReportViewer4.ParameterFieldInfo = paramFields;

reportDocument.Load(Server.MapPath("CrystalReport4.rpt"));

//set the database loggon information.
//**Note that the third parameter is the DSN name
//and not the Database or System name
reportDocument.SetDatabaseLogon("sa", "soft",
"./sqlexpress", "rem", false);

//Load the report by setting the report source
CrystalReportViewer4.ReportSource = reportDocument;

}

Error
Database logon failed.

how to slove this problem?

Posted 10-Sep-13 20:26pm

Member 9960222

Add a Solution

2 solutions

Add a Solution

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

thatraja · Answer 1 · 2013-09-10T23:31:00

Solution 1

You didn't apply right login details. Try to login your database using the same login details(which you have mentioned in your code)

Try again. FYI

Using the SetDatabaseLogon() Method of the ReportDocument Class[^]

Posted 10-Sep-13 23:31pm

thatraja

Member 9822231 · Answer 2 · 2013-09-10T23:45:00

if u r using parameters for ur report, then better to create the parameter in ur .rpt file User Interface and pass the parameter value through code.
It may help you.

C#

ReportDocument doc = new ReportDocument();
doc.Load(@"F:\CallLog\CrCallReportMonthly.rpt");
                doc.SetDataSource(ds);
                doc.VerifyDatabase();
                doc.SetParameterValue("DateFrom", txtDateFrom.Text);
                doc.SetParameterValue("DateTo", txtDateTo.Text);

                CrystalReportViewer1.ReportSource = doc;

here DateFrom and DateTo are Parameters.

parameter field in crystal report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

parameter field in crystal report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us