Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Command parameter prompt very slow

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.

Former Member

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,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question