Report taking too long to generate

I am running a crystal report using the viewer from vbnet (framework 4.0) and reports without record selection run as expected. If I add a record selection such as JobNum > 4000 to the report the report generates and database error code 17 which I suspect comes from a timeout. I also get the same error if there are parameters on the report.

I am running 13.0.10.1385.

any ideas of how to solve the problem.