Date Parameter not passing to Stored procedure

building reports crystal reports
1

I have a stored procedure with ref cursor and having two i/p parameters as Start Date and End Date.

I used this SP in my crystal report but unable to get any data.My report is running fine without these parameters.

I think this is an issue related with the format of the date as in crystal the date picker is having date with time part as well.

Does anyone came across such situation ? if yes please provide your inputs on the same.

Thanks in advance
Anoop

Anoop Shihoorkar :india: (BOB member since 2007-02-15)

2

Can I ask what datatype did you declare in the stored procedure?

Or could tell us more on how you did the passing of parameters… :smiley: :smiley:

hariiu (BOB member since 2007-03-22)