Hi
I have read a number of threads on this but can't seem to find one that matches the problem i am having. I am trying to pass multiple parameters to a crystal report which seems to work fine and doesn't display any errors or parameter prompts, however all the parameters on the report are displaying the same value. That being the value of the last parameter added to the parameterfields variable. My code is below.
Any help appreciated.Code:Dim RepReferralsB As New AppropriateReferralTO Dim pFields As New ParameterFields Dim disval As New ParameterDiscreteValue Dim pField1, pField2, pField3 As New ParameterField pField1.Name = "datStart" disval.Value = StartDate pField1.CurrentValues.Add(disval) pFields.Add(pField1) pField2.Name = "datEnd" disval.Value = EndDate pField2.CurrentValues.Add(disval) pFields.Add(pField2) pField3.Name = "RefType" disval.Value = RefType pField3.CurrentValues.Add(disval) pFields.Add(pField3) RepReferralsB.SetDataSource(dsData) ReportViewer.ReportSource = RepReferralsB ReportViewer.ParameterFieldInfo = pFields
Thanks




Reply With Quote