Passing Paramaters with VB to Crystal Reports

[marc1234]

Hi Guys,

Im new to this forum, and I hope some one can help me.

I have a situation where I need to programatically pass paramaters using VB through to my crystal report. I am using Visual Studio 2008 for my development.

Everything is working fine, but when I run the report I get a "Value cannot be Null" error. this is in the Crystal Reports Rorm Viewer.

My complete code is below.

=========================


Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.Data.OleDb

Public Class Form1



Private Sub CrystalReport11_InitReport(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReport11.InitReport



Dim CR As New ReportDocument
CR.Load("C:\VBScript\WindowsApplication1\CrystalReport1.rpt")


Dim crParameterDiscreteValue As ParameterDiscreteValue

Dim crParameterFieldDefinitions As ParameterFieldDefinitions

Dim crParameterFieldLocation As ParameterFieldDefinition

Dim crParameterValues As ParameterValues


crParameterFieldDefinitions = CR.DataDefinition.ParameterFields



crParameterFieldLocation = crParameterFieldDefinitions.Item("@ParameterName1")

crParameterValues = crParameterFieldLocation.CurrentValues


crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue


crParameterDiscreteValue.Value = "test"


crParameterValues.Add(crParameterDiscreteValue)


crParameterFieldLocation.ApplyCurrentValues(crParameterValues)



CrystalReportViewer1.ReportSource = CR




End Sub


End Class


=========================


As I said my paramater is passed and displayed on the report, but I keep getting this error...

can anyone help.

[dglienna]

Fix your code. Add [] [/] with Code before the ]

' This is code

[marc1234]

I dont understand fix your code?

is it not readable?

[HanneSThEGreaT]

Have a look at this link :

http://www.codeguru.com/forum/showthread.php?t=403073