Passing multiple parameters to CR via VB App

[ter79]

I'm trying to pass two (2) parameters to a CR from a VB app. I keep getting an error message stating "Error 20553(invalid parameter field value)"

I have included the code that I am using.

Any and all assistance is greatly appreciated.


cr.Destination = 0
Screen.MousePointer = vbHourglass
Me.Enabled = False
cr.WindowShowCancelBtn = False
B = Format$(Text1, "yyyy,mm,dd&quot
D = Format$(Text2, "yyyy,mm,dd&quot
cr.ParameterFields(i) = "BeginDate;Date(" & B & "True"
i = i + 1
cr.ParameterFields(i) = "EnDate;Date(" & D & "True"
cr.Action = 1

 

[kenhamady]

What does "D" look like at that point. My guess is that it isn't in Crystal syntax. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[ter79]

D is a second date. When I hover over the line in step by step mode in VB, it show the correct format, however as soon as I go to the next step it erases the first parameter.

I tested the code by sending the first paramater only and it works, since CR prompts me for the second parameter field.

 

[kenhamady]

Are you sure that the parameter name is spelled correctly, like should it be EndDate instead of EnDate? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[ter79]

The spelling is correct, a mistake on my part during the creation of the parameter name.

 

[kenhamady]

If both parameter fields are the type "Date" then you need to do some troubleshooting testing. First I would hard code the i value for each parameter, then test them both separaterly, then I would hard code the value, then try reversing the order. One of these may tell you something. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com