I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run and it is rendered. At the first user interaction it errors out regardless.
1) Has anyone run into an issue where the difference between SQL and Reporting Services is this huge?
September 14, 2009 4:15 PM
September 16, 2009 2:57 AM