how can i pass parameters to a stored procedure..

[asknelson19]

I am using crystal reports xi and sql server 2000.
I have a report with two dynamic prompts and a stored procedure with two prompts.
How can i pass the promp values chosen from crystal reports to the stored procedure?

any help will be appreciated..

 

[Madawc]

I've got Crystal 10. When I used Stored Procedures, I gave them their own parameter fields, which sometimes replaced similar fields on the Crystal.

Since no one else has made a suggestion, you'd better do that.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[ycrofts]

I have a the exact same issue (problem) & am really having trouble finding a solution after many searches.

I have a Crystal XI report, based on a stored procedure (SQL Server 2005 database), which expects a few input parameters. Crystal reports automatically includes these parameters for the procedure (preceded with a @) in the report, resulting in a basic text prompt dialog whereby the user is expected to type in the value for each parameter.

...However, I'm wanting to have these parameters appear as dynamic - each selecting a list of values for the user to select from, from an existing table in the database, and the selected value for each then being passed as the input parameters for the stored procedure.

I've tried modifying the parameters that were automatically created as being dynamic, but this doesn't work

Any help would be greatly appreciated, please!

Yvonne

 

[Madawc]

You've now started a new thread, that's the best way. I've never used Dynamic Parameters so I can't help.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10