Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing a paramter to a store procedure 1

Status
Not open for further replies.

fsreport

Programmer
Mar 23, 2007
128
US
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
 
added more info from user
they want to be able to select multiple id also
ex:
id: 01,02,03,04
or
All

fsreport
 
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..



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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
 
when i created a new report and when i import the store procedure it prompts me for value
should it do that

fsreport
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top