sql-server - 如何阻止 Crystal Reports 提示输入参数

Question

我正在为水晶报告使用 2 个带有 2 个参数的存储过程。我有一个带有 2 个文本框的表单。我将参数输入到文本框中，但是当报告加载时，它仍然提示用户再次输入参数。下面是我正在使用的代码：

Private Sub PrintReceipt()
    Dim conn_String As String
    conn_String = "Connection String"
    Dim Mycon = New SqlConnection(conn_String)
    Dim cmd = New SqlCommand("GetReceiptByReceiptNo", Mycon)
    Dim cmd1 = New SqlCommand("GetReceiptedItems", Mycon)
    Dim dAdapter = New SqlDataAdapter(cmd)
    Dim dAdapter1 = New SqlDataAdapter(cmd1)

    dAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
    dAdapter1.SelectCommand.CommandType = CommandType.StoredProcedure

    dAdapter.SelectCommand.Parameters.AddWithValue("ReceiptNo", TxtReceiptNo.Text)
    dAdapter1.SelectCommand.Parameters.AddWithValue("InvoiceNo", TxtInvoiceNo.Text)
    Dim dTable As New DataTable
    dAdapter.Fill(dTable)

    Dim rdc = New ReportDocument()
    rdc.Load("C:\ClientsReceipts.rpt")
    rdc.SetDataSource(dTable)
    ClientReceiptsViewer.CrystalReportViewer1.ReportSource = rdc
    ClientReceiptsViewer.Show()

End Sub

我想消除第二张图片中的提示，感谢您提供任何帮助。

标签： sql-servervb.net