creating reports with sql

[timmonarch]

Hi

I have been asked to create some reports using Crystal, I am not very fluent with Crystal but I am competant at writing SQL queries

Is there a way I can just import an SQL query to generate a report in Crystal?

I know you can view an exsisting reports SQL!!

Thanks

Tim

 

[lbass]

If you have version 9.0 or above, you should be able to go to database->your datasource->add command and paste an existing query there or create a new one.

-LB