469,645 Members | 1,672 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

pass parameter to stored prodedure from crystal reports

Hi All
I am trying to create crystal reports. In this concern i have created a command which execute a stored procedure. This stored procedure takes three parameters which in turn i want to pass it from .aspx page. when i click on button parameters should pass to that stored procedure.
for example

exec sp_example @date='{?selecteddate}'

here date (varchar in stored procedure) and selected date (string type i selected) whenever i am adding this command in add command (which is there field explorer -> database fields) it's saying failed to open a row set.

syntax error for converting datetime to string.

if you have any idea please do reply.
Dec 18 '07 #1
1 1761
8,127 Expert 4TB
You need to convert to proper type before processing.
Dec 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by mounilkadakia | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.