Get parameter to SQL stored procedure

rhst11 · #1 (**permalink**) 10-10-09, 07:12

I'm a newbie using CR10. I'm creating a report from SQL stored procedure. How can I get a parameter value and send to a variable in the stored procedure?

gvee · #2 (**permalink**) 10-10-09, 10:02

If the stored procedure accepts parameters then it should prompt you for these values when you pick it as the data source?

rhst11 · #3 (**permalink**) 10-11-09, 21:09

In store procedure, it's a declared variable. Crystal report doesn't pick up this variable. What can i do?

gvee · #4 (**permalink**) 10-12-09, 08:13

You'll have to make the stored procedure parameterised!

Internet Services

Web Development

Digital Marketing

Consumer Tech