When attempting to run Ad Hoc query reports from Report Explorer in version 4.0, an error is received: An error has occurred during report processing (rsProcessingAborted). Query execution failed for dataset 'AdHocQuery' (rsErrorExecutingCommand). Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
We’re currently evaluating this issue for a fix in a future patch or service pack.