i just can see the SQL query at "Database"->"Show SQL Query". How do I edit it in Crystal Report?

You are looking for <code>Edit Command</code> within the Database Expert ... see the screenshot below. <img src="https://i.stack.imgur.com/YMAQs.png" alt="enter image description here">

How to edit an existing query in crystal report

i just can see the SQL query at "Database"->"Show SQL Query". How do I edit it in Crystal Report?

How do I modify a query in Crystal Reports?

Editing a Query Once the Crystal Report is created using a query, to make changes to objects you have to go to edit data source option. When you click on the option, it will open an Edit Query panel where you can add/delete objects, apply filters, etc.

How can I change SQL query in Crystal Report 9?

First Right Click on Database Fields > Set Datasource Location > Select View which you want to replace with another. Save this answer.

You are looking for Edit Command within the Database Expert ... see the screenshot below.

enter image description here