1

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?

NakedBrunch
  • 48,713
  • 13
  • 73
  • 98
salvationishere
  • 3,461
  • 29
  • 104
  • 143

2 Answers2

0

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

NakedBrunch
  • 48,713
  • 13
  • 73
  • 98
0

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

salvationishere
  • 3,461
  • 29
  • 104
  • 143