We can easily create queries in Crystal Report. Crystal Report handle large amount of data separately. This is most basic benefit to create query in Crystal Report. Some data source approve connections to create a query in Crystal Report.
First, click 'Add Command' to write the query and click 'Next' button. To create queries in Crystal Report, follow this process,
Go to File → New →Report →Add Command
Here, we find a Window in our desktop. Write our query here and click OK.
Now, we see here the data of the database, which we connect with the report.
Editing a Query
It is possible to edit a query in Crystal Report, to edit the query to objects, we have to go to edit in the data source option, add or delete the data, according to our requirement.
Summary
Thus, we learnt, how to create and edit the queries in Crystal Report.