I have a report developed using Crystal Reports XI and i have embedded SQL a statement in a command. The problem I am having is that the report is now taking a very long time (15mins+) to run but the other version of the same report which makes use of tables only is very quick (1-2mins).
Am I doing something wrong? What should I do correct this

Yes, i have just one table that i am joining to the command

Take out the Table from your report and join that table in your main query itself. So that the whole sql will execute in single run and fetch records to your report. Also check the kind of Data connectivity you are using for the report. Doing joins at the crystal report level takes more time for huge no of records than a direct query fetch.