I created a report using the Wizard and like the way it looks, but I cannot figure out how to set the command query. Currently it is directly linked to a table. Depending on parameters though, I will need to query different sql and get the same report.

Okay, I figured out the command query with parameters. Just had to learn the syntax for the parameters.

Sorry for those of you that may be learning Crystal Reports like me, I realize my previous post wasn't a very descriptive solution.

In the Database Expert window, I drilled down into the Create New Connection. Then I selected the database type I wanted to use and rather than picking a table. You pick Add Command and then insert your sql statement with your parameter in the format {?varName}.

Hope that helped someone.