Passing DateTime parameter from VB.

[nag999]

Hi All,

I am facing a strange problem in passing DateTime() parameter from VB. I had written the following code to pass DateTime Parameter in crystal.

.ParameterFields(4) = "Contract Status As of Date;DateTime(" & strYear & "," & strMonth & "," & strDay & ",0,0,0);True"

It is giving me "Invalid Parameter field Value" Error.

Thanks,
Nagaraj

 

[synapsevampire]

Are you using the RDC, OCX, or ?

There are lots of threads here addressing each, and crystaldecisions.com has plenty of examples too.

kenhamady has a tutorial:

http://www.kenhamady.com/vbref.html

Either post specifics or try the above.

-k

 

[nag999]

Hi Synapsevampire,

I am using the OCX. I had a stored procedure, which has date parameter to accept. On attaching the stored procedure to the report, It created a parameter of type DateTime in Report. When I am passing DataTime parameter from VB to crystal it is giving me error.

After going thru the below Knowledge base from Crystal,I feel that it is not possible to send the DateTime value from VB to Crystal.

http://support.crystaldecisions.com/library/kbase/new_articles/c2006899.asp

http://support.crystaldecisions.com/library/kbase/new_articles/c2003724.asp

Btw. Still You feel any other workaround other than above article is really helpfull.

Thanks once again

Regards,
Nagaraj

 

[dafty]

please use RAS . Your problem will resolve.

RAS : Report Automation Server

----------------------------------
[daftywork : work 4 everyone.]
>>

http://dafty.tk/