Two Parameters

Right i've followed a guide and got a VB program working with Crystal Reports. So i added my own report and that worked ok.

Now i want to pass two parameters to the report. This is where i need help, i've googled but can't find any guides/samples that pass two parameters e.g. Date and Supplier.

Below is the code for passing just one parameter. Anyone able to modify it so i can pass two. Thanks

VB Code:

Imports CrystalDecisions.Shared
Public Class Form1
Inherits System.Windows.Forms.Form
 
#Region " Windows Form Designer generated code "
 
 
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.ShowPrintButton = True
End Sub
 
Private Sub Button1_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
 
Dim myParameterFields As New ParameterFields
Dim myParameterField As New ParameterField
Dim myDiscreteValue As New ParameterDiscreteValue
 
myParameterField.ParameterFieldName = "DataDate"
myDiscreteValue.Value = DateTimePicker1.Text
myParameterField.CurrentValues.Add(myDiscreteValue )
 
myParameterFields.Add(myParameterField)
 
CrystalReportViewer1.ParameterFieldInfo = myParameterFields
 
CrystalReportViewer1.ReportSource = New CCReport
CrystalReportViewer1.Refresh()
 
End Sub
End Class

I've tried passing two parameters but only one seems to work. Sorry but i'm a bit of a newbie to both Crystal Reports and VB

This should help.

Thanks for the reply.

I've had a look at that thread but not sure how to mod my code to allow the second parameter.

Sorry for being such a newbie. :(

Should i of said i'm trying to do an windows application not Web site

Not a prob. I havent used CR in .NET yet, but I will try. You can .Add the
first parameter to the Parameters collection. You can access them by doing
something like...

VB Code:

myParameterFields.Items(1).ClearCurrentValueAndRange
myParameterFields.Items(1).Add strValue1
myParameterFields.Items(2).ClearCurrentValueAndRange
myParameterFields.Items(2).Add strValue2

I think something like this will work for you. In the link I posted the post that
is most relevant is #11.

HTH

God i hate VB :) hehehehe.

Still no joy. Is there anyone that actual codes VB with Crystal Reports in them. Looks like i may have to pay someone to do it.