SYMPTOMS:
Report preview timing out whenever using Demand and Capacity By Date data provider in a report.
ERROR/WARNING MESSAGES:
Error is: Tbl:DataBind> Timeout expired. The timout period elapsed prior to completion of the operation or the server is not responding.
REASON:
Data provider is taking longer than Report Designer timeout to return data.
WORKAROUND:
Changing the CommandTimeOut Value in the Report Designer Web.Config
RESOLUTION:
Current Value – 30 seconds
What is recommended – 10 minutes