Editing Query and then Saving.

[Former Member]

Just wondering if it is possible to edit a query in Crystal Reports WITHOUT running it.  I have a query that I need to edit, but I do not want to run it right away.  The problem I am having is that when I edit the command through Database Expert, I have to click the 'OK' button.  Clicking that button then runs the query, which then causes Crystal to crash, and I have to start over because I was unable to save my edits.  Does anyone know a way around this issue?

[DellSC · Accepted solution]

Work on the query in a database tool outside of Crystal, such as Toad or SQL Server Management Studio.  Get it working there with hard-coded values for any parameters you're using.  Then copy it and paste it in to the Command editor, making whatever changes are needed for any parameters that you're using.

-Dell

[Former Member · Accepted solution]

Thanks for responding.  That helps me a lot.