SSRS errors using stored procedure, but allows the identical script to work
I have other reports, using other stored procedures on other databases, working without difficulty. I was even able to create the desired report by putting all of the script in the SSRS report, instead of in a stored procedure.