Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcpollock
Starting Member
1 Post |
 Posted - 2004-06-15 : 10:43:53
|
I have a stored procedure that has 3 input and 9 output parameters. When I try to access the sp from crystal reports (9) it asks me for the input parameters and then fails and gives an error to the effect that I have not given any value to the output parameters and won't let me get to the design part of crystal.Got any ideas?? |
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2004-06-18 : 07:55:13
|
| Make sure that you use 'SET NOCOUNT ON' so that the stored procedure does not return that as an extra value to crystal. I had a similar problem when someone modified a stored procedure and removed that, the report wouldn't work at all and we thought it was the code changes.Scooter McFly |
 |
|
|
|
|
|
Stored Procedures OUTPUT and Crystal Reports