报表出“登录失败”错误。

[chinabs]

登录失败。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

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

源错误:


行 87： diskOpts.DiskFileName = "c:\\outfile.xls";
行 88： exportOpts.DestinationOptions = diskOpts;
行 89： Report.Export ();
行 90：
行 91： }


源文件: d:\website\dataserver\report\report1.aspx.cs 行: 89

堆栈跟踪:


[LogOnException: 登录失败。]
.K(String
, EngineExceptionErrorID ) +546
.F(Int16 , Int32 ) +487
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) +468
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() +114
CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() +74
dataserver.report.Report1.Button1_Click(Object sender, EventArgs e) in d:\website\dataserver\report\report1.aspx.cs:89
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263

[chinabs]

我的源代码如下：
private void Button1_Click(object sender, System.EventArgs e)
{
CrystalReport1 Report = new CrystalReport1();
ExportOptions exportOpts = new ExportOptions();
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions ();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = Report.ExportOptions;
// 设置 Excel 格式选项。
excelFormatOpts.ExcelUseConstantColumnWidth = true;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.FormatOptions = excelFormatOpts;
// 设置磁盘文件选项并导出。
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = "c:\\outfile.xls";
exportOpts.DestinationOptions = diskOpts;
Report.Export ();
}

当执行到 Report.Export ()时就报上面这个错误。

[ketao_78]

我也遇到过这种问题，可能是由于数据库登陆的问题
我给你一段代码我的

[ketao_78]

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Me.CrystalReportViewer1.ReportSource = Server.MapPath("report/sc_pc_goods.rpt")
'Me.CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.UserID = "sa"
'Me.CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.Password = "1"
'Me.CrystalReportViewer1.DataBind()
End Sub

[chinabs]

Me.CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.UserID = "sa"

这个在C＃里面怎么写？

[pingguo_yu]

天外飞仙兄，我也想把数据导出到excel，单个表已经能导出了，多个表联接不知道怎么做。
这个可以用的：
private void Button1_Click(object sender, System.EventArgs e)
{
string strProvider = "Server=Wangyujuan;UID=sa;PWD=;DataBase=pubs";
CrystalReport1 myReport = new CrystalReport1();
DataSet1 ds =new DataSet1();
SqlConnection MyConn = new SqlConnection(strProvider);
MyConn.Open();
string strSel = "Select * from Stores";
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"stores");
myReport.SetDataSource(ds);
CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts=new CrystalDecisions.Shared.DiskFileDestinationOptions();
myReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
myReport.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel;
DiskOpts.DiskFileName = "c:\\Output.xls";
myReport.ExportOptions.DestinationOptions =DiskOpts;
myReport.Export();
}
}