Go to this link:

https://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/

Search for:

Option 2: Disabling Parameter Sniffing

This is what resolved the issue for me.

If your report involves calling a Stored Procedure with parameters, you may want to check out this link about Parameter Sniffing. Option 2 worked for my report.

http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/

🙂

Refer to this article on Parameter Sniffing. I encountered the same problem and utilized Option 2 and the problem was resolved. 🙂

http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/