CrystalDecisions.CrystalReports.Engine.LogOnException: 登录失败

[zmgnwpu]

异常详细信息: CrystalDecisions.CrystalReports.Engine.LogOnException: 登录失败。

源错误:

执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。

堆栈跟踪:


[LogOnException: 登录失败。]
.F(String , EngineExceptionErrorID
) +506
.A(Int16 , Int32 ) +537
CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext) +539
CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext) +189
CrystalDecisions.Web.ReportAgent.u(Boolean N) +164
CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) +108
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1489
错误信息如上，不知道如何解决。哪位高手帮忙！

[amfb]

我以前也遇到过这样的问题，主要是要加上连接数据库所用到的database,user id，psd等信息，
你可以参考一下推模式和拉模式两段代码，这两段代码分别都可以实现：
第一段：
{
TableLogOnInfo logOnInfo = new TableLogOnInfo();
ReportDocument rpdMy0= new ReportDocument();
logOnInfo.ConnectionInfo.ServerName = "localhost";
logOnInfo.ConnectionInfo.Password="ameng";
logOnInfo.ConnectionInfo.DatabaseName="pubs";
logOnInfo.ConnectionInfo.UserID = "sa";

String path = Server.MapPath("CrystalReport1.rpt");
rpdMy0.Load(path);
rpdMy0.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
CrystalReportViewer1.ReportSource = rpdMy0;


}


第二段：


{
CrystalReport1 CR=new CrystalReport1();\\这是你建的水晶报表
Dataset dataset=new Dataset();

string str="server=localhost;uid=sa;pwd=ameng;database=pubs";
string SQLstr="select * from employee";
SqlConnection conn=new SqlConnection(str);

SqlDataAdapter adapter=new SqlDataAdapter(SQLstr,conn);




TableLogOnInfo logOnInfo = new TableLogOnInfo();

logOnInfo.ConnectionInfo.ServerName = "localhost";
logOnInfo.ConnectionInfo.Password="ameng";
logOnInfo.ConnectionInfo.DatabaseName="pubs";
logOnInfo.ConnectionInfo.UserID = "sa";
/* 使用填充Fill方法可以连接到被指定的数据库、获取数据和与数据库分离 */
adapter.Fill(dataset,"employee");

CR.SetDataSource(dataset);
CR.Database.Tables[0].ApplyLogOnInfo(logOnInfo);

this.CrystalReportViewer1.ReportSource=CR;
}

[amfb]

我以前也遇到过这样的问题，主要是要加上连接数据库所用到的database,user id，psd等信息，
你可以参考一下推模式和拉模式两段代码，这两段代码分别都可以实现：
第一段：
{
TableLogOnInfo logOnInfo = new TableLogOnInfo();
ReportDocument rpdMy0= new ReportDocument();
logOnInfo.ConnectionInfo.ServerName = "localhost";
logOnInfo.ConnectionInfo.Password="ameng";
logOnInfo.ConnectionInfo.DatabaseName="pubs";
logOnInfo.ConnectionInfo.UserID = "sa";

String path = Server.MapPath("CrystalReport1.rpt");
rpdMy0.Load(path);
rpdMy0.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
CrystalReportViewer1.ReportSource = rpdMy0;


}


第二段：


{
CrystalReport1 CR=new CrystalReport1();\\这是你建的水晶报表
Dataset dataset=new Dataset();

string str="server=localhost;uid=sa;pwd=ameng;database=pubs";
string SQLstr="select * from employee";
SqlConnection conn=new SqlConnection(str);

SqlDataAdapter adapter=new SqlDataAdapter(SQLstr,conn);




TableLogOnInfo logOnInfo = new TableLogOnInfo();

logOnInfo.ConnectionInfo.ServerName = "localhost";
logOnInfo.ConnectionInfo.Password="ameng";
logOnInfo.ConnectionInfo.DatabaseName="pubs";
logOnInfo.ConnectionInfo.UserID = "sa";
/* 使用填充Fill方法可以连接到被指定的数据库、获取数据和与数据库分离 */
adapter.Fill(dataset,"employee");

CR.SetDataSource(dataset);
CR.Database.Tables[0].ApplyLogOnInfo(logOnInfo);

this.CrystalReportViewer1.ReportSource=CR;
}

[xwdd129]

楼上的回答很详细全面了

[lyb_abiandbel]

http://community.csdn.net/Expert/topic/4215/4215618.xml?temp=.9745752 我的回答。

http://blog.csdn.net/lyb_abiandbel/archive/2005/09/05/471660.aspx

[yingfeiqiyue]

楼上的很对！
顶

[windbey]

MARK