Thanks for your input.

It is definitely not an issue with the speed of execution of the SQL code. I know this because:

1) The report is not executing a stored procedure. it is executing the T-SQL as shown in my first post.

2) When I use SQL Profiler, the T-SQL always executes in less than a second.

3) Google Chrome is able to view the same report in 2 or 3 seconds.