Time Out error in SQL reports

• NinjaWolfen

  Newbie

  Points: 7

  More actions

  March 18, 2002 at 12:22 pm

  #158270

  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?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 18, 2002 at 12:56 pm

  #425578

  Crystal is somewhat of a bane to get to work properly. Check out http://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)

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 18, 2002 at 1:58 pm

  #425587

  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

  Andy
  Connect with me on LinkedIn