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.
Brian Dong replied
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.