We've run into a couple of cases where a report ran slow but the same query in SSMS responded just fine. In those instances the problem was either an issue with parameter sniffing occurring in a given stored proc or that a stored proc was returning "select * from

" rather than explicitly listing the fields to be returned by the stored proc.

--pete