cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Command parameter prompt very slow

Former Member
0 Kudos

I'm running Crystal XI. When using sql command parameters why would it take 5 minutes for the parameter input screen to prompt for new values? There is a date and a couple of dept and site parameters.

Accepted Solutions (1)

Accepted Solutions (1)

former_member292966
Active Contributor
0 Kudos

Hi Marilyn,

I ran into this recently as well. I believe Crystal is compiling the SQL before it displays the prompts. Once I optimized my query, the prompts came up as they should.

Of course if your query is pretty large and would generally take a while to run this may not help you.

Good luck,

Brian

Former Member
0 Kudos

Hi Brian,

Thanks for the help.

Marilyn

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Have you applied any service pack for crystal reports?

Database do you have?

Connection OLEDB/ODBC....?

Does reports without parameter works fine?

Does the issue is with all the report or single report?

Operating system do you have?

Regards,

Shweta

Former Member
0 Kudos

Hi,

Crystal Reports Version 1.5.8.826 No service packs

Database do you have? MSSQL

Connection OLEDB/ODBC....? ODBC

Does reports without parameter works fine? Have not tested yet

Does the issue is with all the report or single report? Most of them yes.

Operating system do you have? Windows 2000

Thanks,

Marilyn