[Resolved] Passing Multiple Parameters w/CR & VB 2005

[katuil]

Hello

I have searched for how to pass multiple parameters and have found a way but I still get prompted to enter all but one of the multiple parameters. Which ever parameter I add to my parameter list last is the winner, all others I must enter via the prompt dialog. Here's the code:

        Dim paramFields As New CrystalDecisions.Shared.ParameterFields
        Dim paramField As New CrystalDecisions.Shared.ParameterField
        Dim paramFieldRange As New CrystalDecisions.Shared.ParameterDiscreteValue

        Me.crvReportViewer.ReportSource=rptSource

        paramField.Name = "@datStart"
        paramFieldRange.Value = gdatReportStartDate
        paramField.CurrentValues.Add(paramFieldRange)
        paramFields.Add(paramField)

        MsgBox(paramField.Name.ToString())

        paramField.Name = "@datEnd"
        paramFieldRange.Value = gdatReportEndDate
        paramField.CurrentValues.Add(paramFieldRange)
        paramFields.Add(paramField)

        paramField.Name = "@txtUser"
        paramFieldRange.Value = System.Environment.UserName
        paramField.CurrentValues.Add(paramFieldRange)
        paramFields.Add(paramField)

        Me.crvReportViewer.ParameterFieldInfo = paramFields
        Me.crvReportViewer.Refresh()

What I see in the autos window is that paramfields has three items and that all three are exactly the same. I know that this is the issue, but how do I get the paramfields to contain the three different parameters? Does this have something to do with using the ParameterDiscreteValue? Thanks

[techgnome]

put this after you add the parameter, before you set the name on the next one.

paramField = New CrystalDecisions.Shared.ParameterField

What's happening is that you are recylcing the same object, instead of creating new ones.... so each parameter you "add" simply points to the last one by name. By creating a new instance after adding the previous one, the problem should go away.

-tg

[katuil]

Thanks for the obvious. I also found that paramFieldRange was creating a problem as well. I set up three separate parameter field ranges because one was still pushing in the last value into all three parameters.