Beginner

[sangeeramesh]

hi

i am using CR10. i am very new to this.i created a report using report wizard.but now i want to modify the sqlquery.i try to open it in database menu.but i couldn't modify it.so how can i write the custom sql query for crystal reports.

thank u

[jggtz]

When you select one of the avaliable data sources, you will see an entry named "ADD COMMAND", click on it and after that click on > button. A new window will open that let you write your own query.
You can mix the resulting data set with other tables...
Good luck