Supplying my own Query Statement - Can it be done?

I am creating a Crystal 2008 report, and I'd like to provide it a T-SQL statement for data generation, instead of selecting and joining together t开发者_运维技巧ables. Can this be done?

Yes. In the Database Expert, after picking your connection, instead of choosing your tables, select "Add Command" and type your query in there.