Dear all.
I have created crystal report.
While opening crystal report through application it shows me Database Login Window.
I have used foll. code:
string reppath = "";
con = oDAL.OpenConnection();
rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string DOCENTRY = "";
ParameterFields myparam = new ParameterFields();
ParameterField param1 = new ParameterField();
ParameterDiscreteValue dv1 = new ParameterDiscreteValue();
if (DocEntry != null)
{
DOCENTRY = DocEntry;
}
else
{
DOCENTRY = "";
}
con = oDAL.OpenConnection();
param1.ParameterFieldName = "DocEntry";
dv1.Value = DOCENTRY;
param1.CurrentValues.Add(dv1);
//myparam.Add(param1);
//myparam.Add(param2);
myparam.Add(param3);
crystalReportViewer1.ParameterFieldInfo = myparam;
reppath = oDAL.ReportPath + "\\" + ReportName;
// reppath = Application.StartupPath+"\\Reports" + "\\" + ReportName;
rd.Load(reppath);
rd.DataSourceConnections[0].SetConnection(oDAL.servername, oDAL.DatabaseName, oDAL.UserID, oDAL.UserPassword);
rd.SetParameterValue("DocEntry", DocEntry);
crystalReportViewer1.ShowGroupTreeButton = false;
crystalReportViewer1.ReportSource = rd;
crystalReportViewer1.Refresh();
crystalReportViewer1.BringToFront();
crystalReportViewer1.ShowCloseButton = true;
Loading

Pravin GhadgePosted Nov 26, 2011, 8:01 AM
I have tried ur solution. bt it is not working.
its showing me same error.
Is it due to some crystal report version problem.
or some code problem.
Prabhu RajaPosted Nov 10, 2011, 11:35 PM
rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
To
ReportDocument rd= new ReportDocument();
rd.Load(Server.MapPath("/anysubdirectory (optional)/CrystalReport1.rpt"));
Pravin GhadgePosted Nov 10, 2011, 1:06 PM
I have used ur code bt its show me foll err::
Unknown Query Engine Error
Error in File C:\DOCUME~1\PRAVIN\LOCALS~1\Temp\crpt1 {175B405B-A3B2-4ADF-843A-2179986B1900}.rpt:
Unknown Query Engine Error
Prabhu RajaPosted Nov 10, 2011, 1:36 AM
You don't need to give Database Login information to Crystal Report at every time. Try this one,