After adding 100+ SQL queries to a report, you may encounter the following error:
A connection cannot be made to the database. Timeout Expired. The timeoutThis can be fixed by changing the Pooled value of the dataset from true to false.
period elapsed prior to obtaining a connection from the pool. This may have
occurred because all pooled connections were in use and max pool size was
As long as the performance of the report is not adversly affected and only a few users will be running the report, then this should not be a problem.