Stored procedure works as data set when querying but, errors out using matrix report


  • I can successfully set up the dataset using a stored procedure but, after I create the report using the Matrix wizard and run the report, I get an error.

    The EXECUTE permission was denied on the object 'usp_DischargedToHome', database 'livedb', schema 'dbo'.
    Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
    An error has occurred during report processing. (rsProcessingAborted)

    Tuesday, November 19, 2013 8:59 PM