http://blogs.technet.com/b/thomase/archive/2011/12/08/incident-reports-failing-with-query-execution-failed-for-dataset-relatedcis.aspxI ran into a funny problem the other day when working with the SCSM Incident reports. The reports all ran fine, but when we wanted to drill furter down we got the following error: Query execution failed for dataset 'RelatedCIs'. (rsErrorExecutingCommanden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/thomase/archive/2011/12/08/incident-reports-failing-with-query-execution-failed-for-dataset-relatedcis.aspx#3510170Sun, 22 Jul 2012 19:11:32 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3510170Thomas Ellermann<p>Hi John, I&#39;m glad you ended up with a working environment.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3510170" width="1" height="1">http://blogs.technet.com/b/thomase/archive/2011/12/08/incident-reports-failing-with-query-execution-failed-for-dataset-relatedcis.aspx#3507151Tue, 03 Jul 2012 09:03:56 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3507151John Smith<p>Thanks, This fix worked for us, however for reasons I don&#39;t understand the reportuser wasn&#39;t granted access to the stored procedures after I copied them. I had to grant them execute access to each of the stored procedures. Once I did this then the reports worked</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3507151" width="1" height="1">