Time Out error in SQL reports

  • Please, someone help me

    I'm working with VB SQL server 7.0 and crystal Reports doing a SQL internal report from VB with the crystal designer ocx but in design time it makes an error:

    Microsoft OLE DB provider for SQL Server:

    wait Time finished.

    this happends when i insert an SQL Query into the crystal designer, if i make the query directly in SQL it works without a problem.

    Please help me. What can I do?

  • Crystal is somewhat of a bane to get to work properly. Check out www.crystaldecisions.com for their knowledge base and self help. Otherwise it makes it hard without looking at the source code to be able to help.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • If you've got a query that works it is often easier to create it as a view, then run the report on the view. This has the added plus of abstracting the where clause out of the report so you can easily tweak.

    Andy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply