Hi, I have SQL Server 2008 R2 10.50.1600 and Visual Studio 2008 Version 9.0.30729.4462 QFE (.NET 3.5 SP1 Framework). In visual Studio, I created report data-set using SQL Store Procedure and when I click on "Refresh Fields" it gives below error: Micosoft SQL Server Report Designer "ExecuteReader requires an open and available Connection. The connection's current state is closed." Report data source is SQL Server 2008 R2 and store procedure execute sussfully using SQL Server Management Studio and "Query Designer" button too. After clicking on "Refresh Fileds" button visual studio waits for few seconds and generate above error. Any idea how to resolve this error? Thank You.

Hi KM IT, Just based on the error message, it shows the connection is closed. So, please first check the data source connection by the steps below: 1. In the Report Data pane, right click the data source and select Data Source Properties. 2. Click the Edit button beside the connection string. 3. In the Connection Properties, click Test Connection to see if it succeeded. If it doesn’t work, please try to re-establish the connection and test it again. Then please also post the result. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi KM, Try to follow Tony's steps. Sometimes you need to delete the dataset and recreate it. I hope it should work after that. All the best.Dasari