Well done, Rob! (..and nice reference to Paul Harvey)

I can't imagine a report running from seconds to hours, and of course, only in production (arrg!) Performance problems due to parameter sniffing can suddenly appear in SSRS so keep an eye out for this issue in the future for other reports, especially if the underlying query is altered.

--Pete