Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RDC date parameter problem

Status
Not open for further replies.
krshaikh

krshaikh

Programmer
Nov 18, 2001
45
US
Hi,

I am trying to export a report in MS WORD format using Crystal Report 8. The report uses a stored procedure which has one String and two date parameters. I have downloaded an example from Crystal Descions which explains how to export a report using RDC.

Following line is being used to pass string parameter to the stored procedure

CROBJECT.Parameters.Item(1).AddCurrentValue("12000")

Type Mismatch ! Error occures when I try to pass the date value which is suppose to be in this format as shown below

CROBJECT.Parameters.Item(2).AddCurrentValue("2004-04-01 00:00:00.000")

Thanks in advance for the help.

Regards,

- krshaikh -





 
Status
Not open for further replies.

Similar threads

allyne
  • Locked
  • Question
RE: Sub Reports with parameters 1
Replies
3
Views
202
allyne
allyne
Statey603
  • Locked
  • Question
Input Parameters screen issues: multi-line and width
Replies
0
Views
184
Statey603
Statey603
telex2
  • Locked
  • Question
Ignoring Characters when entered by user in Parameter Field 1
Replies
2
Views
136
telex2
telex2
Creamac
  • Locked
  • Question
search Enterprise based on scheduled dates
Replies
5
Views
157
Creamac
Creamac
zsyed
  • Locked
  • Question
Page skip problem
Replies
3
Views
148
zsyed
zsyed

Part and Inventory Search

Sponsor

Back
Top