Check all following conditions:
----------------------------------
Step :1
- The connection string for the data source, which is - Connect Timeout=100
- Tools>Options>Database Tools>Query and View Designers. Cancel long running query is set to 100 or max 60000
- Tools>Options>Database Tools>Table and Database Designers>Checked 'Override Connection String time-out value for table designer updates. Transaction time-out after is set to 100 or max 60000
Step :2
- Open your web browser on the server and go to http://localhost:80/Reports
- Navigate to the Report location and click on the problem report(s).
- On the left-hand pane, click on Properties.
- In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’. (via
Step:3
Set the HttpRuntime ExecutionTimeout
- Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services.
- From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-hand pane, right-click ‘Web.Config’ and select ‘Open’.
- Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the section.
- Set the executionTimeout value to ‘10800’ (3 hours) as shown below:
Step: 4
Tools>Options>Database Tools>Table and Database Designers> check the option prevent saving changes that requires table re-creation
step: 5
also check your results by executing the procedure or SQLstatement