August 19, 2008 at 10:41 am
Hello
I have developed a report which is set to auto-refresh, and it runs fine and works fine, but after a few mintues (say 30mins) i get the following error message:
An error has occurred during report processing.
Query execution failed for data set 'dbname'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Can anyone help?
September 9, 2008 at 6:28 am
can u paste your SQL Query or Stored proc text you are using, to get some more idea?
September 9, 2008 at 6:39 am
I used a query to generate the result set which is:
Select Col1,Col2,Col3,Col4,Col5,Col6,
FROM Table A
Where Date BETWEEN GETDATE() AND GETDATE()-1
Its a simple query and not a stored procedure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply