Lilbuddha
asked on
Visual Studio 2005 - Hangs While Building Report
I am trying to post a report using Visual Studio to our SQL Reporting Services Report Manager. I am using a standard template where I connect to my data source and call a stored procedure. The sproc in SQL Management Studio takes 6 seconds to run, but in Visual Studio, I cannot get this to run the same sample date range to adjust the template to the new data fields & design the corresponding report. I am not getting any error, it is simply hanging. Accidentally, I left it running while doing something else and saw that at some point in the hour the data appeared. So a procedure that takes 6 seconds in Management Studio is taking up to an hour to run in Visual Studio.
Any suggestions?
Any suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER