Passing Date To Parameter Field

[664950]

Please advise me how to pass Date to Parameter Field. I used CRDepoziti.ParameterFields(0) = "datum;Date(2002,24,03);TRUE", but it doesn't work. I have a message "Subcript out of range". datum is my parameter and CRDepoziti CR Designer

 

[Ngolem]

that might be because you are using a "0" element...try it for CRDepoziti.ParameterFields(1) instead

Jim

 

[664950]

I tried with 1 and the message is Object does not support this property or method

 

[kenhamady]

Which integration method are you using? faq149-237 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

 

[664950]

ActiveX (CR 8 Designer)

 

[kenhamady]

Sorry, do you mean:

OCX (Crystal32.ocx) or
RDC (CraxDrt.dll/CraxDui.dll)
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

 

[664950]

I am using RDC

 

[kenhamady]

The problem is that you are using the OCX syntax. You want to use a command like AddDefaultValue or AddCurrentValue, and an index that starts with 1, based on how many parameters you have in the report.

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

 

[664950]

OK I said:
CRDeponenti.ParameterFields(1).ClearCurrentValueAndRange
CRDeponenti.ParameterFields(1).AddCurrentValue (#2/2/2002#)

But I am still prompted for parameter filed value

 

[kenhamady]

The syntax looks correct.
Is there only one parameter?
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

 

[664950]

Yes only one, and when I enter the value from the prompt, my report discard the value that has been passed.

 

[kenhamady]

Is your prompt set to accept a date or a datetime? Check the data type. 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