I built a stored procedure to test a process that I want to put in place with another report - this sp is very simple, the other won't be. The whole thing works well in management studio and renders a report fine, but when the .rdl in the reports manager and view, I get an error.
An error has occurred during report processing.
Query execution failed for data set 'DataSet1'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
select * from omni_cancellation where year(cxldate) = year(getdate()) and month(cxldate) = month(getdate())