Has anyone used a stored procedure with the OUTPUT parameter to fill in a field(s) on a crystal report? I've written a stored proc but am unsure how to view the output or implement in a crystal report. When I run the stored proc all I see is "The command(s) completed successfully." I'm at a loss on how to debug/verify/view the output value. How can I plug this into a crystal report?

I guess basically, I want the stored proc to act like a function and return a scalar value and plug it into the cr. (a function cannot be used in my circumstance)

The same thing happens using this example from MS.

CREATE PROCEDURE titles_sum @TITLE varchar(40) = '%', @SUM money OUTPUT
AS
SELECT 'Title Name' = title
FROM titles
WHERE title LIKE @TITLE
SELECT @SUM = SUM(price)
FROM titles
WHERE title LIKE @TITLE
GO

Thanks.

KB