Change the SQL request of report

Question

Hi

I'm creating a report using the Crystal Report for Visual Studio 2010 but I dont know how to change the SQL request.

Thanks.

Answer 1

good

I tried to change the sql request but we can not change it after the creation of the report by cons at the time of creation using the wizzard we can selects new command, and at this level we introduce our request.

Thanks again.

Answer 2

I don't think you can directly change any SQL that Crystal Reports generates.

If you want to control the query yourself, you can perform your own query first and pass in your DataSet to Crystal Reports.