I am having trouble passing multiple values to a paremeter. We have a Crystal report with an EmployeeID parameter that is set up to accept multiple values (4,5,...).
I can call the parameter with a single discrete value and everything works fine, as in:
~~~~~~~~~~~~~~~~~~~~
Set Values = CreateObject("crystalReports.Values")
Set DiscreteValue = CreateObject ("CrystalReports.ParameterFieldDiscreteValue")
DiscreteValue.Value = ParamValue
Values.Add DiscreteValue
Session("oClientDoc").DataDefController.ParameterFieldController.SetCurrentValues "", "EmployeeID, "4"
~~~~~~~~~~~~~~~~~~~~
However, I have been unable to find any documentation that explains how to pass more than one value. I have tried various mechanisms and have been unable to get it to work. Is there any other property that will allow us to pass multiple values?
Session("oClientDoc").DataDefController.ParameterFieldController.SetCurrentValues "", "EmployeeID, "4,5
I can call the parameter with a single discrete value and everything works fine, as in:
~~~~~~~~~~~~~~~~~~~~
Set Values = CreateObject("crystalReports.Values")
Set DiscreteValue = CreateObject ("CrystalReports.ParameterFieldDiscreteValue")
DiscreteValue.Value = ParamValue
Values.Add DiscreteValue
Session("oClientDoc").DataDefController.ParameterFieldController.SetCurrentValues "", "EmployeeID, "4"
~~~~~~~~~~~~~~~~~~~~
However, I have been unable to find any documentation that explains how to pass more than one value. I have tried various mechanisms and have been unable to get it to work. Is there any other property that will allow us to pass multiple values?
Session("oClientDoc").DataDefController.ParameterFieldController.SetCurrentValues "", "EmployeeID, "4,5