Quesry runs Slow in SQL - fast in Crystal

[Ladyazh]

I have this Report that uses a view i've created in SQL Server.
I can only run it in SQL Server for 1 ID at the time.
When I run Crystal - I can have 6 IDs and it is running in a seconds. What gives? It drives me crazy...ODBC connection.
Nothing fancy. Anyone ever experienced that?

 

[Turkbear]

Hi,
Use the Database..Show Sql Query menu option and compare the code produced by Crystal to what you use to run in SqlServer..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Ladyazh]

I can run query from Crystal in SQL Query Analizer fast.
Not when I am opening View design - time out!