Error depending on the data range of the parameter

[crystaldev1]

I'm using CR 9 and SQL Server 2005. I have a report with parameters startdate and enddate as a date range. This report runs fine if the date range is 1 or 2 days but errors out if it's any longer than that. Here is the error:

" Failed to open a rowset.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: [DBNETLIB][ConnectionOpen(Connect()).]
SQL Server does not exist or access denied.
SQL State: 08001
Native Error:
Failed to open a rowset.
Error in File C:\.........rpt:
Failed to open a rowset. "

Any suggestions? Thanks.

 

[lbass]

What is your record selection formula? How are the parameters set up?

-LB

 

[crystaldev1]

I believe the report times out. Is there any way to increase the connection timeout from the report? Right now it is set to "Connect Timeout = 15". Thanks.