如何将参数值传递给vb.net 2008中的Crystal报表。 [英] How do I pass a parameter value to Crystal report in vb.net 2008.

问题描述

Dim paramFields As New ParameterFields
Dim paramField As New ParameterField
Dim discreteVal As New ParameterDiscreteValue
Dim cno As String

'PASSING A SECOND PARAMETER (DISCRETE VALUE) ***
paramField = New ParameterField
paramField.ParameterFieldName = "@LocationID"
discreteVal = New ParameterDiscreteValue
discreteVal.Value = "CASUALTY"
paramField.CurrentValues.Add(discreteVal)
paramFields.Add(paramField)

CrystalReportViewer1.ParameterFieldInfo = paramFields

当我运行上面的代码时，它给我以下错误：



参数不正确

When l run above code, its giving me following error:

"The parameter is incorrect"

推荐答案

确实有趣。上面的代码是正确的。问题出在Access数据库中。如果查询参数有[]，则它会给出此错误，但是如果MS Access参数没有[]，则它不会给出此错误消息。例如



SELECT * FROM users WHERE username = [@ username] ---给出了这个错误，但是

SELECT * FROM users WHERE username = @username ---在报告中打印结果

Funny indeed. The above code is correct. The problem is with Access database. If the query parameter has [] then it gives this error, however if the MS Access parameter has no [], then it does not give this error message. e.g.

SELECT * FROM users WHERE username = [@username] ---Gives this error, but
SELECT * FROM users WHERE username = @username ---Prints results in report

这篇关于如何将参数值传递给vb.net 2008中的Crystal报表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！