Generate Crystal Reports using SQL queries

Question

I am using Crystal Report 8.0.1.0.

I want to generate some reports based on some SQL queries on a particular DB.

Please can you tell me how to do this?

Answer 1

1. Make a data connection to the required database in crystal report.
2. Open the command and paste your query there and click ok.
3. Now go to the design and place the fields and create required report.

Let me know if you need further guidance