首页 文章

将参数传递给Windows窗体(VB.net)中的Crystal Report

提问于
浏览
1

我正在使用Visual Studio 2008(vb.net),SQL Server 2008和Crystal Report 9 .

我在SQL Server中创建了一个存储过程我在Crystal Report Data Expert中添加了此过程

现在,我只想将参数传递给Crystal Report,以便它在Crystal Report中显示数据 .

请帮帮我 .

2 回答

  • 1

    试试这个:

    Dim paramDV As New ParameterDiscreteValue()
    paramDV.Value = "Parameter Value"
    report.ParameterFields("@ParameterName").CurrentValues.Clear()
    report.ParameterFields("@ParameterName").DefaultValues.Clear()
    report.ParameterFields("@ParameterName").CurrentValues.Add(paramDV)
    

    其中 report 是您的Crystal Report对象

  • 1
    Dim myParameterFields As ParameterFields
    Dim myParameterField As ParameterField
    Dim myDiscreteValue As ParameterDiscreteValue
    
    myParameterFields = New ParameterFields
    myParameterField = New ParameterField
    myDiscreteValue = New ParameterDiscreteValue
    
    myParameterField.ParameterFieldName = "@Date"
    myDiscreteValue.Value = cj
    myParameterField.CurrentValues.Add(myDiscreteValue)
    
    myParameterFields.Add(myParameterField)
    
    myParameterField = New ParameterField
    myDiscreteValue = New ParameterDiscreteValue
    
    CrystalReportViewer1.ParameterFieldInfo = myParameterFields
    
    CrystalReportViewer1.Refresh()
    CrystalReportViewer1.ReportSource = "D:\YOGESH KA PROJECT\stationary\stationary\Forms\BillReport.rpt" ' Assign Report Source to CRV
    

相关问题