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.