Crystal Reports provides the flexibility to use your own SQL queries for creating reports. Crystal Reports allows you to use SQL commands directly to retrieve data from your database, giving you more control over the data retrieval process and the ability to leverage the full power of SQL.

Here's how you can use your own SQL for creating a report in Crystal Reports :

1. Open Crystal Reports and create a new report or open an existing report.
2. Go to the "Database" menu and select "Database Expert." This will open the Database Expert window.
3. In the Database Expert window, select the appropriate data source or create a new connection to the database.
4. Once you have selected the data source, click on the "Add Command" button. This will open the SQL Editor.
5. In the SQL Editor, you can write your own SQL query to retrieve the required data for your report. You can use any valid SQL syntax and functions supported by your database. 6. After writing the SQL query, click on the "OK" button to close the SQL Editor.
7. Crystal Reports will now treat the SQL query as a virtual table or view, and you can use it like any other table in your report.
8. Drag and drop fields from the SQL query onto the report canvas to include them in your report design.
9. Customize the layout, formatting, grouping, and calculations as needed.
10. Preview and run the report to see the data retrieved from your database using your own SQL query.

By using your own SQL in Crystal Reports, you have the flexibility to write complex queries, join multiple tables, apply custom filters, aggregate data, and perform advanced calculations as per your specific reporting requirements. This feature allows you to tailor the data retrieval process to suit your needs and utilize the full capabilities of your database's SQL language.