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/

🙂