crystal reports - how to create a report by giving SQL query

Question

I am using VS 2005. I need to create a report which shows result of the following sql query

select count(*) from Student order by group_name

I have created data connection to Student. How do I create report for this query?

Answer 1

File > Add > Crystal report? Then drag your data onto the report surface.

Answer 2

Create a new report. Choose your data source. Expand data source until you see 'Add Command'. Double-click that node. When the Command-object's window opens, paste your SQL. Click OK to return to Design page. Drag field to Details section. Profit.