I've also tried with no success...

I inserted the data into a table and just did a select *. No gain.

I moved that table local on the same server as the reporting services. report runs in 6 Seconds.

I'm going to start looking at perfmon to see if I can see anything out of the ordinary.