passing parameters to stored procedure from crystal reports

  • Thread starter kavitha N via .NET 247
  • Start date
K

kavitha N via .NET 247

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

exec sp_example @date='{?selecteddate}'

here date and selected date are of type varchar() whenever i amadding this command in add command (which is there fieldexplorer -> database fields) it's saying failed to open a rowset.

syntax error for converting datetime to string.

if you have any idea please do reply.
 
Joined
Feb 15, 2011
Messages
1
Reaction score
0
Hi All,

I'm also encountering similar issue. Does anyone have a good solution to this?
Or perhaps can someone point me to the right direction.

Thank you so much in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top