SSRS: A severe error has occurred on the current command. The results, if any, should be discarded?

This sounds like the report is timing out. Try setting the Report Execution Timeout to a longer value.

Up vote 1 down vote favorite share g+ share fb share tw.

I'm developing an SSRS 2008 report using stored procs. Previously this report was running successfully. Now, however, these stored procs still run but when I run this report I get the following error: A severe error occurred on the current command.

The results, if any, should be discarded. Operation cancelled by user. What is the cause of this and how can I debug?

Reporting-services ssrs-2008 link|improve this question edited May 31 '11 at 16:30Alison16.4k83161 asked May 31 '11 at 15:24salvationishere7321831 63% accept rate.

This sounds like the report is timing out. Try setting the Report Execution Timeout to a longer value. Take a look at this MSDN link: Setting Time-out Values for Report Processing.

Thanks, Alison. I figured this out now. I just started with the smallest element and gradually rebuilt my report until I found the cause...

You should share your answer with everyone else. – Alison Jun 1 '11 at 14:08.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.