CR 9 and stored procedures

[bjrollet]

I designed a report in CR9. It is based on a SQLServer 2000 stored procedure that has 5 parameters, including two dates. The sp executes fine in Query Analyzer, and the report works fine in the designer. However, the report will not execute from my code in the report viewer. I have verified the database, and the parameters are being set correctly. I do not recieve an error message, the report simply doesn't appear. Also, when I click the refresh button, I am prompted for new parameters. This tells me the report is loaded correctly, but it is not appearing in the report viewer. Any ideas????



Thx.



My lips are tingling from the spicyness of this conversation.

 

[JodieH]

Try running SQL Server Profiler to see exactly how CR is executing the stored procedure; it might not be doing exactly what you expect!