Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 668
Sk.Jc Avatar asked Oct 07 '14 10:10

Sk.Jc


People also ask

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.


1 Answers

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

enter image description here

like image 108
AHiggins Avatar answered Oct 14 '22 08:10

AHiggins