passing a paramter to a store procedure 1

[fsreport]

hi All
Brain freeze here
i have a stored procedure and it has no parameter in it
i would like to created a parameter in crystal and pass it to the store procedure.
Ex:let say i created parameter in crystal base on employee ID
How will i go about creating it.
I know how from a table but never from a store procedure.

thanks


fsreport

 

[fsreport]

ops
cr 9.0
ms sql
sorry

fsreport

 

[fsreport]

added more info from user
they want to be able to select multiple id also
ex:
id: 01,02,03,04
or
All

fsreport

 

[Turkbear]

Hi,
What database and connedtion method..

In general, it is difficult to pass a multi-value parameter to the stored procedure unless you can create a delimited string with all the selected values and pass that as the input parameter to the SP and handle the decoding it within the SP itself..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[fsreport]

hi Turkbear
thanks for the replied
i created a store procedure and declared the @parameter in it
when i created a new report and add the store procedure it prompts me for value
should it do that or only when i run the report with the store procedure in it and prompts for the value after i have it inserted in the report ???????????


fsreport

 

[fsreport]

when i created a new report and when i import the store procedure it prompts me for value
should it do that

fsreport

 

[fsreport]

Hi
got it to work
thanks


fsreport

 

[Jimdeb03]

Ok, I'm assuming you can pass a parameter from a Crystal report directly to a SQL Server stored procedure.

Just how do you accomplish this w/o going through the hassle of adding the sproc as a command in the report?

I've added parameters to the sproc and to the report. Named the parameters the same but apparently am missing something and cannot find an example.

Jim