value/range has already existed 2

[jameslx]

I am getting a message saying value/range you are adding has already existed. I am runnung the crystal report using VBscript. I am accessing SQL tables to get parameter values for the report. the error occurs on this line of code.

crParameter.AddCurrentValue CStr(Trim(ParValue(i)))

 

[jameslx]

Have found the anser I was looking for. There are times when crParameter.AddCurrentValue already has a value and if you enter the same value it returns an error message. To correct this you need to enter this code before adding a new value crParameter.ClearCurrentValueAndRange