I have certain rdls created in SSRS 2008 and deployed on a Share point server.Some of these reports fail on the server side with the following error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DataSet2'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors But when i download the same and preview them in VS the output is displayed.Sometimes when i redploy them the report start working at the server side as well. Can someone help me on this?

Hi, From your descriptioin, follow these suggestions to do futher troubleshooting: 1. Have you rights to access the database of the report data source? Check your datasource credential on the sharepoint site. 2. If your report calls a shared datasource, check if the datasource is also deployed on the sharepoint and can be access by the report dataset. 3. Is there any data returned by the report dataset? For example, you select some report parameter value to cause no data returned. thanks, Jerry

The report does run some times.But this error comes at random. If there would be access related issue,then it would not run at all. This is why I am puzzled.