Using Crystal Reports date parameter for stored procedure in Oracle

[crystaldev1]

Hello,

I'm using CR2008 and Oracle DB. I have a report using stored procedure as a datasource and has a date parameter. When I select a date from Crystal Reports and run the report, I get an error message as follows:
ORA-01722: invalid number

However, if I do not select a date and use NULL, the report runs fine since the stored procedure has a DATE DEFAULT TRUNC(SYSDATE - 1). It appears that the stored procedure does not like the Crystal Reports date format. Any suggestions? Thanks.

 

[IanWaterman]

You should not create a Crystal Reports parameter. Delete parameter. Crystal will automatically create a parameter for the SP if one is required.

Ian