How to use SQL query in reports

[t_a_k_2002]

How can I use SQL commands in Reports?

and I want use JOIN based on LIKE key

[neiden]

There is a menu option called Database, start there by connecting a database and adding either tables or stored procedures. Under the Database menu you can find the option Show SQL query, just add whatever query you like and there you go :)

this works fine in my CR 8, don't know about other version though..

[ajay chani]

For crystal reports 9 and above you can go to Database Expert and under your connection click 'Add Command' and the resulting dialog box lets you add the exact SQL query you want and also lets you pass the parameters to the query....
You can then save this as a command object and also add it to repository.

:thumb: