on 05-06-2009 5:15 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.