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