SSRS returning different results than the stored procedure

Question

I have a stored procedure that I can call from Management Studio and it returns 56 rows consistently. However, when I execute the query under from inside of ssrs 2008, I get back 61 rows. The stored procedure uses cursors and has some print statement inside of it.

Thanks,

Answer 1

I had a similar problem when I had an a stored procedure return warnings messages. It caused problems returning inconsistent results just in my SSRS dataset/report. I set ansi-warnings to off and my problem went away. You may want to comment out your print statements and try that.

Thanks, Steve