Crystal Reports错误:登录参数 [英] Crystal Reports Error: Log on paramaters

问题描述

我正在使用VS2008.我创建了一个Crystal Report来在程序中打印发票.
我为两个不同的东西编写了代码，其中:

1)用于从单个表中打印简单数据的代码.
2)用于从两个不同的表中获取数据的代码.

发生错误:Log On parameter Fail
我该如何解决?

这是我的代码:

I am using VS 2008. I created a Crystal Report to print an Invoice in my program.
I wrote code for two different things in Which:

1) Code for printing simple data from a single table.
2) Code for fetching data from two different tables.

There is an error: Log On parameter Fail
How can I solve it?

Here my code is:

Call openconnection()
               str = "SELECT * from Stock_Management where CaseId=" & temp_No & ""
               da = New SqlDataAdapter(str, cn)
               ds.Clear()

               da.Fill(ds, "Stock_Management")
               'MsgBox(ds.Tables("New_Case_Id_Master").Rows.Count)
               cn.Close()

               Dim objRpt1 As New CrystalReport_for_PartsConsumed

               objRpt1.SetDataSource(ds.Tables("Stock_Management"))
               CrystalReportViewer1.ReportSource = objRpt1
               CrystalReportViewer1.PrintReport()
               CrystalReportViewer1.Refresh()

               Dim logOnInfo As New TableLogOnInfo
               CrystalReportViewer1.Refresh()
               cn = New SqlConnection("Data Source=NIRAV-PC\SQLEXPRESS;Initial Catalog=company_database;User ID=sa;Password=nirav")
               cn.Open()
               str = "  SELECT *  FROM Asset_Service_Master,Part_Estimation_Master WHERE  Asset_Service_Master.CaseId=Part_Estimation_Master.CaseId  AND Part_Estimation_Master.CaseId=" & temp_No & ""
               da = New SqlDataAdapter(str, cn)
               ds1.Clear()
               da.Fill(ds1)

               'MsgBox(ds.Tables("New_Case_Id_Master").Rows.Count)
               cn.Close()

               logOnInfo.ConnectionInfo.DatabaseName = "company_database"
               logOnInfo.ConnectionInfo.UserID = "sa"
               logOnInfo.ConnectionInfo.Password = "nirav"
               Dim objRpt As New CrystalReport_For_Billing

               ' Apply connection info. to every table in the report
               For Each tbl As Table In objRpt.Database.Tables
                   tbl.ApplyLogOnInfo(logOnInfo)
               Next

               objRpt.SetDataSource(ds1.Tables(0))
               CrystalReportViewer1.ReportSource = objRpt
               CrystalReportViewer1.PrintReport()
               CrystalReportViewer1.PrintReport()
               CrystalReportViewer1.Refresh()

推荐答案

您忘记了在运行时在登录信息详细信息中应用数据库服务器值(就像您已经应用了数据库，用户名，密码详细信息一样)在运行时).
因此，请在logininfo部分添加以下行

You forgot to apply the database server value in logoninfo details at runtime(Like you have applied database, userid,password details at runtime).
So add the below line in logininfo section

logOnInfo.ConnectionInfo.ServerName = "ServerName"

供您参考
VB.NET Crystal Reports动态加载 [

For your Information
VB.NET Crystal Reports Load Dynamically [^]

这篇关于Crystal Reports错误:登录参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！