Question: how to change sql query in crystal report 11?
Answer: 6 Answers. You are looking for Edit Command within the Database Expert ... see the screenshot below. Drag and create all the links required to connect the tables links. Then you can right click on the link and select Link Options Here you can change your joins and your final SQL query will change accordingly.