I deployed several reports to a new installation of SSRS and all reports execute a stored procedure.
All the reports work fine except for one. It's not executing the stored procedure. There's no 'No Data' message, just nothing. It works fine in Visual Studio connected to the same database and executing the same stored procedure.
To confirm, I have the stored procedures writing the parameters to a table, and this one report isn't writing anything to the table at all. I also have error written to the table in the BEGIN CATCH...END CATCH section, and nothing is there.
I also looked in ReportServer.dbo.ExecutionLog and there's nothing to suggest it even ran.
The stored procedure it runs has the same permissions as the other reports that are running fine.
All the reports have cascading parameters and these work fine on all reports except this one.
The only thing that works is the drop down menu, which are query-driven. So those are working, so it's like it sort of connects with the database.
I cannot figure out why one report doesn't run the stored procedure. Any ideas?